trees

10 rows where qSpecies_id = 405

✎ 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)
24149 228368 DPW Maintained 1 Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 2882 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009558.02863 2102797.82938 37.754421682229 -122.409872452475 (37.754421682229, -122.409872452475) 2 4 7 28859 19
27615 62686 DPW Maintained 1 Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 10 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/09/1986 12:00:00 AM 8   Permit Number 23022 6012810.13629 2107011.05284 37.7661719884608 -122.398921439372 (37.7661719884608, -122.398921439372) 14 3 8 28856 20
47803 190627 DPW Maintained 1 Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 10 Arkansas St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6012810.38261 2107000.50042 37.7661430275937 -122.398919846697 (37.7661430275937, -122.398919846697) 14 3 8 28856 20
97835 228371 DPW Maintained 1 Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 2882 23rd St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009506.55438 2102796.14519 37.7544141729027 -122.410050345568 (37.7544141729027, -122.410050345568) 2 4 7 28859 19
120482 228366 DPW Maintained 1 Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 2622 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010258.40115 2104006.9766 37.7577809567352 -122.407535616302 (37.7577809567352, -122.407535616302) 10 4 7 28859 19
122999 190629 DPW Maintained 1 Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 10 Arkansas St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6012813.49135 2106926.75638 37.7659407161217 -122.398903917896 (37.7659407161217, -122.398903917896) 14 3 8 28856 20
137732 228370 DPW Maintained 1 Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 2882 23rd St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009524.753 2102796.54439 37.7544162890042 -122.409987437966 (37.7544162890042, -122.409987437966) 2 4 7 28859 19
156830 228367 DPW Maintained 1 Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 2 Lexington St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006418.48215 2105819.2284 37.7625412913763 -122.420944338021 (37.7625412913763, -122.420944338021) 8 4 7 28859 19
168570 190628 DPW Maintained 1 Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 10 Arkansas St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6012814.04326 2106938.8215 37.7659738750056 -122.398902855807 (37.7659738750056, -122.398902855807) 14 3 8 28856 20
184095 228369 DPW Maintained 1 Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 2882 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6009544.49144 2102796.527 37.754417347508 -122.409919175836 (37.754417347508, -122.409919175836) 2 4 7 28859 19

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