14 rows where qSpecies_id = 348

View and edit SQL

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)
12193 31672 DPW Maintained 1 Brachychiton populneus :: Bottle Tree 348 1435 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/12/1995 12:00:00 AM 5   Permit Number 35179 6007130.45469 2116245.44002 37.791209271644 -122.41922150408 (37.791209271644, -122.41922150408) 13 9 10 28858 21
18938 221280 DPW Maintained 1 Brachychiton populneus :: Bottle Tree 348 970 Elizabeth St 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6000248.03946 2101990.02339 37.7516774837438 -122.442010727629 (37.7516774837438, -122.442010727629) 2 4 5 28862 22
23308 188837 DPW Maintained 1 Brachychiton populneus :: Bottle Tree 348 649 Delancey St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6015787.114 2113113.03855 37.7830921248442 -122.389050649695 (37.7830921248442, -122.389050649695) 6 2 9 28856 6
53937 94690 Property Tree 8 Brachychiton populneus :: Bottle Tree 348 749 Congo St   Front Yard : Yard Tree Private 2   10/28/2010 12:00:00 AM     Permit Number 53820 6000274 2096023 37.735294937499 -122.441492809367 (37.735294937499, -122.441492809367) 9 7 4 63 40
72170 205638 DPW Maintained 1 Brachychiton populneus :: Bottle Tree 348 280 Joost Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 7ft   6000134.27006 2094973.65767 37.73240572724 -122.44190061462 (37.73240572724, -122.44190061462) 9 7 5 63 40
89701 246303 DPW Maintained 1 Brachychiton populneus :: Bottle Tree 348 3996 17th St 2 Sidewalk: Curb side : Pot Tree Private 2     2 Width 0ft   6002336.9866 2105888.8305 37.7625014908552 -122.435065705348 (37.7625014908552, -122.435065705348) 15 4 5 28862 3
97720 104310 Private 9 Brachychiton populneus :: Bottle Tree 348 3747 23RD ST 3 Sidewalk: Curb side : Cutout Tree Private 2     13 5x5   6004798 2102451 37.7532014528284 -122.426309178314 (37.7532014528284, -122.426309178314) 2 4 5 28862 22
99309 246304 DPW Maintained 1 Brachychiton populneus :: Bottle Tree 348 3996 17th St 3 Sidewalk: Curb side : Pot Tree Private 2     2 Width 0ft   6002336.3946 2105898.3028 37.7625274658745 -122.435068430359 (37.7625274658745, -122.435068430359) 15 4 5 28862 3
118237 246302 DPW Maintained 1 Brachychiton populneus :: Bottle Tree 348 3996 17th St 1 Sidewalk: Curb side : Pot Tree Private 2     3 Width 0ft   6002339.3547 2105882.3182 37.7624837441274 -122.43505704918 (37.7624837441274, -122.43505704918) 15 4 5 28862 3
122242 18553 DPW Maintained 1 Brachychiton populneus :: Bottle Tree 348 1700X Quesada Ave 8 Median : Cutout Tree DPW 1     30 19   6014639.83884 2095088.09279 37.7335358440919 -122.391759060533 (37.7335358440919, -122.391759060533) 10 3 8 58 1
137409 175570 DPW Maintained 1 Brachychiton populneus :: Bottle Tree 348 204 Hester Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6012727.17549 2087673.11869 37.7130694668578 -122.397851778545 (37.7130694668578, -122.397851778545) 10 3 8 309 1
146286 47251 DPW Maintained 1 Brachychiton populneus :: Bottle Tree 348 971 Le Conte Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/2002 12:00:00 AM 6   Permit Number 45194 6013290.77748 2089430.96828 37.7179275452075 -122.396026878752 (37.7179275452075, -122.396026878752) 10 3 8 58 1
148236 53621 Permitted Site 7 Brachychiton populneus :: Bottle Tree 348 4322 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2008 12:00:00 AM   3x3 Permit Number 51775 6001775.98851578 2101202.25628885 37.7496014166195 -122.436670506222 (37.7496014166195, -122.436670506222) 2 4 5 28862 22
151870 84879 DPW Maintained 1 Brachychiton populneus :: Bottle Tree 348 2042 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2007 12:00:00 AM 2   Permit No. 49242 5998038.6133 2110322.1176 37.7744291581359 -122.450251713519 (37.7744291581359, -122.450251713519) 15 5 11 29492 16

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