10 rows where qSpecies_id = 333

View and edit SQL

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)
9993 47292 Permitted Site 7 Ailanthus altissima :: Tree Of Heaven 333 2801x 19TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2002 12:00:00 AM     Permit Number 45232 6009524 2104958 37.7603511166103 -122.410142631678 (37.7603511166103, -122.410142631678) 2 4 7 28859 19
31159 221969 DPW Maintained 1 Ailanthus altissima :: Tree Of Heaven 333 3900 22nd St 9 Sidewalk: Curb side : Pot Tree Private 2     5 Width 4ft   6002406.82062 2102995.69652 37.7545616068583 -122.434617293171 (37.7545616068583, -122.434617293171) 2 4 5 28862 22
36736 101527 Significant Tree 6 Ailanthus altissima :: Tree Of Heaven 333 151-153 Lower Ter 1 Front Yard : Yard Tree Private 2     18   Permit Number 769490 6000139.7 2106146.6 37.7630842500585 -122.4426838025 (37.7630842500585, -122.4426838025) 15 5 5 28862 3
67155 187969 DPW Maintained 1 Ailanthus altissima :: Tree Of Heaven 333 1630 Jerrold Ave 1 : Tree Private 2     5 Width 3ft   6015189.03434 2097156.64279 37.7392461326034 -122.390004769231 (37.7392461326034, -122.390004769231) 10 3 8 58 1
71457 215470 DPW Maintained 1 Ailanthus altissima :: Tree Of Heaven 333 2 Sola Ave 1 Sidewalk: Curb side : Yard Tree Private 2     17 Width 4ft   5994985.87708 2100710.42792 37.7478627619652 -122.460115152419 (37.7478627619652, -122.460115152419) 1 8 4 29491 40
105473 187968 DPW Maintained 1 Ailanthus altissima :: Tree Of Heaven 333 600 Illinois St 3 Sidewalk: Curb side : Pot Tree Private 2     10 Width 3ft   6015942.9159 2106228.07287 37.7641961608518 -122.388031024433 (37.7641961608518, -122.388031024433) 14 3 8 28856 29
107229 255805 Significant Tree 6 Ailanthus altissima :: Tree Of Heaven 333 2 Sola Ave 1 Front Yard : Yard Tree Private 2       10x10   5994994 2100719 37.7478867659483 -122.460087684856 (37.7478867659483, -122.460087684856) 1 8 4 29491 40
130003 187970 DPW Maintained 1 Ailanthus altissima :: Tree Of Heaven 333 1630 Jerrold Ave 2 : Tree Private 2     5 Width 3ft   6015180.35371 2097164.4459 37.7392670769075 -122.390035328173 (37.7392670769075, -122.390035328173) 10 3 8 58 1
167607 221970 DPW Maintained 1 Ailanthus altissima :: Tree Of Heaven 333 3900 22nd St 10 Sidewalk: Curb side : Pot Tree Private 2     5 Width 4ft   6002405.12131 2102995.45063 37.7545608352344 -122.434623152247 (37.7545608352344, -122.434623152247) 2 4 5 28862 22
185733 175228 DPW Maintained 1 Ailanthus altissima :: Tree Of Heaven 333 102 France Ave 7 Sidewalk: Property side : Yard Tree Private 2     3 Width 1ft   6001368.13444 2090223.95068 37.7194343448899 -122.437294890573 (37.7194343448899, -122.437294890573) 9 7 6 28861 5

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