trees

10 rows where Zip Codes = 28862 and qSpecies_id = 182

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qCareAssistant, Longitude, Fire Prevention Districts

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)
17152 31397 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 3850 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/26/1995 12:00:00 AM     Permit Number 34990 6003938.7782539 2105415.4152024 37.7612924290105 -122.429491931159 (37.7612924290105, -122.429491931159) 8 4 5 28862 3
52041 116223 Undocumented 4 Gleditsia triacanthos :: Honey Locust 182 195 COLLINGWOOD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6002090 2104773 37.7594236635512 -122.435840099174 (37.7594236635512, -122.435840099174) 2 4 5 28862 3
71767 228350 DPW Maintained 1 Gleditsia triacanthos :: Honey Locust 182 557 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002761.21744 2102085.63158 37.7520828972095 -122.433326669795 (37.7520828972095, -122.433326669795) 2 4 5 28862 22
123322 31399 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 3850 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/26/1995 12:00:00 AM     Permit Number 34990 6003938.7782539 2105415.4152024 37.7612924290105 -122.429491931159 (37.7612924290105, -122.429491931159) 8 4 5 28862 3
128865 37269 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 3720 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/2002 12:00:00 AM     Permit Number 44410 6003590.32041295 2103642.33347016 37.7564042340637 -122.430570577111 (37.7564042340637, -122.430570577111) 2 4 5 28862 3
143964 228349 DPW Maintained 1 Gleditsia triacanthos :: Honey Locust 182 583 Elizabeth St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002614.94604 2102076.64 37.7520499091975 -122.43383185498 (37.7520499091975, -122.43383185498) 2 4 5 28862 22
175031 31398 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 3850 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/26/1995 12:00:00 AM     Permit Number 34990 6003938.7782539 2105415.4152024 37.7612924290105 -122.429491931159 (37.7612924290105, -122.429491931159) 8 4 5 28862 3
178685 228348 DPW Maintained 1 Gleditsia triacanthos :: Honey Locust 182 583 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002602.26695 2102075.05902 37.7520448487029 -122.433875588106 (37.7520448487029, -122.433875588106) 2 4 5 28862 22
188175 63790 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 4064 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24476 6003436.69055965 2101294.50423962 37.7499489448753 -122.430934327568 (37.7499489448753, -122.430934327568) 2 4 5 28862 22
190664 228351 DPW Maintained 1 Gleditsia triacanthos :: Honey Locust 182 4064 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003447.69274 2101289.13778 37.7499348332265 -122.430895898552 (37.7499348332265, -122.430895898552) 2 4 5 28862 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)
);