trees

41 rows where Fire Prevention Districts = 2 and qSpecies_id = 54 sorted by YCoord

✎ View and edit SQL

This data as json, CSV (advanced)

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)
172312 527 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2836 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6009841.2951 2102226.6843 37.7528693162895 -122.408852546362 (37.7528693162895, -122.408852546362) 2 4 7 28859 19
187119 524 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2826 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6009890.4218 2102229.0519 37.7528785688198 -122.408682823354 (37.7528785688198, -122.408682823354) 2 4 7 28859 19
831 245412 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2802 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     19 Width 0ft   6009963.8161 2102233.787 37.7528956807716 -122.408429345015 (37.7528956807716, -122.408429345015) 2 4 7 28859 19
6070 519 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2802 24th St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6009998.1456 2102238.5221 37.7529106047271 -122.408310960592 (37.7529106047271, -122.408310960592) 2 4 7 28859 19
18387 245411 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2792 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 0ft   6010069.4683 2102240.5937 37.7529202865107 -122.408064458251 (37.7529202865107, -122.408064458251) 2 4 7 28859 19
67867 513 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2792 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6010090.1844 2102241.1856 37.7529230716135 -122.407992859485 (37.7529230716135, -122.407992859485) 2 4 7 28859 19
56271 514 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2790 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6010107.5289 2102242.0067 37.7529262972422 -122.407932936557 (37.7529262972422, -122.407932936557) 2 4 7 28859 19
17488 245410 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2782 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     19 Width 0ft   6010125.3081 2102244.3008 37.7529335917078 -122.407871614204 (37.7529335917078, -122.407871614204) 2 4 7 28859 19
5046 245409 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2778 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 Width 0ft   6010163.1606 2102247.1684 37.7529435845832 -122.40774091468 (37.7529435845832, -122.40774091468) 2 4 7 28859 19
137337 501 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2754 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 5x5   6010215.9248 2102247.7419 37.7529481129231 -122.407558485659 (37.7529481129231, -122.407558485659) 2 4 7 28859 19
61639 498 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2752 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6010250.9097 2102250.6095 37.7529579449469 -122.40743770282 (37.7529579449469, -122.40743770282) 2 4 7 28859 19
184065 15445 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2250 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006857.7723 2105245.8857 37.7609917781074 -122.419384314212 (37.7609917781074, -122.419384314212) 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)
);