16 rows where Neighborhoods (old) = 32 and qSpecies_id = 5 sorted by Longitude

View and edit SQL

Neighborhoods (old)

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)
49612 125976 DPW Maintained 1 Ceratonia siliqua :: Carob 5 633 Beach St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007074.37921 2121877.42075 37.8066701158897 -122.419815329109 (37.8066701158897, -122.419815329109) 5 1 1 28858 32
129067 51546 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2005 12:00:00 AM     Permit Number 47845 6007074.31830792 2121880.33708987 37.8066781199827 -122.419815746942 (37.8066781199827, -122.419815746942) 5 1 1 28858 32
84314 125975 DPW Maintained 1 Ceratonia siliqua :: Carob 5 633 Beach St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007035.47478 2121873.14157 37.8066561746197 -122.419949661756 (37.8066561746197, -122.419949661756) 5 1 1 28858 32
146048 125974 DPW Maintained 1 Ceratonia siliqua :: Carob 5 633 Beach St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6007013.05823 2121870.81717 37.8066485294743 -122.420027073604 (37.8066485294743, -122.420027073604) 5 1 1 28858 32
167066 125973 DPW Maintained 1 Ceratonia siliqua :: Carob 5 633 Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6006932.43872 2121860.17562 37.8066147680158 -122.420305317544 (37.8066147680158, -122.420305317544) 5 1 1 28858 32
77396 125972 DPW Maintained 1 Ceratonia siliqua :: Carob 5 633 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6006913.21617 2121857.59743 37.8066066057793 -122.420371657826 (37.8066066057793, -122.420371657826) 5 1 1 28858 32
85699 11179 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2750X Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     36 3x3   6006893.59102 2121789.4662 37.8064184289444 -122.4204347354 (37.8064184289444, -122.4204347354) 5 1 1 28858 32
140473 11180 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2750X Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006892.18437 2121805.14198 37.806461391357 -122.420440716763 (37.806461391357, -122.420440716763) 5 1 1 28858 32
95994 11181 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2750X Hyde St 3 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6006890.68476 2121823.94924 37.8065129467732 -122.420447242256 (37.8065129467732, -122.420447242256) 5 1 1 28858 32
139674 101042 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47845 6006837 2121873 37.8066446021589 -122.420636512845 (37.8066446021589, -122.420636512845) 5 1 1 28858 32
145716 101044 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47845 6006837 2121873 37.8066446021589 -122.420636512845 (37.8066446021589, -122.420636512845) 5 1 1 28858 32
156506 101043 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47845 6006837 2121873 37.8066446021589 -122.420636512845 (37.8066446021589, -122.420636512845) 5 1 1 28858 32
161042 101045 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47845 6006837 2121873 37.8066446021589 -122.420636512845 (37.8066446021589, -122.420636512845) 5 1 1 28858 32
60751 64436 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2445 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/1988 12:00:00 AM 12   Permit Number 25292 6006658.75135 2119650.10198 37.8005310432266 -122.421095439396 (37.8005310432266, -122.421095439396) 5 9 1 28858 32
149796 23565 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2958 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 2X2   6005634.29929 2120573.5209 37.8030087114389 -122.424706189543 (37.8030087114389, -122.424706189543) 5 9 1 28858 32
122812 23566 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2958 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2005 12:00:00 AM 6     6005632.06356 2120580.68582 37.8030282582004 -122.424714436346 (37.8030282582004, -122.424714436346) 5 9 1 28858 32

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