trees

Custom SQL query returning 21 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
893 226590 9 8 837 Duncan St 1 Sidewalk: Curb side : Cutout Tree 2 Port 08/14/2019 12:00:00 AM 3 3x3 Permit Number 784594 6001099.54842 2099653.23365 37.7453097044788 -122.438898660558 (37.7453097044788, -122.438898660558) 2 4 5 63 22
3984 243570 9 8 837 Duncan St 2 Sidewalk: Curb side : Cutout Tree 2 Port   3 3x3 Permit Number 784594 6001117.2647 2099653.19311 37.7453106011164 -122.438837397829 (37.7453106011164, -122.438837397829) 2 4 5 63 22
7435 239668 9 313 180 Dolores St 3 Sidewalk: Property side : Pot Landscaping 2     23 Width 4ft   6004776.3298 2107329.36682 37.7665950691341 -122.426731495165 (37.7665950691341, -122.426731495165) 8 4 5 28862 3
33896 104968 9 330 495 COLLINGWOOD ST 1 Front Yard : Yard Tree 2     15   Permit Number 770776 6002186.6 2103026 37.7546323087418 -122.435381040855 (37.7546323087418, -122.435381040855) 2 4 5 28862 22
34779 104448 9 40 2490X Folsom St 3 Sidewalk: Curb side : Cutout Tree 5       3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
64208 71505 9 13 328 San Carlos St 1 Sidewalk: Curb side : Cutout Tree 2   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774557 6006691.32680411 2104197.11487977 37.7581027211657 -122.419885554796 (37.7581027211657, -122.419885554796) 2 4 7 28859 19
68698 104451 9 70 2490X Folsom St 6 Sidewalk: Curb side : Cutout Tree 5       3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
83952 109126 9 91 890x CASTRO ST 2 Sidewalk: Curb side : Cutout Tree 2     4 3x3   6002411 2103002 37.7545791519678 -122.434603290485 (37.7545791519678, -122.434603290485) 2 4 5 28862 22
91676 104449 9 70 2490X Folsom St 4 Sidewalk: Curb side : Cutout Tree 5       3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
97720 104310 9 348 3747 23RD ST 3 Sidewalk: Curb side : Cutout Tree 2     13 5x5   6004798 2102451 37.7532014528284 -122.426309178314 (37.7532014528284, -122.426309178314) 2 4 5 28862 22
102300 113801 9 31 806 SHOTWELL ST 3 Front Yard : Yard Tree 2           6007931 2103220 37.755489548438 -122.415529041662 (37.755489548438, -122.415529041662) 2 4 7 28859 19
107120 121090 9 15 1X Grand View Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
108854 104446 9 40 2490X Folsom St 1 Sidewalk: Curb side : Cutout Tree 5       3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
112431 104768 9 31 912 CASTRO ST 1 Sidewalk: Curb side : Cutout Tree 2     17 3x3   6002431.1 2102873.8 37.7542282864134 -122.434524613527 (37.7542282864134, -122.434524613527) 2 4 5 28862 22
122325 104309 9 62 3747 23RD ST 2 Sidewalk: Curb side : Cutout Tree 2       5x5   6004798 2102451 37.7532014528284 -122.426309178314 (37.7532014528284, -122.426309178314) 2 4 5 28862 22
165242 104317 9 44 13011305 SANCHEZ ST 2 Sidewalk: Property side : Cutout Tree 2     12 3x3   6003956 2100665 37.7482498839608 -122.429093651106 (37.7482498839608, -122.429093651106) 2 4 5 63 22
168048 122898 9 51 198X San Jose Ave 1 Sidewalk: Curb side : Cutout Tree 2     6 3x3   6006160 2102149 37.7524491239798 -122.421577653162 (37.7524491239798, -122.421577653162) 2 4 5 28859 19
181524 121089 9 56 1X Grand View Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
181589 73314 9 166 1142 Alabama St 1 Sidewalk: Curb side : Cutout Tree 2   12/09/2014 12:00:00 AM 3 3x3   6009184.98526399 2102501.75487234 37.7535878144828 -122.411141625253 (37.7535878144828, -122.411141625253) 2 4 7 28859 19
186484 109125 9 91 890x CASTRO ST 1 Sidewalk: Curb side : Cutout Tree 2     12 3x3   6002411 2103002 37.7545791519678 -122.434603290485 (37.7545791519678, -122.434603290485) 2 4 5 28862 22
193423 108885 9 195 707 NOE ST 5 Back Yard : Yard Tree 2       3x3   6003152.4 2104071.5 37.7575578048507 -122.432115704961 (37.7575578048507, -122.432115704961) 2 4 5 28862 3