trees

75 rows where Fire Prevention Districts = 6 and qSpecies_id = 53

✎ View and edit SQL

This data as json, CSV (advanced)

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)
1212 40354 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 12 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
2027 32641 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
3630 258965 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
5064 258966 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 6 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
6270 258961 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
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
9626 258963 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
9664 258964 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
10154 258967 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 7 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
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
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
20820 111597 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
24140 32644 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
24912 32645 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
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
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
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
43639 111595 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 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
50036 100262 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 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
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
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
58892 40350 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 Tehama St 11 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011468.97735143 2112560.39183232 37.7813343766323 -122.403950824176 (37.7813343766323, -122.403950824176) 6 2 9 28853 34
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
60538 32649 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/28/2005 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
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
65043 100265 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 5 Sidewalk: Property side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
66641 32646 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
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
72803 32647 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
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
83229 51761 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 Tehama St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2005 12:00:00 AM 8   Permit Number 48028 6011451.43524212 2112543.5849209 37.781287248696 -122.404010328515 (37.781287248696, -122.404010328515) 6 2 9 28853 34
83380 40353 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 13 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
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
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
99255 111592 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 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
100811 111598 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
104676 100260 Undocumented 4 Ficus nitida :: Laurel Fig 53 30X Federal St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 4x3   6015074.6 2113439.2 37.7839481682667 -122.391538488525 (37.7839481682667, -122.391538488525) 6 2 9 28856 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
107982 111590 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
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
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
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
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
131840 100259 Undocumented 4 Ficus nitida :: Laurel Fig 53 30X Federal St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 4x3   6015074.6 2113439.2 37.7839481682667 -122.391538488525 (37.7839481682667, -122.391538488525) 6 2 9 28856 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
135772 100261 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
144365 111593 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 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
150162 111596 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
153427 40357 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 10 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
158317 111591 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 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
167657 100264 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 4 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 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
173264 111594 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
174749 100263 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 3 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
182282 32648 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/28/2005 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
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
182731 40355 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 9 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
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

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