trees

Custom SQL query returning 65 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
8510 259163 9 66 1 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
9208 259164 9 66 1 Corbett Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
16349 259165 9 66 1 Corbett Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
10049 261052 9 22 100 Hooper St 9 Sidewalk: Curb side : Cutout Tree 2       3x3   6013012.2905 2108046.92839 37.769027533769 -122.398294909078 (37.769027533769, -122.398294909078) 14 3 8 28856 20
137357 117353 9 95 101X China Basin St 2 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 772935 6015309.46376 2108739.72137 37.7710574836343 -122.390397474374 (37.7710574836343, -122.390397474374) 14 3 9 310 20
99316 108440 9 19 105 Lake St   Sidewalk: Curb side : Cutout Tree 2 FUF     3x3   5995179.45913 2114890.0759 37.7868075137311 -122.460473064302 (37.7868075137311, -122.460473064302) 11 6 1 54 11
171901 82180 9 13 105 Lake St 1 Front Yard : Cutout Tree 2 FUF     3x3 Permit Number 773769 5995179.68463591 2114884.08050195 37.7867910649613 -122.460471849521 (37.7867910649613, -122.460471849521) 11 6 1 54 11
187934 108441 9 19 105 Lake St   Front Yard : Cutout Tree 2 FUF     3x3 Permit Number 773769 5995179.45913 2114890.0759 37.7868075137311 -122.460473064302 (37.7868075137311, -122.460473064302) 11 6 1 54 11
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
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
11563 259753 9 1 1229 Connecticut St 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6013525 2101361 37.7506979810533 -122.396052856578 (37.7506979810533, -122.396052856578) 10 3 8 28856 1
4850 262150 9 6 1295 47th Ave 1 Sidewalk: Curb side : Cutout Tree 2   05/11/2020 12:00:00 AM 3 3x3   5981486.26206 2106277.60943 37.7623629555319 -122.50720831894 (37.7623629555319, -122.50720831894) 1 8 3 56 35
6683 262152 9 6 1295 47th Ave 3 Sidewalk: Curb side : Cutout Tree 2   05/11/2020 12:00:00 AM 3 3x3   5981486.26206 2106277.60943 37.7623629555319 -122.50720831894 (37.7623629555319, -122.50720831894) 1 8 3 56 35
8142 262151 9 6 1295 47th Ave 2 Sidewalk: Curb side : Cutout Tree 2   05/11/2020 12:00:00 AM 3 3x3   5981486.26206 2106277.60943 37.7623629555319 -122.50720831894 (37.7623629555319, -122.50720831894) 1 8 3 56 35
18909 262153 9 6 1295 47th Ave 4 Sidewalk: Curb side : Cutout Tree 2   05/11/2020 12:00:00 AM 3 3x3   5981486.26206 2106277.60943 37.7623629555319 -122.50720831894 (37.7623629555319, -122.50720831894) 1 8 3 56 35
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
15590 260947 9 17 143 Gambier St 1 Sidewalk: Property side : Yard Tree 2       3x3   6005856 2093079 37.72752779603 -122.421984681693 (37.72752779603, -122.421984681693) 9 7 7 309 5
4192 264915 9 32 1461 Revere Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/09/2020 12:00:00 AM 3 3x3 Permit Number 784397 6015819.34366 2093828.22518 37.7301419060949 -122.387593270969 (37.7301419060949, -122.387593270969) 10 3 8 58 1
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
193685 104552 9 16 151 STARVIEW WAY 1 Sidewalk: Curb side : Cutout Tree 2     22 3x3   5997447 2102183 37.7520473310587 -122.451710958005 (37.7520473310587, -122.451710958005) 1 5 4 63 38
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
10609 262014 9 19 1591 Page St 4 Sidewalk: Curb side : Cutout Tree 2   04/08/2020 12:00:00 AM 3 3x3   5998968.26858 2109018.36861 37.7709025542262 -122.446942035054 (37.7709025542262, -122.446942035054) 15 5 11 29492 9
12794 262012 9 19 1591 Page St 2 Sidewalk: Curb side : Cutout Tree 2   04/08/2020 12:00:00 AM 3 3x3   5998968.26858 2109018.36861 37.7709025542262 -122.446942035054 (37.7709025542262, -122.446942035054) 15 5 11 29492 9
12902 262013 9 19 1591 Page St 3 Sidewalk: Curb side : Cutout Tree 2   04/08/2020 12:00:00 AM 3 3x3   5998968.26858 2109018.36861 37.7709025542262 -122.446942035054 (37.7709025542262, -122.446942035054) 15 5 11 29492 9
17012 262011 9 19 1591 Page St 1 Sidewalk: Curb side : Cutout Tree 2   04/08/2020 12:00:00 AM 3 3x3   5998968.26858 2109018.36861 37.7709025542262 -122.446942035054 (37.7709025542262, -122.446942035054) 15 5 11 29492 9
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
5653 215048 9 9 1719 17th Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/03/2020 12:00:00 AM 3 3x3 Permit Number 782897 5990885.18116 2103671.34742 37.7557559568771 -122.474511074324 (37.7557559568771, -122.474511074324) 1 8 4 56 12
13426 260872 9 17 1736 Fitzgerald Ave 1 Sidewalk: Property side : Cutout Tree 2     3 3x3   6011805.50809 2092676.7551 37.7267570649137 -122.401388810186 (37.7267570649137, -122.401388810186) 10 3 8 58 1
6336 261055 9 89 1948 Quesada Ave 1 Front Yard : Cutout Tree 2 DPW 11/20/2019 12:00:00 AM 3 3x3 Permit Number 780729 6013389.35902 2096036.97619 37.7360717858924 -122.396148836191 (37.7360717858924, -122.396148836191) 10 3 8 58 1
8824 261056 9 89 1952 Quesada Ave 1 Front Yard : Cutout Tree 2 DPW 11/20/2019 12:00:00 AM 3 3x3 Permit Number 780727 6013369.93114 2096051.4395 37.7361104181421 -122.396217020065 (37.7361104181421, -122.396217020065) 10 3 8 58 1
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
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
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
10283 264747 9 36 2002 Pierce St 1 Sidewalk: Curb side : Cutout Tree 2   10/01/2020 12:00:00 AM 3 3x3   6001953.79528 2115381.82831 37.7885451212547 -122.437070707369 (37.7885451212547, -122.437070707369) 13 6 1 29490 27
13028 264748 9 36 2002 Pierce St 2 Sidewalk: Curb side : Cutout Tree 2   10/01/2020 12:00:00 AM 3 3x3   6001953.79528 2115381.82831 37.7885451212547 -122.437070707369 (37.7885451212547, -122.437070707369) 13 6 1 29490 27
194501 265145 9 1 2160 Hayes St 1 Sidewalk: Curb side : Cutout Tree 2   01/13/2021 12:00:00 AM 3 3x3 Permit Number 782838 5997529.09133 2109900.74605 37.7732430089022 -122.451983830898 (37.7732430089022, -122.451983830898) 15 5 11 29492 16
194517 265144 9 1 2166 Hayes St 1 Sidewalk: Curb side : Cutout Tree 2     3 3x3 Permit Number 782839 5997501.55835 2109896.92898 37.773230951126 -122.452078795234 (37.773230951126, -122.452078795234) 15 5 11 29492 16
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
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
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
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
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
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
170397 36938 9 14 351 11th Ave 1 Sidewalk: Curb side : Cutout Tree 2   02/06/2015 12:00:00 AM 3 3x3 Permit Number 774744 5992449.52236815 2113091.823439 37.781712581861 -122.469786951776 (37.781712581861, -122.469786951776) 11 6 2 54 11
141599 251417 9 56 418 19th Ave 1 Sidewalk: Curb side : Cutout Tree 3       3x3   5990003 2112517 37.7799925618685 -122.478208632121 (37.7799925618685, -122.478208632121) 11 6 2 55 26
190320 72375 9 2 4299X Fulton St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/09/1996 12:00:00 AM   3x3 Permit Number 773790 5990099.63678033 2109979.56687008 37.773031079694 -122.477688796337 (37.773031079694, -122.477688796337) 11 6 2 55 26
19354 262188 9 50 490 Vermont St 1 Front Yard : Cutout Tree 1   05/19/2020 12:00:00 AM 3 3x3 Permit Number 784452 6011166 2106075 37.7635100471883 -122.404542318782 (37.7635100471883, -122.404542318782) 8 3 8 28856 29
11394 260246 9 224 568 Huron Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/14/2019 12:00:00 AM 3 3x3 Permit Number 784595 5998297.39121 2088148.96817 37.7135618752392 -122.447759972312 (37.7135618752392, -122.447759972312) 9 7 6 28861 25
5914 254656 9 45 640 Larch St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6004524 2112776 37.781535924842 -122.427992425483 (37.781535924842, -122.427992425483) 7 9 11 29490 41
14046 262297 9 155 666 Hamilton St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6009767 2091318 37.722912259595 -122.408340109411 (37.722912259595, -122.408340109411) 9 3 7 309 28
10772 264676 9 152 668 Oak St 1 Sidewalk: Curb side : Cutout Tree 2   09/10/2020 12:00:00 AM 3 3x3   6003797.75621 2110080.31484 37.7740931268852 -122.430312496695 (37.7740931268852, -122.430312496695) 7 9 11 29492 10
14848 260375 9 17 67 Allison St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/16/2019 12:00:00 AM 3 3x3 Permit Number 784562 5999904.1409 2088281.96487 37.714018757491 -122.442216028541 (37.714018757491, -122.442216028541) 9 7 6 28861 5
23696 108446 9 1 672 05th Ave   Sidewalk: Curb side : Cutout Tree 2 FUF     3x3 Permit Number 773773 5994431.81479 2110948.53978 37.7759420777365 -122.462773673163 (37.7759420777365, -122.462773673163) 11 6 2 54 11
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
57138 104401 9 31 727 Ashbury St   Sidewalk: Curb side : Cutout Tree 2     15 3x3   5999017 2108166 37.768564950056 -122.44671213341 (37.768564950056, -122.44671213341) 15 5 11 29492 9
176299 104400 9 58 755 Ashbury St   Sidewalk: Curb side : Cutout Tree 2     22 3x3   5999044 2107976 37.768044800389 -122.446605071221 (37.768044800389, -122.446605071221) 15 5 11 29492 9
65512 108459 9 13 771 11th Ave   Sidewalk: Curb side : Cutout Tree 2 FUF     3x3 Permit Number 773786 5992558.08669 2110211.94426 37.7738114893979 -122.469201704334 (37.7738114893979, -122.469201704334) 11 6 2 54 11
142770 150735 9 64 783 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree 2   05/31/2019 12:00:00 AM 3 3x3 Permit Number 778950 6012760.80751 2103885.27159 37.7575865350131 -122.398872659244 (37.7575865350131, -122.398872659244) 10 3 8 28856 29
8424 261322 9 45 811 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/02/2020 12:00:00 AM 3 3x3                      
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
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
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
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
4221 160246 9 48 962 Edinburgh St 1 Front Yard : Cutout Tree 2 DPW 02/20/2020 12:00:00 AM 3 3x3 Permit Number 779047 6001480.24176 2088600.7563 37.7149837880375 -122.436791243222 (37.7149837880375, -122.436791243222) 9 7 6 28861 5