trees
30 rows where Fire Prevention Districts = 6, Zip Codes = 28855 and qSpecies_id = 53
This data as json, CSV (advanced)
These facets timed out: Zip Codes, Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26933 | 120656 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 160 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
27040 | 120661 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 299X Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
40462 | 48697 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
43665 | 94218 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 246 01st St | 3 | Sidewalk: Property side : Pot | Tree | Private 2 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6014001.8 | 2114912.7 | 37.7879344554838 | -122.395353268636 | (37.7879344554838, -122.395353268636) | 6 | 2 | 9 | 28855 | 6 | ||
53416 | 48709 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
57627 | 114283 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 200X STEUART ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015060 | 2116254 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | 6 | 2 | 9 | 28855 | 6 | ||||
59324 | 94216 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1X Tehama St | 1 | Sidewalk: Property side : Pot | Tree | Private 2 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6013910.7 | 2114841.3 | 37.7877333404996 | -122.395663455814 | (37.7877333404996, -122.395663455814) | 6 | 2 | 9 | 28855 | 6 | ||
61686 | 100705 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
70254 | 48702 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
71167 | 114282 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 200X STEUART ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015060 | 2116254 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | 6 | 2 | 9 | 28855 | 6 | ||||
78580 | 114284 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 200X STEUART ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015060 | 2116254 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | 6 | 2 | 9 | 28855 | 6 | ||||
84798 | 48704 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
91220 | 120660 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 126 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
95808 | 48700 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
100582 | 48699 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
105004 | 100707 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
114816 | 120655 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 160 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
123162 | 114285 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 200X STEUART ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015060 | 2116254 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | 6 | 2 | 9 | 28855 | 6 | ||||
128659 | 120663 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 299X Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
129369 | 94220 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1X Tehama St | 5 | Sidewalk: Property side : Pot | Tree | Private 2 | Permit Number 53568 | 6013910.7 | 2114841.3 | 37.7877333404996 | -122.395663455814 | (37.7877333404996, -122.395663455814) | 6 | 2 | 9 | 28855 | 6 | ||||
132195 | 100706 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
132203 | 48698 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
145539 | 48701 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
165688 | 120662 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 299X Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
168885 | 48703 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
170466 | 114281 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 200X STEUART ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015060 | 2116254 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | 6 | 2 | 9 | 28855 | 6 | ||||
170512 | 94219 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 246 01st St | 4 | Sidewalk: Property side : Pot | Tree | Private 2 | 06/25/2010 12:00:00 AM | Permit Number 53568 | 6014001.8 | 2114912.7 | 37.7879344554838 | -122.395353268636 | (37.7879344554838, -122.395353268636) | 6 | 2 | 9 | 28855 | 6 | |||
182718 | 100710 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
187881 | 94217 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 246 01st St | 2 | Sidewalk: Property side : Pot | Tree | Private 2 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6014001.8 | 2114912.7 | 37.7879344554838 | -122.395353268636 | (37.7879344554838, -122.395353268636) | 6 | 2 | 9 | 28855 | 6 | ||
188290 | 100708 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 |
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) );