21 rows where DBH = 3, SiteOrder = 3 and qSpecies_id = 65 sorted by qSpecies_id

View and edit SQL

SiteOrder

DBH

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)
8169 160453 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 99 France Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2020 12:00:00 AM 3 Width 0ft   6001205.1197 2090381.66789 37.7198581324333 -122.437869661652 (37.7198581324333, -122.437869661652) 9 7 6 28861 5
10290 90682 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3900 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5983432.26602 2110389.71572 37.7737680483939 -122.500782026808 (37.7737680483939, -122.500782026808) 11 6 2 55 26
24090 90673 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3750x CABRILLO ST 3 Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 04/07/2008 12:00:00 AM 3 3x3   5984009 2110380 37.7737752151611 -122.498786325695 (37.7737752151611, -122.498786325695) 11 6 2 55 26
43723 90660 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3500X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5984694.72726 2110433.79882 37.7739631265543 -122.496418292329 (37.7739631265543, -122.496418292329) 11 6 2 55 26
51801 90784 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3701X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5984081.19373 2110355.47188 37.7737121020185 -122.498534787816 (37.7737121020185, -122.498534787816) 11 6 2 55 26
52586 109284 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 1530 Sloat Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773632 5986383.9 2095952.1 37.7342991443311 -122.489510139546 (37.7342991443311, -122.489510139546) 1 8 3 64 35
67477 90697 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4100X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5982827.55624 2110364.98681 37.7736646287423 -122.502871948318 (37.7736646287423, -122.502871948318) 11 6 2 55 26
67823 103022 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 40X Coleridge St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/15/2013 12:00:00 AM 3 3x3 Permit Number 770067 6006901 2099544.2 37.7453386886112 -122.418830426928 (37.7453386886112, -122.418830426928) 2 7 7 28859 2
79370 90796 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3549 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5984574.63821 2110374.75064 37.7737939613496 -122.496829335351 (37.7737939613496, -122.496829335351) 11 6 2 55 26
108513 254649 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 929 Cayuga Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2018 12:00:00 AM 3 3x3 Permit Number 781532 6000895.17385 2091578.90462 37.7231278434042 -122.439026791536 (37.7231278434042, -122.439026791536) 9 7 6 28861 25
114939 90793 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3601 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5984413.80757 2110367.78962 37.7737654233107 -122.49738515175 (37.7737654233107, -122.49738515175) 11 6 2 55 26
117767 158241 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 225 Bemis St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2018 12:00:00 AM 3 3x3 Permit Number 778932 6003145.71012 2096365.89505 37.7363996353363 -122.431588728148 (37.7363996353363, -122.431588728148) 2 7 5 63 7
121570 90766 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3951X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/2008 12:00:00 AM 3 3x3   5983343.71874 2110330.47884 37.7736002020107 -122.501083938875 (37.7736002020107, -122.501083938875) 11 6 2 55 26
152099 90778 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3801X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/2008 12:00:00 AM 3 3x3   5983771.39601 2110344.03814 37.773662535505 -122.499605564361 (37.773662535505, -122.499605564361) 11 6 2 55 26
154640 90688 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4000X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5983129.59902 2110378.53332 37.7737195704462 -122.501828155386 (37.7737195704462, -122.501828155386) 11 6 2 55 26
154869 90808 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3403 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5985025.16514 2110390.85068 37.7738645554816 -122.495272101296 (37.7738645554816, -122.495272101296) 11 6 2 55 26
156379 90787 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3651 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5984249.69419 2110361.4466 37.7737383870444 -122.497952368705 (37.7737383870444, -122.497952368705) 11 6 2 55 26
164551 90753 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4139 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5982725.59216 2110306.95683 37.7734993021465 -122.503220354519 (37.7734993021465, -122.503220354519) 11 6 2 55 26
171554 21401 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2692X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054) 1 8 3 29491 35
175685 90772 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3899X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/2008 12:00:00 AM 3 3x3   5983556.085422 2110343.567935 37.7736486085903 -122.500350310129 (37.7736486085903, -122.500350310129) 11 6 2 55 26
187831 90759 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4101X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5982835.15592 2110311.87807 37.773519254193 -122.502841728095 (37.773519254193, -122.502841728095) 11 6 2 55 26

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