trees

7 rows where SiteOrder = 4 and qSpecies_id = 118

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

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)
1354 194604 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 500 Wisconsin St 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 9ft   6012630.87805 2105129.76973 37.7609964125817 -122.39940937734 (37.7609964125817, -122.39940937734) 10 3 8 28856 29
20194 234027 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 415 Beacon St 4 Sidewalk: Property side : Yard Tree Private 2     1 Width 2ft   6002320.31614 2098303.69653 37.7416735709701 -122.43458097494 (37.7416735709701, -122.43458097494) 2 7 5 63 7
34924 119917 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 3801 Anza St 4 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5986865.48339 2111809.59249 37.7778675958491 -122.489010544635 (37.7778675958491, -122.489010544635) 11 6 2 55 26
75393 211524 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 401 Victoria St 4 Sidewalk: Property side : Yard Tree Private 2     7 Width 5ft   5993220.18266 2089909.96353 37.7181056496239 -122.465436324932 (37.7181056496239, -122.465436324932) 9 8 6 64 24
82922 132453 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 1111 Chestnut St 4 Front Yard : Yard Tree Private 2     4     6006425.62699 2120397.10656 37.8025689834206 -122.421955239867 (37.8025689834206, -122.421955239867) 5 9 1 28858 32
97518 109108 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 461X Cherry St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2015 12:00:00 AM 3   Permit Number 774020 5996243.86079 2114742.72809 37.7864641110096 -122.456779845468 (37.7864641110096, -122.456779845468) 11 6 1 54 31
131134 234025 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 1548 Noe St 4 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6003282.4474 2099242.36534 37.744305509797 -122.431321238289 (37.744305509797, -122.431321238289) 2 7 5 63 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)
);