trees
70 rows where Zip Codes = 28855 and qSpecies_id = 53 sorted by PlantType
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3993 | 49288 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
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 | |||
32399 | 102602 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
40083 | 49240 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
40156 | 49286 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 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 | ||
45439 | 49260 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
45931 | 49235 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
46738 | 113373 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 HOWARD ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2015 12:00:00 AM | 3x3 | 6014757 | 2116474 | 37.7922633974731 | -122.39284966575 | (37.7922633974731, -122.39284966575) | 12 | 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 | ||
60857 | 49274 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 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 | ||
69985 | 49269 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 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 | ||||
81758 | 49264 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
84141 | 102599 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 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 | |||
85954 | 15110 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6014281.21891 | 2116519.09631 | 37.7923607834286 | -122.394499049528 | (37.7923607834286, -122.394499049528) | 12 | 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 | |||
91238 | 49276 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
95381 | 49285 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 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 | |||
95982 | 49266 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
98499 | 102601 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
100078 | 102598 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 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 | |||
103493 | 49277 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 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 | ||
111958 | 15109 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6014295.34515 | 2116528.26215 | 37.7923867359811 | -122.3944508141 | (37.7923867359811, -122.3944508141) | 12 | 2 | 9 | 28855 | 6 | |||
114688 | 49239 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 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 | |||
115493 | 15108 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6014309.51773 | 2116539.1619 | 37.7924174520023 | -122.394402539761 | (37.7924174520023, -122.394402539761) | 12 | 2 | 9 | 28855 | 6 | |||
117139 | 49290 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
118155 | 49258 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 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 | ||||
124192 | 15106 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6014335.21568 | 2116559.29701 | 37.7924741668095 | -122.394315033873 | (37.7924741668095, -122.394315033873) | 12 | 2 | 9 | 28855 | 6 | |||
125521 | 49234 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 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 | |||
128922 | 49236 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 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 | ||||
129463 | 49287 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
129993 | 49238 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 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 | |||
136842 | 49263 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
144032 | 49294 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 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 | |||
147296 | 49297 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
150564 | 102603 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
151649 | 49289 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
155305 | 102600 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
156149 | 49237 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
163880 | 15107 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6014322.84653 | 2116550.95179 | 37.7924505652168 | -122.394357247259 | (37.7924505652168, -122.394357247259) | 12 | 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 | |||
172671 | 49251 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
174050 | 49256 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
175879 | 15105 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6014344.93761 | 2116565.97781 | 37.7924930511311 | -122.394281863407 | (37.7924930511311, -122.394281863407) | 12 | 2 | 9 | 28855 | 6 | |||
177069 | 49259 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 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) );