trees
28 rows where qSpecies_id = 322
This data as json, CSV (advanced)
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
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) );