trees
75 rows where Fire Prevention Districts = 6 and qSpecies_id = 53
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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) );