trees

107 rows where qSpecies_id = 105 sorted by Zip Codes

✎ View and edit SQL

This data as json, CSV (advanced)

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)
97804 111273 DPW Maintained 1 Acacia spp :: Acacia Spp 105 700X BOSWORTH ST 12 Front Yard : Yard Tree DPW 1     3     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
125742 121169 Significant Tree 6 Acacia spp :: Acacia Spp 105 900x Duncan St 2 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 6000584 2099647 37.745263242779 -122.440680889831 (37.745263242779, -122.440680889831) 2 7 5 63 7
150739 121178 Significant Tree 6 Acacia spp :: Acacia Spp 105 990x Duncan St 2 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 6000056 2099639 37.7452111944111 -122.442506045398 (37.7452111944111, -122.442506045398) 2 7 5 63 22
161963 247794 DPW Maintained 1 Acacia spp :: Acacia Spp 105 400 30th St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6003904.95936 2098390.44072 37.7420015807231 -122.429107993255 (37.7420015807231, -122.429107993255) 2 7 5 63 22
188209 121179 Significant Tree 6 Acacia spp :: Acacia Spp 105 990x Duncan St 3 Front Yard : Yard Tree Private 2       3x3   6000056 2099639 37.7452111944111 -122.442506045398 (37.7452111944111, -122.442506045398) 2 7 5 63 22
193227 111275 DPW Maintained 1 Acacia spp :: Acacia Spp 105 700X BOSWORTH ST 13 Front Yard : Yard Tree DPW 1     3     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
164714 107498 Undocumented 4 Acacia spp :: Acacia Spp 105 130 DENSLOWE DR 1 Front Yard : Yard Tree Private 2           5990637.6 2091559.3 37.7224850335031 -122.474483407877 (37.7224850335031, -122.474483407877) 9 8 4 64 40

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