7 rows where qSpecies_id = 529

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)
95154 105979 DPW Maintained 1 Pyrus calleryana 'Cleveland' :: Ornamental Pear Tree 'Cleveland' 529 415 De Haro St 5 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 770296 6012057.7607 2106482.39696 37.7646784654506 -122.401486617939 (37.7646784654506, -122.401486617939) 14 3 8 28856 29
95764 105978 DPW Maintained 1 Pyrus calleryana 'Cleveland' :: Ornamental Pear Tree 'Cleveland' 529 415 De Haro St 4 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 770296 6012057.85881 2106472.16492 37.7646503760327 -122.401485559435 (37.7646503760327, -122.401485559435) 14 3 8 28856 29
107888 239232 DPW Maintained 1 Pyrus calleryana 'Cleveland' :: Ornamental Pear Tree 'Cleveland' 529 320 Church St 1 : Tree Private 2     2 Width 3ft   6004143.99896 2107037.13204 37.7657568919901 -122.428897780335 (37.7657568919901, -122.428897780335) 8 4 5 28862 3
110900 105975 DPW Maintained 1 Pyrus calleryana 'Cleveland' :: Ornamental Pear Tree 'Cleveland' 529 415 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 770296 6012063.31118 2106384.67685 37.7644104575886 -122.401460551957 (37.7644104575886, -122.401460551957) 14 3 8 28856 29
152492 105976 DPW Maintained 1 Pyrus calleryana 'Cleveland' :: Ornamental Pear Tree 'Cleveland' 529 415 De Haro St 2 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 770296 6012059.4558 2106418.56473 37.7645032910104 -122.401476268538 (37.7645032910104, -122.401476268538) 14 3 8 28856 29
188489 213909 DPW Maintained 1 Pyrus calleryana 'Cleveland' :: Ornamental Pear Tree 'Cleveland' 529 1447 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5992088.33251 2105587.87582 37.7610878772322 -122.470489805259 (37.7610878772322, -122.470489805259) 1 8 4 56 12
193434 105977 DPW Maintained 1 Pyrus calleryana 'Cleveland' :: Ornamental Pear Tree 'Cleveland' 529 415 De Haro St 3 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 770296 6012059.23491 2106428.83235 37.764531471273 -122.401477754202 (37.764531471273, -122.401477754202) 14 3 8 28856 29

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