trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
767 100549 4 88 290X Tehama St 4 Sidewalk: Curb side : Cutout Tree 2     3 3x4                      
3669 103667 4 17 350X Hickory St 6 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
4476 112909 4 17 1899X Beach St 2 Sidewalk: Curb side : Cutout Tree 2                              
4983 112267 4 53 1X Geary St 1 Sidewalk: Curb side : Cutout Tree 2                              
5100 101532 4 17 11323 Palou Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3                      
5748 115724 4 243 250x Octavia St 1 Side Yard : Yard Tree 7                              
6238 103666 4 17 350X Hickory St 5 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
7827 115725 4 243 250X Octavia St 2 Side Yard : Yard Tree 7                              
9335 112908 4 17 1899X Beach St 1 Sidewalk: Curb side : Cutout Tree 2                              
9557 112910 4 17 1899X Beach St 3 Sidewalk: Curb side : Cutout Tree 2                              
10205 173902 4 57 601x Hearst Ave 2 Sidewalk: Curb side : Cutout Tree 2                              
10489 102839 4 63 1101X Portola Dr 2 Sidewalk: Property side : Yard Tree 1                              
10516 102842 4 16 1101X Portola Dr 8 Sidewalk: Property side : Yard Tree 1                              
10813 100543 4 88 290X Tehama St 3 Sidewalk: Curb side : Cutout Tree 2     3 3x4                      
10916 108180 4 11 835 Sacramento St 2 Sidewalk: Curb side : Cutout Tree 2       3x3                      
10998 100001 4 38 501X 01st St 2 Sidewalk: Curb side : Pot Tree 2         Address is 100 1st Street                    
11335 112269 4 53 1X Geary St 3 Sidewalk: Curb side : Cutout Tree 2                              
12733 102843 4 70 1101X Portola Dr 10 Sidewalk: Property side : Yard Tree 1                              
14524 99746 4 57 4250 Clipper St 1 Sidewalk: Curb side : Cutout Tree 2       3x3                      
15154 102838 4 15 1101X Portola Dr 1 Sidewalk: Property side : Yard Tree 1                              
15233 109923 4 14 214 state st 1 Sidewalk: Curb side : Cutout Tree 2       3x3                      
15258 103665 4 17 350X Hickory St 4 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
16355 103663 4 17 350X Hickory St 2 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18064 103664 4 17 350X Hickory St 3 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18422 112268 4 53 1X Geary St 2 Sidewalk: Curb side : Cutout Tree 2                              
18674 103662 4 17 350X Hickory St 1 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
116 113159 4 52 555 GROVE ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6005146 2111243 37.777361853017 -122.425731455878 (37.777361853017, -122.425731455878) 7 9 11 28852 10
149 244279 4 45 585 Oak St 4 Sidewalk: Curb side : Cutout Tree 2     0 Width 0ft   6004230.7823 2110095.842 37.7741602789386 -122.428815691218 (37.7741602789386, -122.428815691218) 7 9 11 28852 10
447 114683 4 101 235 GEARY ST 3 Sidewalk: Curb side : Cutout Tree 2       4x4   6010571 2114715 37.7872002104764 -122.407209329428 (37.7872002104764, -122.407209329428) 5 10 10 28852 6
1199 116255 4 177 155 LAGUNA ST 3 Sidewalk: Curb side : Cutout Tree 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
2553 140071 4 54 601X Octavia St 2 Sidewalk: Curb side : Cutout Tree 2     15 Width 0ft   6005402 2111410 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543) 7 9 11 28852 10
2733 107738 4 17 155x HAYES ST 4 Sidewalk: Curb side : Cutout Tree 2   05/04/2016 12:00:00 AM 3 3x3 Permit Number 774227 6007127.8 2111172.9 37.7772811641179 -122.41887077508 (37.7772811641179, -122.41887077508) 7 9 9 28852 36
4754 101985 4 17 205X Rose St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6005538.6 2109749.6 37.7732835163003 -122.424267082997 (37.7732835163003, -122.424267082997) 7 9 11 28852 10
5012 261384 4 48 246 Leavenworth St   Sidewalk: Curb side : Cutout Tree 2       3x3   6008558 2113314 37.7832405398106 -122.41407474629 (37.7832405398106, -122.41407474629) 7 10 9 28852 36
5054 102983 4 16 555 Turk St 10 Sidewalk: Curb side : Cutout Tree 2       3x3   6007348.4 2112963.4 37.7822098643106 -122.41823462296 (37.7822098643106, -122.41823462296) 7 9 9 28852 36
5583 244247 4 45 200 Octavia St 1 Sidewalk: Curb side : Cutout Tree 2     0 Width 0ft   6005673.0642 2110022.689 37.7740409443959 -122.423821374378 (37.7740409443959, -122.423821374378) 7 9 11 28852 10
6007 261051 4 27 770 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
9864 102975 4 16 555 Turk St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6007348.4 2112963.4 37.7822098643106 -122.41823462296 (37.7822098643106, -122.41823462296) 7 9 9 28852 36
10626 117236 4 27 635 GROVE ST 8 Sidewalk: Curb side : Cutout Tree 2       3x3   6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
10726 113513 4 36 352 TURK ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6008306 2113136 37.7827376375446 -122.414933965724 (37.7827376375446, -122.414933965724) 7 10 9 28852 36
10966 109166 4 31 51x OCTAVIA ST 5 Median : Cutout Tree 1       3x20   6005650.4 2109419.7 37.772384002649 -122.423856888434 (37.772384002649, -122.423856888434) 7 9 11 28852 10
11452 110549 4 84 2x LILY ST 7 Sidewalk: Curb side : Cutout Tree 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
11559 261050 4 27 770 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
11636 249410 4 28 698 Polk St 1 : Tree 2     17 Width 3ft   6007114.55441 2113257.76141 37.7830049436594 -122.419064511231 (37.7830049436594, -122.419064511231) 7 9 9 28852 36
12000 261047 4 27 750 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6006673 2113065 37.7824507928685 -122.420578423098 (37.7824507928685, -122.420578423098) 7 9 9 28852 36
12604 116259 4 177 155 LAGUNA ST 7 Sidewalk: Curb side : Cutout Tree 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
13756 261045 4 27 750 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6006673 2113065 37.7824507928685 -122.420578423098 (37.7824507928685, -122.420578423098) 7 9 9 28852 36
14793 114686 4 101 235 GEARY ST 6 Sidewalk: Curb side : Cutout Tree 2       4x4   6010571 2114715 37.7872002104764 -122.407209329428 (37.7872002104764, -122.407209329428) 5 10 10 28852 6
14967 108631 4 11 501 ELLIS ST 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6008465.6 2113811.6 37.7846016393538 -122.4144296353 (37.7846016393538, -122.4144296353) 7 10 9 28852 36
15238 261049 4 27 770 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
15598 112413 4 67 469x IVY ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6005169 2110996 37.7766849510116 -122.425634307332 (37.7766849510116, -122.425634307332) 7 9 11 28852 10
15642 102891 4 17 115 Jones St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6008968 2112966 37.7823080347026 -122.412631696322 (37.7823080347026, -122.412631696322) 7 10 9 28852 36
15734 102859 4 17 696 Sutter St 1 Sidewalk: Curb side : Cutout Tree 2     7 3x3   6009251 2115330 37.7888148901218 -122.411819735773 (37.7888148901218, -122.411819735773) 5 1 10 28852 21
16085 261385 4 48 238 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6008591 2113342 37.7833192745132 -122.413962560517 (37.7833192745132, -122.413962560517) 7 10 9 28852 36
16405 114682 4 101 235 GEARY ST 2 Sidewalk: Curb side : Pot Tree 2           6010571 2114715 37.7872002104764 -122.407209329428 (37.7872002104764, -122.407209329428) 5 10 10 28852 6
16787 105348 4 166 651X Ivy St 3 Sidewalk: Curb side : Cutout Tree 2     5 3x3   6004248.77005 2110989.99433 37.7766164199227 -122.428817225763 (37.7766164199227, -122.428817225763) 7 9 11 28852 10
17663 101489 4 5 59X Waller St 1 Sidewalk: Curb side : Cutout Tree 2   10/26/2012 12:00:00 AM 1 3x3 Permit Number 769087 6005416.7 2109221 37.7718252244657 -122.424651142233 (37.7718252244657, -122.424651142233) 7 9 5 28852 10
18163 140072 4 54 601X Octavia St 3 Sidewalk: Curb side : Cutout Tree 2     15 Width 0ft   6005402 2111410 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543) 7 9 11 28852 10
18428 261048 4 27 770 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
19924 114954 4 101 601x OCTAVIA ST 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6005348 2111368 37.7777164851071 -122.42504156742 (37.7777164851071, -122.42504156742) 7 9 11 28852 10
20378 116241 4 177 229x HAIGHT ST 4 Sidewalk: Curb side : Cutout Tree 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
21018 110553 4 84 2x LILY ST 11 Sidewalk: Curb side : Cutout Tree 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
21249 112640 4 28 299X STOCKTON ST 1 Sidewalk: Curb side : Cutout Tree 2     15 6x9   6010693 2115178 37.7884783251045 -122.406819877074 (37.7884783251045, -122.406819877074) 5 1 10 28852 6
23806 108427 4 27 270X HAYES ST 12 Sidewalk: Curb side : Cutout Tree 2       3x3   6006095.6 2111028.7 37.7768270516853 -122.422431244298 (37.7768270516853, -122.422431244298) 7 9 11 28852 10
25215 117234 4 27 635 GROVE ST 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
25732 116996 4 63 606x FULTON ST   Front Yard : Yard Tree 2   09/29/2016 12:00:00 AM 3     6004628 2111737 37.7786889706302 -122.427558590519 (37.7786889706302, -122.427558590519) 7 9 11 28852 41
25929 102776 4 11 62X Leavenworth St 1 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6008658 2112778 37.7817744284412 -122.413690860804 (37.7817744284412, -122.413690860804) 7 10 9 28852 36
27481 108924 4 149 335-341 Oak St 2 Sidewalk: Curb side : Cutout Tree 2     1 3x3   6005380.1 2110235.1 37.7746076306443 -122.424849903476 (37.7746076306443, -122.424849903476) 7 9 11 28852 10
28979 110554 4 84 2x LILY ST 12 Sidewalk: Curb side : Cutout Tree 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
29178 129906 4 11 536 Fell St 1 : Tree 2     16 Width 3ft   6004841.59685 2110577.9768 37.7755186559901 -122.426737115928 (37.7755186559901, -122.426737115928) 7 9 11 28852 10
29615 120137 4 53 10X Grove St 7 Sidewalk: Curb side : Cutout Tree 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
31946 245835 4 45 451 Fell St 4 Sidewalk: Curb side : Cutout Tree 2     0 Width 0ft   6005269.6444 2110584.5711 37.7755609539167 -122.4252568647 (37.7755609539167, -122.4252568647) 7 9 11 28852 10
32081 117240 4 27 635 GROVE ST 12 Sidewalk: Curb side : Cutout Tree 2       3x3   6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
32669 256769 4 12 300X Octavia St 1 Median : Cutout Tree 2       3x3   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
32994 257945 4 61 901x Gough St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6005635 2113075 37.782419697088 -122.42417016492 (37.782419697088, -122.42417016492) 7 9 11 28852 41
33897 100566 4 16 312 Mason St 3 Sidewalk: Curb side : Cutout Tree 2     12 3x3   6009858 2114440 37.7864051976389 -122.409656748713 (37.7864051976389, -122.409656748713) 5 10 10 28852 36
34017 100567 4 16 312 Mason St 4 Sidewalk: Curb side : Cutout Tree 2     12 3x3   6009858 2114440 37.7864051976389 -122.409656748713 (37.7864051976389, -122.409656748713) 5 10 10 28852 36
34250 120979 4 27 699X Polk St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6007023 2113270 37.7830333917519 -122.419382121036 (37.7830333917519, -122.419382121036) 7 9 9 28852 36
35379 254803 4 52 525 Hayes St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6005345 2110923 37.7764944541895 -122.425020275756 (37.7764944541895, -122.425020275756) 7 9 11 28852 10
35784 108421 4 27 270X HAYES ST 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6006095.6 2111028.7 37.7768270516853 -122.422431244298 (37.7768270516853, -122.422431244298) 7 9 11 28852 10
36000 104437 4 97 534 Octavia St 1 Sidewalk: Curb side : Cutout Tree 2           6005464 2111103 37.7769954116482 -122.424621427703 (37.7769954116482, -122.424621427703) 7 9 11 28852 10
36097 115453 4 84 300 Octavia St Frontage East 4 Sidewalk: Curb side : Cutout Tree 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
36354 114684 4 101 235 GEARY ST 4 Sidewalk: Curb side : Cutout Tree 2       4x4   6010571 2114715 37.7872002104764 -122.407209329428 (37.7872002104764, -122.407209329428) 5 10 10 28852 6
36522 101983 4 17 205X Rose St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6005538.6 2109749.6 37.7732835163003 -122.424267082997 (37.7732835163003, -122.424267082997) 7 9 11 28852 10
37182 109162 4 31 51x OCTAVIA ST 1 Median : Cutout Tree 1     6 3x20   6005650.4 2109419.7 37.772384002649 -122.423856888434 (37.772384002649, -122.423856888434) 7 9 11 28852 10
37353 108422 4 27 270X HAYES ST 7 Sidewalk: Curb side : Cutout Tree 2       3x3   6006095.6 2111028.7 37.7768270516853 -122.422431244298 (37.7768270516853, -122.422431244298) 7 9 11 28852 10
37445 118287 4 83 240 IVY ST 1 Sidewalk: Curb side : Cutout Tree 2       3x2.5   6006177 2111293 37.7775573470216 -122.422168438332 (37.7775573470216, -122.422168438332) 7 9 11 28852 10
38409 110550 4 84 2x LILY ST 8 Sidewalk: Curb side : Cutout Tree 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
38715 120144 4 53 1X Hyde St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6008026 2111839 37.7791606496002 -122.415810780563 (37.7791606496002, -122.415810780563) 7 10 9 28852 36
39065 117232 4 27 635 GROVE ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
39077 103271 4 31 350 Page St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6004879 2109882 37.7736097878739 -122.426558160091 (37.7736097878739, -122.426558160091) 7 9 11 28852 10
40305 114742 4 9 188 BUCHANAN ST 5 Sidewalk: Curb side : Cutout Tree 2     2 4x4   6004735 2109327 37.7720777510232 -122.427016741179 (37.7720777510232, -122.427016741179) 7 9 5 28852 10
41602 114741 4 9 188 BUCHANAN ST 4 Sidewalk: Curb side : Cutout Tree 2     2 4x4   6004735 2109327 37.7720777510232 -122.427016741179 (37.7720777510232, -122.427016741179) 7 9 5 28852 10
41773 120139 4 53 10X Grove St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
42257 115376 4 28 500 BUCHANAN ST 1 Sidewalk: Curb side : Cutout Tree 2       4x4   6004637 2110246 37.7745955592359 -122.427421211008 (37.7745955592359, -122.427421211008) 7 9 11 28852 10
42356 105346 4 166 651X Ivy St 1 Sidewalk: Curb side : Cutout Tree 2     3 3x3   6004248.77005 2110989.99433 37.7766164199227 -122.428817225763 (37.7766164199227, -122.428817225763) 7 9 11 28852 10
42496 116243 4 177 229x HAIGHT ST 6 Sidewalk: Curb side : Cutout Tree 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
44701 102897 4 17 40 Jones St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6009201.8 2112650.6 37.7814551404658 -122.411800555351 (37.7814551404658, -122.411800555351) 14 10 9 28852 36
44883 220402 4 328 50 Webster St 2 Sidewalk: Curb side : Cutout Tree 2       Width 2ft   6004328.50945 2108814.63576 37.7706479295788 -122.428386299898 (37.7706479295788, -122.428386299898) 7 9 11 28852 10
45829 131224 4 10 41 Jones St 2 Sidewalk: Curb side : Pot Tree 2     4 Width 4ft   6009083.28027 2112713.95456 37.7816224473696 -122.412215056906 (37.7816224473696, -122.412215056906) 7 10 9 28852 36
46354 108426 4 27 270X HAYES ST 11 Sidewalk: Curb side : Cutout Tree 2       3x3   6006095.6 2111028.7 37.7768270516853 -122.422431244298 (37.7768270516853, -122.422431244298) 7 9 11 28852 10