trees

Custom SQL query returning 34 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
273 117070 9 17 6 JOY ST 3 Front Yard : Yard Tree 2           6010444 2098901 37.7437714571602 -122.406533939617 (37.7437714571602, -122.406533939617) 2 7 7 28859 2
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
4884 260462 9 15 119 Moffitt St 1 Back Yard : Yard Tree 2       3x3   6002736 2096650 37.7371564911538 -122.433025558613 (37.7371564911538, -122.433025558613) 2 7 5 63 7
4985 260550 9 284 155 Graystone Ter 1 Sidewalk: Property side : Yard Landscaping 2       3x3   5999080 2104142 37.7575196509651 -122.446204727568 (37.7575196509651, -122.446204727568) 2 5 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
44862 114642 9 102 30 MacEdonia St 1 Sidewalk: Curb side : Cutout Tree 2   11/30/2015 12:00:00 AM     Permit Number 773527 6010319.9 2099707.2 37.745978163197 -122.407019863158 (37.745978163197, -122.407019863158) 2 7 7 28859 2
53506 108816 9 15 348 Gold Mine Dr 1 Back Yard : Yard Tree 2     30     6001084 2097744 37.740066514789 -122.438815634293 (37.740066514789, -122.438815634293) 2 7 5 63 7
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
69100 104567 9 17 8 JOY ST 2 Front Yard : Yard Tree 2     40     6010448 2098932 37.7438568002142 -122.406522292508 (37.7438568002142, -122.406522292508) 2 7 7 28859 2
80106 114666 9 51 382 Richland Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/30/2015 12:00:00 AM     Permit Number 774512 6007233.6 2095963.6 37.7355258779344 -122.417426639907 (37.7355258779344, -122.417426639907) 2 7 7 28859 2
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
86075 100243 9 17 1326-1332 Shotwell St   unknown : Yard Tree 2           6008043 2100485 37.7479861507453 -122.414948142067 (37.7479861507453, -122.414948142067) 2 7 7 28859 2
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
110382 108170 9 22 1645 ALABAMA ST 1 Sidewalk: Curb side : Cutout Tree 2   02/03/2015 12:00:00 AM 3 3x3 Permit Number 774689 6009348.4 2099893.7 37.7464358384441 -122.410392359276 (37.7464358384441, -122.410392359276) 2 7 7 28859 2
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
120017 105072 9 16 88X PROSPECT AVE 1 Sidewalk: Curb side : Cutout Tree 2     12 5x6   6007074 2099135 37.7442248567037 -122.418203213837 (37.7442248567037, -122.418203213837) 2 7 7 28859 2
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
156160 108314 9 28 2501X DIAMOND ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6002141 2097265 37.7388113707969 -122.435126715418 (37.7388113707969, -122.435126715418) 2 7 5 63 7
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
180187 112262 9 1 1 Holly Park Cir 3 Sidewalk: Curb side : Cutout Tree 2     10 3x15   6006308.21143459 2096885.36921844 37.7380047408881 -122.420691480393 (37.7380047408881, -122.420691480393) 2 7 7 28859 2
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
188939 104962 9 50 1474X SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree 2     7 3x3 74 Aztec St. 6008023 2099506 37.7452969115591 -122.414948020341 (37.7452969115591, -122.414948020341) 2 7 7 28859 2
190102 104109 9 58 342-346 MOULTRIE ST 2 Sidewalk: Curb side : Cutout Tree 2     9 3x6   6007700 2097518 37.7398201496863 -122.415924151926 (37.7398201496863, -122.415924151926) 2 7 7 28859 2
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