28 rows where qSpecies_id = 322

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)
8524 593 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 3055 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6008560.02694 2102081.19084 37.7523979726269 -122.413273137321 (37.7523979726269, -122.413273137321) 2 4 7 28859 19
9753 4511 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 20X Cleary Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004999.51904 2113885.82273 37.7846101140023 -122.426426402111 (37.7846101140023, -122.426426402111) 13 9 11 28858 41
12814 7340 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 2126 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/13/2017 12:00:00 AM 3 3X3   6002883.51227 2115702.89267 37.7894794841288 -122.433876990144 (37.7894794841288, -122.433876990144) 13 9 1 29490 27
15521 92387 Permitted Site 7 Ficus macrophylla :: Morton Bay Fig 322 2810 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52790 6001269 2116290 37.7909997773984 -122.439505117215 (37.7909997773984, -122.439505117215) 13 6 1 29490 27
22881 61822 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 2749 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/04/1985 12:00:00 AM 88   Permit Number 21854 5999853.53427 2118084.4694 37.7958462579399 -122.444531583082 (37.7958462579399, -122.444531583082) 13 9 1 57 17
31571 51880 Permitted Site 7 Ficus macrophylla :: Morton Bay Fig 322 3552 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2016 12:00:00 AM 3   Permit Number 48096 6005953.65643869 2102602.75030728 37.7536833804238 -122.422323460817 (37.7536833804238, -122.422323460817) 2 4 5 28859 19
33165 115318 Undocumented 4 Ficus macrophylla :: Morton Bay Fig 322 3370 WASHINGTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   5998663 2115944 37.7899010948859 -122.448496808995 (37.7899010948859, -122.448496808995) 13 6 1 54 31
40100 251597 Landmark tree 11 Ficus macrophylla :: Morton Bay Fig 322 1650 Valencia St 1 Side Yard : Yard Tree Private 2           6006336 2100501 37.7479340151765 -122.420852023863 (37.7479340151765, -122.420852023863) 2 7 7 28859 2
46700 4512 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 20X Cleary Ct 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004999.51904 2113885.82273 37.7846101140023 -122.426426402111 (37.7846101140023, -122.426426402111) 13 9 11 28858 41
48185 14816 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 1234 McAllister St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6003203.08523 2111751.85063 37.7786490478282 -122.43248898077 (37.7786490478282, -122.43248898077) 15 9 11 29490 41
50252 7355 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 2301 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     15 3x3   6002738.35026 2116220.4352 37.7908922847939 -122.434416252231 (37.7908922847939, -122.434416252231) 13 9 1 29490 27
51204 9688 Permitted Site 7 Ficus macrophylla :: Morton Bay Fig 322 332 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6006025.5202 2110969.11106 37.7766594813407 -122.422669436188 (37.7766594813407, -122.422669436188) 7 9 11 28852 10
51708 173779 Significant Tree 6 Ficus macrophylla :: Morton Bay Fig 322 99X Cleveland St 2 Side Yard : Yard Tree Private 2       3x6   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
66105 14658 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 655X McAllister St 8 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6006015.9359491 2112078.013352 37.7797037167615 -122.422781416289 (37.7797037167615, -122.422781416289) 7 9 11 28852 10
71196 10620 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 350 Gough St 3 Sidewalk: Curb side : Cutout Tree DPW 1     10 3x3   6005978.95579 2110975.75571 37.7766750987359 -122.422830988707 (37.7766750987359, -122.422830988707) 7 9 11 28852 10
72257 14659 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 655X McAllister St 9 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6006015.9359491 2112078.013352 37.7797037167615 -122.422781416289 (37.7797037167615, -122.422781416289) 7 9 11 28852 10
91623 599 Permitted Site 7 Ficus macrophylla :: Morton Bay Fig 322 3077 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008567.5453 2102081.22398 37.7523984857225 -122.413247139853 (37.7523984857225, -122.413247139853) 2 4 7 28859 19
92644 113742 Landmark tree 11 Ficus macrophylla :: Morton Bay Fig 322 1580 Valencia St 2 Front Yard : Yard Tree Private 2     80     6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
99361 10619 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 350 Gough St 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 3x3   6006025.52151 2110969.11138 37.7766594822933 -122.422669431679 (37.7766594822933, -122.422669431679) 7 9 11 28852 10
99958 51879 Permitted Site 7 Ficus macrophylla :: Morton Bay Fig 322 3552 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2016 12:00:00 AM 3   Permit Number 48096 6005953.65643869 2102602.75030728 37.7536833804238 -122.422323460817 (37.7536833804238, -122.422323460817) 2 4 5 28859 19
124969 24811 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 2142 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6002873.2693 2115779.53407 37.7896893405692 -122.433917910141 (37.7896893405692, -122.433917910141) 13 9 1 29490 27
150211 26549 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 3085 24th St 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6008510.86068 2102109.80452 37.7524737788845 -122.413445186333 (37.7524737788845, -122.413445186333) 2 4 7 28859 19
161208 4514 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 20X Cleary Ct 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004999.51904 2113885.82273 37.7846101140023 -122.426426402111 (37.7846101140023, -122.426426402111) 13 9 11 28858 41
171307 27623 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 3085 24th St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6008510.86068 2102109.80452 37.7524737788845 -122.413445186333 (37.7524737788845, -122.413445186333) 2 4 7 28859 19
181830 10621 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 350 Gough St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6006025.52151 2110969.11138 37.7766594822933 -122.422669431679 (37.7766594822933, -122.422669431679) 7 9 11 28852 10
186262 4513 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 20X Cleary Ct 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004999.51904 2113885.82273 37.7846101140023 -122.426426402111 (37.7846101140023, -122.426426402111) 13 9 11 28858 41
188372 7367 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 2400 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6002811.86324 2116558.11792 37.7918236474661 -122.434186051668 (37.7918236474661, -122.434186051668) 13 9 1 29490 27
190663 7369 DPW Maintained 1 Ficus macrophylla :: Morton Bay Fig 322 2401 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1   07/12/1996 12:00:00 AM 22 3X3   6002691.3684 2116552.51656 37.7918014280029 -122.434602562579 (37.7918014280029, -122.434602562579) 13 9 1 29490 27

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