trees

Custom SQL query returning 30 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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