trees

6 rows where Neighborhoods (old) = 7 and qSpecies_id = 119

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: 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)
37110 224114 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1100 San Jose Ave 70 Front Yard : Yard Tree Private 2     6     6004687.50549 2096549.18122 37.736990167061 -122.42627113673 (37.736990167061, -122.42627113673) 2 7 5 63 7
71542 224112 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1100 San Jose Ave 51 Sidewalk: Property side : Yard Tree Private 2     5     6004737.84332 2096628.18536 37.7372099397936 -122.426102718871 (37.7372099397936, -122.426102718871) 2 7 5 63 7
71753 224115 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1100 San Jose Ave 71 Front Yard : Yard Tree Private 2     8     6004680.7613 2096547.43611 37.7369849941684 -122.426294330213 (37.7369849941684, -122.426294330213) 2 7 5 63 7
84688 224113 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1100 San Jose Ave 69 Front Yard : Yard Tree Private 2     4     6004690.02185 2096554.43933 37.7370047468799 -122.426262810788 (37.7370047468799, -122.426262810788) 2 7 5 63 7
89861 224111 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1100 San Jose Ave 50 Sidewalk: Property side : Yard Tree Private 2     4     6004733.53405 2096634.51546 37.7372270772601 -122.426118068508 (37.7372270772601, -122.426118068508) 2 7 5 63 7
188891 111509 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 800x BOSWORTH ST 4 Front Yard : Yard Tree DPW 1     4     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7

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