trees

12 rows where Neighborhoods (old) = 22 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)
47749 84105 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3909 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2008 12:00:00 AM   3x3 Permit Number 50417 6003719.39167552 2102426.4465388 37.7530730069117 -122.430037470862 (37.7530730069117, -122.430037470862) 2 4 5 28862 22
75224 52663 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 772 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM 4 3x3 Permit Number 50440 6001423.61779826 2102059.9147838 37.7519363103852 -122.437950438082 (37.7519363103852, -122.437950438082) 2 4 5 28862 22
84968 241376 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3777 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6004606.4364 2101890.62925 37.7516519753774 -122.426931737306 (37.7516519753774, -122.426931737306) 2 4 5 28862 22
92135 241378 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 273 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6004715.15963 2100148.28162 37.746874039199 -122.426431711567 (37.746874039199, -122.426431711567) 2 7 5 63 22
104248 241377 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 281 27th St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6004660.79755 2100144.09881 37.7468594809746 -122.426619392873 (37.7468594809746, -122.426619392873) 2 7 5 63 22
104883 241373 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3783 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6004532.87463 2101890.40961 37.7516472125622 -122.427186107874 (37.7516472125622, -122.427186107874) 2 4 5 28862 22
105739 43561 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 598 28th St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50500 6002046.37252319 2099459.05244765 37.7448303525831 -122.435610815213 (37.7448303525831, -122.435610815213) 2 7 5 63 22
109877 241372 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3783 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6004512.71197 2101888.89737 37.7516419200596 -122.427255725271 (37.7516419200596, -122.427255725271) 2 4 5 28862 22
115294 246445 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 457 Duncan St 1 : Tree Private 2     8 Width 3ft   6003558.45361 2099788.20108 37.7458198862793 -122.430405804901 (37.7458198862793, -122.430405804901) 2 7 5 63 22
116693 84100 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3909 23rd St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2008 12:00:00 AM   3x3 Permit Number 50417 6003719.39167552 2102426.4465388 37.7530730069117 -122.430037470862 (37.7530730069117, -122.430037470862) 2 4 5 28862 22
123335 241374 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3783 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004551.11836 2101892.73239 37.7516546220636 -122.427123184105 (37.7516546220636, -122.427123184105) 2 4 5 28862 22
141067 241375 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3783 24th St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6004575.52977 2101893.77166 37.7516588560771 -122.427038840268 (37.7516588560771, -122.427038840268) 2 4 5 28862 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)
);