trees

16 rows where Neighborhoods (old) = 36 and qSpecies_id = 123

✎ View and edit SQL

This data as json, CSV (advanced)

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)
22375 87991 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 222 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51029 6008096 2113166 37.7828082078679 -122.41566260373 (37.7828082078679, -122.41566260373) 7 10 9 28852 36
31101 88015 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 77 McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51043 6008723.4 2112463.6 37.780914833514 -122.413442364822 (37.780914833514, -122.413442364822) 7 10 9 28852 36
55308 88011 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 144 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51041 6008609 2112967 37.7822906254359 -122.413873752004 (37.7822906254359, -122.413873752004) 7 10 9 28852 36
61643 88017 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 601 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51044 6008420 2114150 37.7855282422492 -122.414611351671 (37.7855282422492, -122.414611351671) 7 10 9 28852 36
65987 87988 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 233 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51028 6009741 2113986 37.785152065252 -122.410029478455 (37.785152065252, -122.410029478455) 14 10 9 28852 36
66669 88027 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 121 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51050 6008492.3 2112899.8 37.7820995557553 -122.414272727386 (37.7820995557553, -122.414272727386) 7 10 9 28852 36
87658 87989 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 233 Ellis St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51028 6009741 2113986 37.785152065252 -122.410029478455 (37.785152065252, -122.410029478455) 14 10 9 28852 36
88344 87993 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 248 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51031 6008142.6 2113255.6 37.7830568472778 -122.415507732402 (37.7830568472778, -122.415507732402) 7 10 9 28852 36
92525 88014 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 77 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51043 6008723.4 2112463.6 37.780914833514 -122.413442364822 (37.780914833514, -122.413442364822) 7 10 9 28852 36
99310 87994 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 248 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51031 6008142.6 2113255.6 37.7830568472778 -122.415507732402 (37.7830568472778, -122.415507732402) 7 10 9 28852 36
110478 88010 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 301 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51039 6008988 2113534 37.7838687491965 -122.412602670053 (37.7838687491965, -122.412602670053) 7 10 9 28852 36
119445 87990 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 233 Ellis St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51028 6009741 2113986 37.785152065252 -122.410029478455 (37.785152065252, -122.410029478455) 14 10 9 28852 36
132824 88009 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 360 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51038 6008030 2113635 37.7840922583142 -122.415924158968 (37.7840922583142, -122.415924158968) 7 10 9 28858 36
146243 88019 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 926 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51046 6007429 2114473 37.7863593952456 -122.418062835651 (37.7863593952456, -122.418062835651) 13 9 9 28858 36
155593 87995 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 120 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51032 6009094.1 2112956.3 37.7822884772374 -122.412194758861 (37.7822884772374, -122.412194758861) 14 10 9 28852 36
174823 88016 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 77 McAllister St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51043 6008723.4 2112463.6 37.780914833514 -122.413442364822 (37.780914833514, -122.413442364822) 7 10 9 28852 36

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