trees

9 rows where Zip Codes = 28862 and qSpecies_id = 66

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

  • 28862 · 9 ✖
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)
8510 259163 Private 9 Shrub :: Shrub 66 1 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
9208 259164 Private 9 Shrub :: Shrub 66 1 Corbett Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
9604 56991 Permitted Site 7 Shrub :: Shrub 66 4160 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1974 12:00:00 AM     Permit Number 767882 6002854.60493399 2100676.90172362 37.7482201548247 -122.432903090117 (37.7482201548247, -122.432903090117) 2 4 5 28862 22
16349 259165 Private 9 Shrub :: Shrub 66 1 Corbett Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
25702 89015 DPW Maintained 1 Shrub :: Shrub 66 4437 20th St   Sidewalk: Curb side : Cutout Landscaping Private 2   09/30/2008 12:00:00 AM   3x1 Permit Number 51764 6001659 2104076 37.7574853780776 -122.437280798466 (37.7574853780776, -122.437280798466) 2 4 5 28862 3
34209 107409 DPW Maintained 1 Shrub :: Shrub 66 125 VILLA TER 1 Sidewalk: Curb side : Cutout Landscaping Private 2           5999028.2 2104385.8 37.7581861070008 -122.446401410764 (37.7581861070008, -122.446401410764) 2 5 5 28862 3
67643 92611 DPW Maintained 1 Shrub :: Shrub 66 3856 23rd St   Sidewalk: Property side : Pot Landscaping Private 2   08/31/2009 12:00:00 AM     Permit Number 52924 6004067 2102488 37.7532616988935 -122.428839761175 (37.7532616988935, -122.428839761175) 2 4 5 28862 22
101202 88829 DPW Maintained 1 Shrub :: Shrub 66 4437 20th St   Sidewalk: Curb side : Cutout Landscaping Private 2   09/30/2008 12:00:00 AM   8x1 Permit Number 51764 6001659 2104076 37.7574853780776 -122.437280798466 (37.7574853780776, -122.437280798466) 2 4 5 28862 3
143620 106469 Undocumented 4 Shrub :: Shrub 66 100X HENRY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 5x5   6002548 2107375 37.7665941299684 -122.434442151396 (37.7665941299684, -122.434442151396) 15 5 5 28862 3

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