trees

17 rows where Neighborhoods (old) = 22 and qSpecies_id = 133

✎ View and edit SQL

This data as json, CSV (advanced)

Neighborhoods (old) ✖

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)
33319 54717 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 3609 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2002 12:00:00 AM     Permit Number 24726 6004298.03079874 2103629.31683929 37.756408560199 -122.428122138519 (37.756408560199, -122.428122138519) 2 4 5 28862 22
38562 66726 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 416 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1992 12:00:00 AM     Permit Number 31446 6003651.13955938 2102766.75784402 37.7540035558201 -122.430297777513 (37.7540035558201, -122.430297777513) 2 4 5 28862 22
52691 63792 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 4094 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24478 6003252.0069668 2101284.19573809 37.7499101740217 -122.431572236451 (37.7499101740217, -122.431572236451) 2 4 5 28862 22
63437 60436 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 474 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/16/2004 12:00:00 AM     Permit Number 20020 6003505.36219814 2098957.85837164 37.7435369501722 -122.430530149996 (37.7435369501722, -122.430530149996) 2 7 5 63 22
65845 223047 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 3864 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6004003.36703 2102490.39098 37.7532646621477 -122.429059987437 (37.7532646621477, -122.429059987437) 2 4 5 28862 22
80974 62145 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 75 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/06/1985 12:00:00 AM     Permit Number 22258 6005427.84181989 2099597.4165714 37.7454017512266 -122.423928154749 (37.7454017512266, -122.423928154749) 2 7 5 28859 22
85025 48468 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1409 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/06/2002 12:00:00 AM     Permit Number 45831 6003303.13281599 2100036.19716336 37.7464863595987 -122.431306366847 (37.7464863595987, -122.431306366847) 2 7 5 63 22
91882 121558 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 400X Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6003675 2102779 37.7540385213778 -122.430216135756 (37.7540385213778, -122.430216135756) 2 4 5 28862 22
92777 247816 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 550 30th St 1 : Tree Private 2     5 Width 3ft   6003030.78831 2098349.34835 37.7418392269952 -122.432127661269 (37.7418392269952, -122.432127661269) 2 7 5 63 22
111061 223026 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 114 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004706.47094 2102901.67728 37.7544337331488 -122.426657794828 (37.7544337331488, -122.426657794828) 2 4 5 28862 22
132029 121560 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 400X Alvarado St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6003675 2102779 37.7540385213778 -122.430216135756 (37.7540385213778, -122.430216135756) 2 4 5 28862 22
149638 223046 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 77 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6005471.50149 2099604.561 37.7454238329391 -122.423777694396 (37.7454238329391, -122.423777694396) 2 7 5 28859 22
166632 47955 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 59 Homestead St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2002 12:00:00 AM     Permit Number 45685 6001000.20919275 2101375.03881203 37.7500317183297 -122.439365554728 (37.7500317183297, -122.439365554728) 2 4 5 28862 22
171056 223027 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 116 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6004711.20676 2102860.50548 37.754320952762 -122.426638485476 (37.754320952762, -122.426638485476) 2 4 5 28862 22
171197 223102 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 247 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/2017 12:00:00 AM 3 Width 3ft Permit Number 779888 6004283.79281 2099537.35517 37.7451721819657 -122.427879813411 (37.7451721819657, -122.427879813411) 2 7 5 63 22
176527 223048 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 3880 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6003922.51538 2102484.70879 37.7532444831531 -122.429339183778 (37.7532444831531, -122.429339183778) 2 4 5 28862 22
183578 35403 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 550 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1998 12:00:00 AM     Permit Number 38858 6003059.40190018 2098358.03858994 37.7418647106265 -122.432029345324 (37.7418647106265, -122.432029345324) 2 7 5 63 22

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