trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
84 254457 6 43 1055X Duncan St 2 Side Yard : Yard Tree 2                              
394 119605 6 41 299x Avalon Ave 1 Front Yard : Yard Tree 2                              
1051 251262 6 41 3630x 19th Ave 1 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
2100 253677 6 35 199X Kissling St 1 Side Yard : Cutout Tree 2       5x10                      
3171 119608 6 185 299x Avalon Ave 4 Front Yard : Yard Tree 2                              
3182 261252 6 21 100 Collins St 1 Front Yard : Cutout Tree 2   12/18/2019 12:00:00 AM 3                        
4934 103659 6 17 350X Hickory St 3 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
5510 104813 6 28 1601X Portola Dr 5 Front Yard : Yard Tree 2                              
5622 251139 6 17 621X Gough St 1 Back Yard : Yard Tree 2   03/10/2017 12:00:00 AM 3   Permit Number 779685                    
6834 103660 6 17 350X Hickory St 4 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
7039 119606 6 62 299x Avalon Ave 2 Front Yard : Yard Tree 2                              
7389 119599 6 185 4357x Mission St 1 Front Yard : Yard Tree 2         Permit Number 774415                    
7411 103658 6 17 350X Hickory St 2 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
8509 103668 6 17 350X Hickory St 6 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
8535 251265 6 41 3630x 19th Ave 4 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
11338 85030 6 17 411 Panama St 1 Sidewalk: Curb side : Cutout Tree 2   06/26/2007 12:00:00 AM     Permit Number 49384                    
13434 260582 6 33 2101X Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree 2   09/25/2019 12:00:00 AM 3 5x5 Permit Number 782628                    
13805 119600 6 185 4357x Mission St 2 Front Yard : Yard Tree 2         Permit Number 774415                    
14241 251264 6 41 3630x 19th Ave 3 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
14456 103661 6 17 350X Hickory St 5 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
15093 119607 6 15 299x Avalon Ave 3 Front Yard : Yard Tree 2                              
15289 119601 6 185 4357x Mission St 3 Front Yard : Yard Tree 2         Permit Number 774415                    
15795 251263 6 41 3630x 19th Ave 2 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
16207 254459 6 17 1055X Duncan St 4 Side Yard : Yard Tree 2   02/15/2018 12:00:00 AM 3   Permit Number 780800                    
18988 103657 6 17 350X Hickory St 1 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
19367 254458 6 17 1055X Duncan St 3 Side Yard : Yard Tree 2   02/15/2018 12:00:00 AM 3   Permit Number 780800                    
19573 254456 6 113 1055X Duncan St 1 Side Yard : Yard Tree 2                              
127144 258338 6 71 209 Spear St 1 Sidewalk: Property side : Cutout Tree 2                              
194363 265042 6 17 1000X Mandalay Ln 2 Unaccepted Street : Yard Tree 2   12/17/2020 12:00:00 AM 3 10x010 Permit Number 787936                    
106382 116072 6 113 388 POLARIS WAY 1 Sidewalk: Property side : Cutout Tree 2       3x3   6000586 2086414 37.7089285790833 -122.439725431133 (37.7089285790833, -122.439725431133) 9 7 6 28861 5
1377 262327 6 11 10X Sickles Ave 1 Sidewalk: Property side : Cutout Tree 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
1679 262328 6 11 10X Sickles Ave 2 Sidewalk: Property side : Cutout Tree 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
14780 262330 6 11 10X Sickles Ave 4 Sidewalk: Property side : Cutout Tree 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
18601 262329 6 11 10X Sickles Ave 3 Sidewalk: Property side : Cutout Tree 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
4724 262586 6 13 2 Byron Ct 1 Front Yard : Yard Tree 2   08/19/2020 12:00:00 AM 3 8x8 Permit Number 781313 5999459.72778 2086749.57445 37.7097858201455 -122.443642066205 (37.7097858201455, -122.443642066205) 9 7 6 28861 5
73440 116094 6 59 300x EXECUTIVE PARK BLVD 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
80147 116095 6 59 300x EXECUTIVE PARK BLVD 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
118842 116091 6 59 300x EXECUTIVE PARK BLVD 1 Sidewalk: Curb side : Cutout Tree 2     30 3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
145439 116093 6 59 300x EXECUTIVE PARK BLVD 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
154885 116096 6 59 300x EXECUTIVE PARK BLVD 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
170444 116097 6 59 300x EXECUTIVE PARK BLVD 7 Sidewalk: Curb side : Cutout Tree 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
177168 116092 6 59 300x EXECUTIVE PARK BLVD 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
39795 116833 6 28 1750 Geneva Ave 1 Front Yard : Yard Tree 2           6004521.4 2087037.7 37.710864341935 -122.42616849364 (37.710864341935, -122.42616849364) 9 7 6 309 5
47565 116834 6 28 1750 Geneva Ave 2 Front Yard : Yard Tree 2           6004521.4 2087037.7 37.710864341935 -122.42616849364 (37.710864341935, -122.42616849364) 9 7 6 309 5
93840 116835 6 28 1750 Geneva Ave 3 Front Yard : Yard Tree 2           6004521.4 2087037.7 37.710864341935 -122.42616849364 (37.710864341935, -122.42616849364) 9 7 6 309 5
127835 116836 6 28 1750 Geneva Ave 4 Front Yard : Yard Tree 2           6004521.4 2087037.7 37.710864341935 -122.42616849364 (37.710864341935, -122.42616849364) 9 7 6 309 5
142462 116837 6 28 1750 Geneva Ave 5 Front Yard : Yard Tree 2           6004521.4 2087037.7 37.710864341935 -122.42616849364 (37.710864341935, -122.42616849364) 9 7 6 309 5
34238 1283 6 22 3995X Alemany Blvd 1 Sidewalk: Property side : Cutout Tree 2     10 10x10   5992081.50866 2087171.04221 37.7105194967412 -122.469172961285 (37.7105194967412, -122.469172961285) 9 8 4 64 24
69574 1284 6 110 3995X Alemany Blvd 2 Sidewalk: Property side : Cutout Tree 2     12 3X10 Permit Number 778829 5992111.48083 2087185.84409 37.7105618710011 -122.469070448459 (37.7105618710011, -122.469070448459) 9 8 4 64 24
22688 120924 6 63 3995X Alemany Blvd 7 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
47402 120930 6 15 3995X Alemany Blvd 13 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
50856 1263 6 15 3995X Alemany Blvd 3 Sidewalk: Property side : Cutout Tree 2   12/02/1998 12:00:00 AM 10 3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
51080 120925 6 15 3995X Alemany Blvd 8 Sidewalk: Property side : Cutout Tree 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
60656 120926 6 63 3995X Alemany Blvd 9 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
73917 120923 6 15 3995X Alemany Blvd 6 Sidewalk: Property side : Cutout Tree 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
81897 120931 6 15 3995X Alemany Blvd 14 Sidewalk: Property side : Cutout Tree 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
94421 120922 6 15 3995X Alemany Blvd 5 Sidewalk: Property side : Cutout Tree 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
109715 120932 6 63 3995X Alemany Blvd 15 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
124817 120927 6 15 3995X Alemany Blvd 10 Sidewalk: Property side : Cutout Tree 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
136239 120933 6 63 3995X Alemany Blvd 16 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
145282 120934 6 63 3995X Alemany Blvd 17 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
156900 120929 6 63 3995X Alemany Blvd 12 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
162123 120936 6 63 3995X Alemany Blvd 19 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
162461 120921 6 63 3995X Alemany Blvd 4 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
171046 120928 6 15 3995X Alemany Blvd 11 Sidewalk: Property side : Cutout Tree 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
178015 120935 6 15 3995X Alemany Blvd 18 Sidewalk: Property side : Cutout Tree 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
15657 259657 6 17 132 Sagamore St 1 Front Yard : Yard Tree 2       3x3   5995545 2087474 37.7115508726991 -122.457224363425 (37.7115508726991, -122.457224363425) 9 8 6 28861 24
181560 256493 6 36 400 Rolph St 1 Front Yard : Yard Tree 2       3x3   6002004 2087744 37.7126610773499 -122.434919679914 (37.7126610773499, -122.434919679914) 9 7 6 28861 5
9908 215094 6 51 218 Sadowa St 1 Sidewalk: Curb side : Cutout Tree 2   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994821.63014 2087784.20309 37.7123610457095 -122.459746958272 (37.7123610457095, -122.459746958272) 9 8 6 28861 24
81780 206842 6 17 218 Sadowa St 3 Sidewalk: Property side : Cutout Tree 2   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994803.1874 2087784.4983 37.712360795684 -122.45981072288 (37.712360795684, -122.45981072288) 9 8 6 28861 24
137083 106962 6 41 218 SADOWA ST 3 Sidewalk: Property side : Cutout Tree 2     22     5994814 2087793.9 37.7123872323548 -122.459774032106 (37.7123872323548, -122.459774032106) 9 8 6 28861 24
142556 256880 6 59 2701 Alemany Blvd 1 Side Yard : Yard Tree 2       10x10   5997600 2087902 37.7128438731446 -122.450152604107 (37.7128438731446, -122.450152604107) 9 7 6 28861 25
127076 104193 6 206 122 Arch St 1 Front Yard : Yard Tree 2           5992720.4 2088013.1 37.7128684825751 -122.467026013031 (37.7128684825751, -122.467026013031) 9 8 6 64 24
93552 104749 6 15 1X Junipero Serra Blvd Off Ramp 1 Front Yard : Yard Tree 2         Permit Number 770709 5991326.15861 2088181.65405 37.7132507161795 -122.47185719554 (37.7132507161795, -122.47185719554) 1 8 4 64 14
142019 104750 6 15 1X Junipero Serra Blvd Off Ramp 2 Front Yard : Yard Tree 2   08/30/2016 12:00:00 AM 3   Permit Number 770709 5991326.15861 2088181.65405 37.7132507161795 -122.47185719554 (37.7132507161795, -122.47185719554) 1 8 4 64 14
703 262210 6 41 2011 Bay Shore Blvd 1 Front Yard : Yard Tree 2       3x3   6012422 2088364 37.7149494891568 -122.398955034798 (37.7149494891568, -122.398955034798) 10 3 8 309 1
38129 114239 6 150 1300x JUNIPERO SERRA BLVD 1 Sidewalk: Curb side : Yard Tree 2     28     5991168 2088425 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074) 1 8 4 64 14
188169 173629 6 154 10X Junipero Serra Blvd Off Ramp 1 Sidewalk: Property side : Cutout Tree 2   01/20/2017 12:00:00 AM 3 3x3 Permit Number 779383 5991168 2088425 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074) 1 8 4 64 14
92919 115827 6 62 60X CHUMASERO DR 1 Sidewalk: Property side : Cutout Tree 2   08/30/2016 12:00:00 AM 3 3x3 Permit Number 777531 5990913 2088468 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941) 1 8 4 64 14
177784 114257 6 470 50x CHUMASERO DR 1 Front Yard : Yard Tree 2           5990913 2088468 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941) 1 8 4 64 14
69512 113042 6 37 500 Raymond Ave 1 Front Yard : Cutout Tree 2   10/06/2015 12:00:00 AM 30 3x3   6008233.87951 2088473.93147 37.7150170728648 -122.413438766187 (37.7150170728648, -122.413438766187) 9 7 8 309 18
9862 114526 6 15 1 TIOGA AVE 2 Sidewalk: Curb side : Yard Tree 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
59395 114525 6 15 1 TIOGA AVE 1 Sidewalk: Curb side : Yard Tree 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
63542 116459 6 260 777 Brotherhood Way 2 Sidewalk: Curb side : Yard Tree 2     20 10x20 Permit Number 777772 5989848.42836 2088633.83291 37.7144066723949 -122.476997704287 (37.7144066723949, -122.476997704287) 1 8 4 64 14
51737 116458 6 260 777 Brotherhood Way 1 Sidewalk: Curb side : Yard Tree 2     12 10x20   5989819.39068 2088633.8654 37.7144050769972 -122.477098071327 (37.7144050769972, -122.477098071327) 1 8 4 64 14
19388 114226 6 150 99x FONT BLVD 2 Sidewalk: Curb side : Yard Tree 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
21577 114229 6 150 99x FONT BLVD 5 Sidewalk: Curb side : Yard Tree 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
27121 114234 6 150 99x FONT BLVD 10 Sidewalk: Curb side : Yard Tree 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
30455 114232 6 150 99x FONT BLVD 8 Sidewalk: Curb side : Yard Tree 2     15     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
44052 114240 6 28 99x FONT BLVD 16 Sidewalk: Curb side : Yard Tree 2           5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
44804 114228 6 150 99x FONT BLVD 4 Sidewalk: Curb side : Yard Tree 2     7     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
62078 114235 6 150 99x FONT BLVD 11 Sidewalk: Curb side : Yard Tree 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
109646 114230 6 150 99x FONT BLVD 6 Sidewalk: Curb side : Yard Tree 2     30     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
126287 114225 6 28 99x FONT BLVD 1 Sidewalk: Curb side : Yard Tree 2     48     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
128045 114227 6 150 99x FONT BLVD 3 Sidewalk: Curb side : Yard Tree 2     16     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
141272 114231 6 150 99x FONT BLVD 7 Sidewalk: Curb side : Yard Tree 2     10     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
154745 114237 6 150 99x FONT BLVD 13 Sidewalk: Curb side : Yard Tree 2     14     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
173544 114236 6 150 99x FONT BLVD 12 Sidewalk: Curb side : Yard Tree 2     22     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
179418 114233 6 150 99x FONT BLVD 9 Sidewalk: Curb side : Yard Tree 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
185977 114238 6 150 99x FONT BLVD 14 Sidewalk: Curb side : Yard Tree 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
873 113043 6 15 500 RAYMOND AVE 2 Front Yard : Cutout Tree 2   10/06/2015 12:00:00 AM   3x3   6008527 2088690 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248) 9 7 8 309 18