trees

115 rows where Supervisor Districts = 7 and qSpecies_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

Supervisor 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)
180800 248209 DPW Maintained 1 Ceratonia siliqua :: Carob 5 37 Lundy's Ln 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007043.43628 2099296.21325 37.7446657917085 -122.418320324941 (37.7446657917085, -122.418320324941) 2 7 7 28859 2
180926 63125 Permitted Site 7 Ceratonia siliqua :: Carob 5 80 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1986 12:00:00 AM     Permit Number 23639 6007006.19001516 2099063.67894521 37.744025207978 -122.418432630519 (37.744025207978, -122.418432630519) 2 7 7 28859 2
181416 225043 DPW Maintained 1 Ceratonia siliqua :: Carob 5 463 Nevada St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6008911.67409 2096164.66425 37.7361722309519 -122.411639081583 (37.7361722309519, -122.411639081583) 10 7 7 28859 2
182447 224898 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1X Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007216.8564 2097735.11711 37.7403891304638 -122.417610047575 (37.7403891304638, -122.417610047575) 2 7 7 28859 2
183488 63120 Permitted Site 7 Ceratonia siliqua :: Carob 5 46 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1986 12:00:00 AM     Permit Number 23631 6007008.06371762 2099307.94192573 37.7446960047915 -122.418443468102 (37.7446960047915, -122.418443468102) 2 7 7 28859 2
184994 225046 DPW Maintained 1 Ceratonia siliqua :: Carob 5 901 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6009412.50008 2103884.66728 37.7573977376442 -122.41045246843 (37.7573977376442, -122.41045246843) 2 4 7 28859 19
185043 48532 Permitted Site 7 Ceratonia siliqua :: Carob 5 500(REVISED) Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM     Permit Number 45857 6007225.9541014 2104383.62172477 37.7586449307205 -122.41804980128 (37.7586449307205, -122.41804980128) 2 4 7 28859 19
187326 248200 DPW Maintained 1 Ceratonia siliqua :: Carob 5 53 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6006940.78232 2099105.37762 37.7441360208722 -122.418661752548 (37.7441360208722, -122.418661752548) 2 7 7 28859 2
188640 248208 DPW Maintained 1 Ceratonia siliqua :: Carob 5 37 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007034.71089 2099281.86096 37.7446258923754 -122.418349478271 (37.7446258923754, -122.418349478271) 2 7 7 28859 2
189232 248206 DPW Maintained 1 Ceratonia siliqua :: Carob 5 39 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007021.99675 2099262.74695 37.7445726938814 -122.41839208634 (37.7445726938814, -122.41839208634) 2 7 7 28859 2
190273 222903 DPW Maintained 1 Ceratonia siliqua :: Carob 5 164 Peralta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009951.59256 2100103.15651 37.7470447557132 -122.408321349458 (37.7470447557132, -122.408321349458) 2 7 7 28859 2
190680 63270 Permitted Site 7 Ceratonia siliqua :: Carob 5 15 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23827 6007494.42657363 2099465.13084364 37.7451549781049 -122.41677284932 (37.7451549781049, -122.41677284932) 2 7 7 28859 2
191608 248257 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6006778.60351 2098856.6294 37.7434438819296 -122.419204890889 (37.7434438819296, -122.419204890889) 2 7 7 28859 2
192516 60263 Permitted Site 7 Ceratonia siliqua :: Carob 5 2781 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/1984 12:00:00 AM     Permit Number 19819 6009497.44754454 2103916.17692673 37.7574890178355 -122.410160909746 (37.7574890178355, -122.410160909746) 2 4 7 28859 19
193801 248275 DPW Maintained 1 Ceratonia siliqua :: Carob 5 137 Lundy's Ln 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006752.53211 2098758.77008 37.743173713897 -122.419288098893 (37.743173713897, -122.419288098893) 2 7 7 28859 2

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