trees

13 rows where DBH = 15 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)
20747 215303 DPW Maintained 1 Taxus baccata :: Irish Yew 86 681 Joost Ave 4 Sidewalk: Property side : Yard Tree Private 2     15     5997546.26853 2094964.87379 37.7322337966419 -122.450847264584 (37.7322337966419, -122.450847264584) 9 7 4 59 40
34915 215298 DPW Maintained 1 Taxus baccata :: Irish Yew 86 185 Hearst Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6000134.87473 2094332.54938 37.7306454275316 -122.441852526992 (37.7306454275316, -122.441852526992) 9 7 4 63 40
37296 179836 DPW Maintained 1 Taxus baccata :: Irish Yew 86 201 Cayuga Ave 1 Sidewalk: Property side : Yard Tree Private 2     15 Width 2ft   6002646.43295 2094204.87454 37.7304376544756 -122.433160577611 (37.7304376544756, -122.433160577611) 9 7 5 28861 25
40704 136716 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1599 North Point St 14 Side Yard : Yard Tree Private 2     15 Width 7ft   6003215.33658 2120983.87446 37.8039985196804 -122.43310638985 (37.8039985196804, -122.43310638985) 13 9 1 57 17
73016 120230 DPW Maintained 1 Taxus baccata :: Irish Yew 86 154 25th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   5988064.78369 2114963.42937 37.7865970627596 -122.485093253087 (37.7865970627596, -122.485093253087) 11 6 1 55 33
87437 179846 DPW Maintained 1 Taxus baccata :: Irish Yew 86 29 Colonial Way 2 Sidewalk: Property side : Yard Tree Private 2     15 Width 3ft   6000367.54069 2093586.66565 37.7286106583386 -122.440994678056 (37.7286106583386, -122.440994678056) 9 7 6 28861 25
129526 215329 DPW Maintained 1 Taxus baccata :: Irish Yew 86 415 Dewey Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     15 Width 3ft   5995144.12297 2100352.21108 37.7468882889814 -122.459542009073 (37.7468882889814, -122.459542009073) 1 8 4 59 40
133639 121844 DPW Maintained 1 Taxus baccata :: Irish Yew 86 518 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2     15 Width 3ft   5990041.13259 2111807.14387 37.7780457072257 -122.478024804476 (37.7780457072257, -122.478024804476) 11 6 2 55 26
134209 136658 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1599 North Point St 6 Side Yard : Yard Tree Private 2     15 Width 7ft   6003175.48548 2120978.26665 37.8039808614944 -122.433243896185 (37.8039808614944, -122.433243896185) 13 9 1 57 17
145870 197909 DPW Maintained 1 Taxus baccata :: Irish Yew 86 75 Arkansas St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6012886.11406 2106697.30378 37.7653147367117 -122.398636625887 (37.7653147367117, -122.398636625887) 14 3 8 28856 20
149391 215296 DPW Maintained 1 Taxus baccata :: Irish Yew 86 615 Hearst Ave 3 Sidewalk: Property side : Yard Tree Private 2     15 Width 5ft   5997379.68023 2094370.54244 37.7305923666319 -122.451380344931 (37.7305923666319, -122.451380344931) 9 7 4 28861 40
167373 215302 DPW Maintained 1 Taxus baccata :: Irish Yew 86 698 Hearst Ave 9 Sidewalk: Property side : Yard Tree Private 2     15 Width 5ft   5996836.53539 2094438.39167 37.7307475482438 -122.453262964135 (37.7307475482438, -122.453262964135) 9 7 4 59 40
193341 120231 DPW Maintained 1 Taxus baccata :: Irish Yew 86 154 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   5988063.88277 2114955.73403 37.7865758810738 -122.485095805195 (37.7865758810738, -122.485095805195) 11 6 1 55 33

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