trees

Custom SQL query returning 75 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1212 40354 7 53 379 TEHAMA ST 12 Sidewalk: Curb side : Cutout Tree 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 7 53 379 TEHAMA ST 6 Sidewalk: Curb side : Cutout Tree 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 1 53 398x Bryant St 5 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
5064 258966 1 53 398x Bryant St 6 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
6270 258961 1 53 398x Bryant St 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
9438 115058 4 53 499X BRANNAN ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
9626 258963 1 53 398x Bryant St 3 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
9664 258964 1 53 398x Bryant St 4 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
10154 258967 1 53 398x Bryant St 7 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
11514 258968 1 53 398x Bryant St 8 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
17682 258962 1 53 398x Bryant St 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
18544 258969 1 53 398x Bryant St 9 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
18772 115057 4 53 499X BRANNAN ST 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
20820 111597 4 53 398X BRYANT ST 8 Sidewalk: Curb side : Cutout Tree 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
24140 32644 7 53 379 TEHAMA ST 8 Sidewalk: Curb side : Cutout Tree 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 7 53 379 TEHAMA ST 7 Sidewalk: Curb side : Cutout Tree 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 4 53 160 Folsom St 2 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
27040 120661 4 53 299X Main St 1 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
38859 115059 4 53 499X BRANNAN ST 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
40462 48697 7 53 405 Howard St 9 Sidewalk: Curb side : Cutout Tree 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 4 53 398X BRYANT ST 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
43665 94218 7 53 246 01st St 3 Sidewalk: Property side : Pot Tree 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 4 53 40 Federal St 2 Sidewalk: Curb side : Cutout Tree 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
53416 48709 7 53 405 Howard St 8 Sidewalk: Curb side : Cutout Tree 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 4 53 499X BRANNAN ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
57627 114283 4 53 200X STEUART ST 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
58892 40350 7 53 379 Tehama St 11 Sidewalk: Curb side : Cutout Tree 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 7 53 1X Tehama St 1 Sidewalk: Property side : Pot Tree 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 7 53 379 TEHAMA ST 1 Sidewalk: Curb side : Cutout Tree 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 7 53 220X 01st St 1 Sidewalk: Curb side : Cutout Tree 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 4 53 40 Federal St 5 Sidewalk: Property side : Cutout Tree 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
66641 32646 7 53 379 TEHAMA ST 4 Sidewalk: Curb side : Cutout Tree 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 7 53 405 Howard St 14 Sidewalk: Curb side : Cutout Tree 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 4 53 200X STEUART ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
72803 32647 7 53 379 TEHAMA ST 3 Sidewalk: Curb side : Cutout Tree 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 4 53 200X STEUART ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
83229 51761 7 53 379 Tehama St 5 Sidewalk: Curb side : Cutout Tree 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 7 53 379 TEHAMA ST 13 Sidewalk: Curb side : Cutout Tree 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 7 53 405 Howard St 6 Sidewalk: Curb side : Cutout Tree 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 4 53 126 Folsom St 1 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
95808 48700 7 53 405 Howard St 12 Sidewalk: Curb side : Cutout Tree 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 7 53 436 Bryant St 1 Sidewalk: Curb side : Cutout Tree 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 4 53 398X BRYANT ST 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
100582 48699 7 53 405 Howard St 11 Sidewalk: Curb side : Cutout Tree 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 4 53 398X BRYANT ST 9 Sidewalk: Curb side : Cutout Tree 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
104676 100260 4 53 30X Federal St 2 Sidewalk: Curb side : Cutout Tree 2     24 4x3   6015074.6 2113439.2 37.7839481682667 -122.391538488525 (37.7839481682667, -122.391538488525) 6 2 9 28856 6
105004 100707 7 53 220X 01st St 3 Sidewalk: Curb side : Cutout Tree 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 4 53 398X BRYANT ST 1 Sidewalk: Curb side : Cutout Tree 2     16 3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
109074 115054 4 53 499X BRANNAN ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
114816 120655 4 53 160 Folsom St 1 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
119084 173642 1 53 657 Howard St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6012793 2114089 37.7856054636163 -122.399477673173 (37.7856054636163, -122.399477673173) 6 2 9 28853 6
123162 114285 4 53 200X STEUART ST 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
128659 120663 4 53 299X Main St 3 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
129369 94220 7 53 1X Tehama St 5 Sidewalk: Property side : Pot Tree 2         Permit Number 53568 6013910.7 2114841.3 37.7877333404996 -122.395663455814 (37.7877333404996, -122.395663455814) 6 2 9 28855 6
131840 100259 4 53 30X Federal St 1 Sidewalk: Curb side : Cutout Tree 2     24 4x3   6015074.6 2113439.2 37.7839481682667 -122.391538488525 (37.7839481682667, -122.391538488525) 6 2 9 28856 6
132195 100706 7 53 220X 01st St 2 Sidewalk: Curb side : Cutout Tree 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 7 53 405 Howard St 7 Sidewalk: Curb side : Cutout Tree 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 4 53 40 Federal St 1 Sidewalk: Curb side : Cutout Tree 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
144365 111593 4 53 398X BRYANT ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
145539 48701 7 53 405 Howard St 13 Sidewalk: Curb side : Cutout Tree 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 4 53 398X BRYANT ST 7 Sidewalk: Curb side : Cutout Tree 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
153427 40357 7 53 379 TEHAMA ST 10 Sidewalk: Curb side : Cutout Tree 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 4 53 398X BRYANT ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
165688 120662 4 53 299X Main St 2 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
167657 100264 4 53 40 Federal St 4 Sidewalk: Curb side : Cutout Tree 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
168885 48703 7 53 405 Howard St 10 Sidewalk: Curb side : Cutout Tree 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 4 53 200X STEUART ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
170512 94219 7 53 246 01st St 4 Sidewalk: Property side : Pot Tree 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 4 53 398X BRYANT ST 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
174749 100263 4 53 40 Federal St 3 Sidewalk: Curb side : Cutout Tree 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
182282 32648 7 53 379 TEHAMA ST 2 Sidewalk: Curb side : Cutout Tree 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 7 53 220X 01st St 5 Sidewalk: Curb side : Cutout Tree 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 7 53 379 TEHAMA ST 9 Sidewalk: Curb side : Cutout Tree 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 7 53 246 01st St 2 Sidewalk: Property side : Pot Tree 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 7 53 220X 01st St 4 Sidewalk: Curb side : Cutout Tree 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