trees

Custom SQL query returning 16 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
8082 96598 8 317 325 Sanchez St   Sidewalk: Property side : Cutout tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
11720 204026 1 317 345 Grafton Ave 2 Sidewalk: Property side : Yard Tree 2 FUF 04/13/2020 12:00:00 AM 3 Width 3ft Permit Number 785247 5995729.38017 2090530.64425 37.7199542879376 -122.45680803049 (37.7199542879376, -122.45680803049) 9 8 6 28861 24
19467 218225 1 317 100 Claremont Blvd 1 Sidewalk: Property side : Yard Tree 2   04/14/2020 12:00:00 AM 3 Width 8ft Permit Number 785255 5993843.55646 2098914.16079 37.7428648966005 -122.463934844718 (37.7428648966005, -122.463934844718) 1 8 4 59 40
19875 96597 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
21821 97236 8 317 125 Excelsior Ave   Sidewalk: Property side : Yard Tree 4 FUF 09/07/2011 12:00:00 AM     Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 9 7 6 28861 5
23856 94669 7 317 108 Farnum St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53806 6002381 2097448 37.7393274717437 -122.434309988471 (37.7393274717437, -122.434309988471) 2 7 5 63 7
33788 96601 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
35006 96602 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
53202 102251 8 317 125X Powhattan Ave 4 Front Yard : Yard Tree 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606 2098071 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
61598 99299 6 317 1457 Willard St 1 Front Yard : Tree 2   05/02/2012 12:00:00 AM     Permit Number 768720 5996809.7 2106270.3 37.763233506694 -122.454210015753 (37.763233506694, -122.454210015753) 15 5 11 29492 12
120469 96606 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
136541 96599 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
138264 96604 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
142618 96600 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
184992 96603 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
186894 96605 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3