trees

8 rows where Neighborhoods (old) = 26 and qSpecies_id = 119

✎ 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)
17176 62603 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 792 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/07/1986 12:00:00 AM 6   Permit Number 22911 5984491.42084 2110500.08946 37.7741332293959 -122.497126446837 (37.7741332293959, -122.497126446837) 11 6 2 55 26
35504 118831 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 662 46th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5981671.941 2111218.67307 37.7759406157401 -122.506932665798 (37.7759406157401, -122.506932665798) 11 6 2 55 26
54242 804 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 680X 39th Ave 2 Median : Cutout Tree DPW 1     3 6-HOA   5983823.94935 2111143.69789 37.7758612538886 -122.499482885033 (37.7758612538886, -122.499482885033) 11 6 2 55 26
65564 120404 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 527 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5988748.3356 2111702.11927 37.7776822169597 -122.482489301184 (37.7776822169597, -122.482489301184) 11 6 2 55 26
69086 61497 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 137 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/1984 12:00:00 AM 9   Permit Number 21447 5989576.46395 2114470.47527 37.7853314889271 -122.479827181582 (37.7853314889271, -122.479827181582) 11 6 2 55 26
138423 118733 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 706 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5982303.90559 2110925.66237 37.7751732905824 -122.504724857451 (37.7751732905824, -122.504724857451) 11 6 2 55 26
145580 48553 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 378 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM 3   Permit Number 45869 5990302.44703 2112853.20794 37.7809330733125 -122.477197298017 (37.7809330733125, -122.477197298017) 11 6 2 55 26
171515 61499 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 154 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/27/1984 12:00:00 AM 7   Permit Number 21452 5989629.6033 2114330.31946 37.7849497475064 -122.47963307901 (37.7849497475064, -122.47963307901) 11 6 2 55 26

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