trees

10 rows where DBH = 3 and qSpecies_id = 86

✎ View and edit SQL

This data as json, CSV (advanced)

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)
7366 444 DPW Maintained 1 Taxus baccata :: Irish Yew 86 700X 23rd Ave 5 Median : Cutout Tree DPW 1     3 8-HOA   5988817.90932 2110395.27546 37.774098034723 -122.482152859676 (37.774098034723, -122.482152859676) 11 6 2 55 26
14557 179896 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1039 Woolsey St 3 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6008623.46871 2091235.83896 37.7226225602776 -122.412287269767 (37.7226225602776, -122.412287269767) 9 3 7 309 28
21064 45165 DPW Maintained 1 Taxus baccata :: Irish Yew 86 227 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/23/2001 12:00:00 AM 3   Permit Number 44015 5987719.09382 2114404.67144 37.7850427307042 -122.486248205367 (37.7850427307042, -122.486248205367) 11 6 1 55 26
34212 136690 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1101 Green St 3 Sidewalk: Property side : Yard Tree Private 2     3 Width 2ft   6007706.55666 2118838.72504 37.7983622165993 -122.417412065427 (37.7983622165993, -122.417412065427) 5 1 10 28858 32
53739 136691 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1101 Green St 4 Sidewalk: Property side : Yard Tree Private 2     3 Width 2ft   6007718.23454 2118839.56071 37.7983651681777 -122.417371715557 (37.7983651681777, -122.417371715557) 5 1 10 28858 32
69762 11201 DPW Maintained 1 Taxus baccata :: Irish Yew 86 100 Idora Ave 4 Median : Cutout Tree DPW 1     3 8   5995318.65927 2099418.1217 37.7443335470614 -122.458870864793 (37.7443335470614, -122.458870864793) 1 8 4 59 40
79283 179800 DPW Maintained 1 Taxus baccata :: Irish Yew 86 228 Rome St 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   5998609.28877 2088802.95321 37.7153753906268 -122.446728973961 (37.7153753906268, -122.446728973961) 9 7 6 28861 25
94276 179895 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1039 Woolsey St 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6008618.46635 2091234.88491 37.7226196599519 -122.412304494484 (37.7226196599519, -122.412304494484) 9 3 7 309 28
112107 179897 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1039 Woolsey St 4 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6008627.84918 2091236.6223 37.7226249569704 -122.412272182734 (37.7226249569704, -122.412272182734) 9 3 7 309 28
192961 136689 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1101 Green St 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 2ft   6007697.4603 2118837.4061 37.7983580833179 -122.41744344816 (37.7983580833179, -122.41744344816) 5 1 10 28858 32

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