trees

1,626 rows where qSpecies_id = 53 sorted by Longitude

✎ View and edit SQL

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)
11514 258968 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 8 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
17682 258962 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
18544 258969 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 9 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
97368 64484 Permitted Site 7 Ficus nitida :: Laurel Fig 53 436 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/1988 12:00:00 AM     Permit Number 778749 6014198.52964849 2112913.46772182 37.782455962378 -122.39453256733 (37.782455962378, -122.39453256733) 6 2 9 28856 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
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
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
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
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
94460 101975 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1230 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769454 6013882 2105282.2 37.7614846061652 -122.395092936828 (37.7614846061652, -122.395092936828) 10 3 8 28856 29
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
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
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
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
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
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
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
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
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
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
63978 119667 Undocumented 4 Ficus nitida :: Laurel Fig 53 699x Missouri St 8 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
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
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
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
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
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
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
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
48959 112162 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1324 18th St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013680.97327942 2105726.70860795 37.7626939483281 -122.39581935837 (37.7626939483281, -122.39581935837) 14 3 8 28856 29
182806 112161 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1324 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013680.97327942 2105726.70860795 37.7626939483281 -122.39581935837 (37.7626939483281, -122.39581935837) 14 3 8 28856 29
9438 115058 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
18772 115057 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
38859 115059 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
55811 115056 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
109074 115054 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
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
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
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
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
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
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
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
43224 117205 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2           6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29
121552 117206 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2           6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29
143054 57622 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/15/1976 12:00:00 AM     Permit Number 16516 6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29
109428 116772 Undocumented 4 Ficus nitida :: Laurel Fig 53 376 MISSOURI ST 1 Sidewalk: Curb side : Cutout Tree Private 2       7x9   6013450 2105342 37.7616247710574 -122.396591249035 (37.7616247710574, -122.396591249035) 10 3 8 28856 29
100042 40805 Permitted Site 7 Ficus nitida :: Laurel Fig 53 585 Connecticut St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 41753 6013296.02646982 2104345.28151099 37.758879430057 -122.397053895785 (37.758879430057, -122.397053895785) 10 3 8 28856 29
182516 44225 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43670 6013393.18767606 2119056.04835121 37.799277245684 -122.397749707821 (37.799277245684, -122.397749707821) 3 1 10 28860 6
20131 113298 Undocumented 4 Ficus nitida :: Laurel Fig 53 700X DAVIS ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013208 2119104 37.7993985951424 -122.398393892143 (37.7993985951424, -122.398393892143) 3 1 10 28860 6
68154 113299 Undocumented 4 Ficus nitida :: Laurel Fig 53 700X DAVIS ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013208 2119104 37.7993985951424 -122.398393892143 (37.7993985951424, -122.398393892143) 3 1 10 28860 6
9205 96542 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100 Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767720 6013094 2116579 37.7924591936564 -122.398611089295 (37.7924591936564, -122.398611089295) 4 1 10 28860 6
118656 96541 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767720 6013094 2116579 37.7924591936564 -122.398611089295 (37.7924591936564, -122.398611089295) 4 1 10 28860 6
77443 111583 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 7 Sidewalk: Curb side : Cutout Tree Private 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
100521 111578 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
101430 111584 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 8 Sidewalk: Curb side : Cutout Tree Private 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
135125 45390 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 9 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2001 12:00:00 AM     Permit Number 44202 6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
138111 111582 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 6 Sidewalk: Curb side : Cutout Tree Private 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
157239 44224 Permitted Site 7 Ficus nitida :: Laurel Fig 53 150 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43669 6012974 2118691 37.7982515579635 -122.399174613744 (37.7982515579635, -122.399174613744) 3 1 10 28860 6
119084 173642 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 657 Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012793 2114089 37.7856054636163 -122.399477673173 (37.7856054636163, -122.399477673173) 6 2 9 28853 6
15941 85313 Significant Tree 6 Ficus nitida :: Laurel Fig 53 610 Brannan St 1 unknown : Cutout Tree Private 2         Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
124317 91126 Permitted Site 7 Ficus nitida :: Laurel Fig 53 610 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
185458 91127 Permitted Site 7 Ficus nitida :: Laurel Fig 53 610 Brannan St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
189256 91128 Permitted Site 7 Ficus nitida :: Laurel Fig 53 610 Brannan St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
110473 49870 Permitted Site 7 Ficus nitida :: Laurel Fig 53 607@ JACKSON Front St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2003 12:00:00 AM     Permit Number 46636 6012838.36008757 2118235.08187981 37.7969921557212 -122.399611944085 (37.7969921557212, -122.399611944085) 3 1 10 28860 6
18675 101715 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
54784 101716 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
87085 101725 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 11 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
105989 101717 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 3 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
138070 101722 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 8 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
138887 101721 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 7 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
143637 101724 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 10 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29

Next page

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