trees

18 rows where DBH = 17, qLegalStatus_id = 1 and qSpecies_id = 65 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

qLegalStatus_id ✖

  • DPW Maintained · 18 ✖

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)
15715 70376 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1434 43rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   17     5982801.126 2105356.1278 37.7599101850833 -122.502592561024 (37.7599101850833, -122.502592561024) 1 8 3 56 35
36087 67371 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1009 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1992 12:00:00 AM 17   Permit Number 30864 5992480.35304 2110659.61111 37.7750361697588 -122.469503188985 (37.7750361697588, -122.469503188985) 11 6 2 54 11
83049 39933 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 180 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/1999 12:00:00 AM 17   Permit Number 41204 6010299.07366 2087996.8284 37.7138227857583 -122.406266946271 (37.7138227857583, -122.406266946271) 9 7 8 309 39
169489 63578 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1359 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/30/1987 12:00:00 AM 17   Permit Number 24201 6006442.54317 2119356.06995 37.799711515327 -122.421822711261 (37.799711515327, -122.421822711261) 13 9 1 28858 32
174046 37616 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 462 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/26/2000 12:00:00 AM 17   Permit Number 43442 5990631.36651 2112225.85325 37.7792296086918 -122.476013583462 (37.7792296086918, -122.476013583462) 11 6 2 54 26
180027 114084 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 20 Cook St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   17     5997493.8327 2113562.2002 37.7832943866098 -122.452370058209 (37.7832943866098, -122.452370058209) 15 6 1 54 31
33220 139917 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1000 LAGUNA ST 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6004809.1682 2112368.8803 37.7804342038606 -122.426976875009 (37.7804342038606, -122.426976875009) 7 9 11 28852 41
162255 181649 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1265 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   5986124.6924 2106639.2388 37.7636279963988 -122.491192553457 (37.7636279963988, -122.491192553457) 1 8 3 56 35
151528 175210 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 66 Madison St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 2ft   6005427.44885 2093231.28592 37.7279217605751 -122.423477009653 (37.7279217605751, -122.423477009653) 9 7 6 28861 5
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
72140 221898 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 7 Marsily St 5 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6004300.13641 2095569.34378 37.7342778513286 -122.427540659282 (37.7342778513286, -122.427540659282) 2 7 5 28861 25
159587 203566 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 209 Colon Ave 2 Sidewalk: Curb side : Yard Tree Private 2     17 Width 3ft   5996063.41122 2094232.89601 37.7301389635391 -122.455920909543 (37.7301389635391, -122.455920909543) 9 7 4 28861 40
164548 175191 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 193 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6010202.71269 2087988.02388 37.7137932196449 -122.406599386967 (37.7137932196449, -122.406599386967) 9 7 8 309 39
91243 221828 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1070 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6008613.25764 2102303.67809 37.7530118609308 -122.413104786776 (37.7530118609308, -122.413104786776) 2 4 7 28859 19
145252 123201 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1310 09th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   5993108.25102 2112027.19449 37.7788274527304 -122.467430639975 (37.7788274527304, -122.467430639975) 11 6 2 54 11
30130 221910 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1175 Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6003225.80615 2101486.76003 37.7504648828526 -122.431677300586 (37.7504648828526, -122.431677300586) 2 4 5 28862 22
92331 125545 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3211 Sacramento St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   5999423.84524 2115333.31799 37.7882677951647 -122.445820424872 (37.7882677951647, -122.445820424872) 13 6 1 29490 31
100205 221884 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 230 Esmeralda Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6007166.67292 2098807.97162 37.7433321258706 -122.417859593245 (37.7433321258706, -122.417859593245) 2 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)
);