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                    
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
2201 107549 6 17 198X Jennings St 2 Front Yard : Yard Tree 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018784.70414 2097136.12526 37.7393885572332 -122.377570991407 (37.7393885572332, -122.377570991407) 10 3 8 58 1
2862 261320 6 52 872 Ingerson Ave   Sidewalk: Curb side : Cutout Tree 2       3x3   6014869 2089377 37.7178670406836 -122.390567842363 (37.7178670406836, -122.390567842363) 10 3 8 58 1
3578 261993 6 93 1557x Bancroft Ave 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6014548 2092008 37.7250734320456 -122.391861276019 (37.7250734320456, -122.391861276019) 10 3 8 58 1
3682 261986 6 70 1500 Bancroft Ave 3 Front Yard : Yard Tree 2           6014696 2091834 37.7246038778524 -122.391337493735 (37.7246038778524, -122.391337493735) 10 3 8 58 1
3726 94934 6 265 2451X Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
5747 94949 6 116 50 Pomona St   : Cutout Tree 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
5905 261162 6 15 595 Newhall St 1 Sidewalk: Property side : Cutout Tree 1 Private     3x3   6016024 2097656 37.7406635379999 -122.387152626875 (37.7406635379999, -122.387152626875) 10 3 8 58 1
7767 262288 6 36 1601 Innes Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
11444 261994 6 93 1557x Bancroft Ave 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6014548 2092008 37.7250734320456 -122.391861276019 (37.7250734320456, -122.391861276019) 10 3 8 58 1
12244 261985 6 93 1500x Bancroft Ave   Front Yard : Yard Tree 2           6014696 2091834 37.7246038778524 -122.391337493735 (37.7246038778524, -122.391337493735) 10 3 8 58 1
15723 105168 6 28 4755X 03RD ST 2 Front Yard : Cutout Tree 19     23 3x3 Permit Number 770204 6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
16142 94943 6 364 2525 Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
17557 261982 6 93 2403 Keith St 3 Sidewalk: Property side : Yard Tree 1           6014456 2092405 37.7261584067484 -122.392207065149 (37.7261584067484, -122.392207065149) 10 3 8 58 1
17656 261984 6 93 1557 Bancroft Ave 4 Sidewalk: Property side : Yard Tree 1           6014517 2091967 37.7249591332222 -122.391965574806 (37.7249591332222, -122.391965574806) 10 3 8 58 1
18011 262289 6 36 1601 Innes Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
20461 104283 6 17 150X Middle Point Rd 5 Front Yard : Yard Tree 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
25337 106567 6 17 50 Mendell St 1 Front Yard : Yard Tree 2   05/09/2014 12:00:00 AM     Permit Number 772455 6017061.8 2098665.7 37.7434933850228 -122.383634554004 (37.7434933850228, -122.383634554004) 10 3 8 58 1
26236 99105 6 11 1400@ Mendell Evans Ave 1 Front Yard : Yard Tree 2   04/09/2012 12:00:00 AM     Permit Number 768768 6016404 2098045.1 37.7417529632601 -122.385865834439 (37.7417529632601, -122.385865834439) 10 3 8 58 1
29803 105161 6 40 1600X Oakdale Ave 2 Front Yard : Cutout Tree 19     13 3x3   6014869.34112 2095641.83637 37.735069048787 -122.391004288315 (37.735069048787, -122.391004288315) 10 3 8 58 1
30460 104285 6 17 71X Middle Point Rd 1 Front Yard : Yard Tree 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
34585 104280 6 17 150X Middle Point Rd 2 Front Yard : Yard Tree 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
36574 107552 6 17 1 Newhall St 2 Front Yard : Yard Tree 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
37942 98308 6 17 1490 Fairfax Ave 1 Front Yard : Tree 2   01/25/2012 12:00:00 AM   3x3 Permit Number 768575 6016246.6 2097899.9 37.7413455620636 -122.386399955147 (37.7413455620636, -122.386399955147) 10 3 8 58 1
42183 110954 6 15 126X Mendell St 1 Sidewalk: Property side : Yard Tree 2   05/12/2015 12:00:00 AM 3     6017060.74507 2098543.22184 37.7431570265693 -122.383629676533 (37.7431570265693, -122.383629676533) 10 3 8 58 1
45754 94935 6 463 2451X Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
48640 104279 6 17 150X Middle Point Rd 1 Front Yard : Yard Tree 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
51060 106568 6 17 50 Mendell St 5 Front Yard : Yard Tree 2   05/09/2014 12:00:00 AM     Permit Number 772455 6017061.8 2098665.7 37.7434933850228 -122.383634554004 (37.7434933850228, -122.383634554004) 10 3 8 58 1
53862 173726 6 15 1101 Connecticut St 1 Front Yard : Yard Tree 2           6013424 2101939 37.7522794251173 -122.396442635345 (37.7522794251173, -122.396442635345) 10 3 8 28856 1
56372 107551 6 17 1 Newhall St 1 Front Yard : Yard Tree 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
57862 96848 6 72 1486 Innes Ave   Front Yard : Yard Tree 2           6016133.4 2096820.6 37.7383757570157 -122.386716118251 (37.7383757570157, -122.386716118251) 10 3 8 58 1
58489 104690 6 70 1435X La Salle Ave 1 Front Yard : Yard Tree 2         Permit Number 770699 6016460.43075 2095036.98644 37.7334964128222 -122.385461132957 (37.7334964128222, -122.385461132957) 10 3 8 58 1
59683 104288 6 17 137X Middle Point Rd 1 Front Yard : Yard Tree 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
62092 106569 6 17 50 Mendell St 6 Front Yard : Yard Tree 2   05/09/2014 12:00:00 AM     Permit Number 772455 6017061.8 2098665.7 37.7434933850228 -122.383634554004 (37.7434933850228, -122.383634554004) 10 3 8 58 1
67820 104290 6 17 11X Hare St 1 Front Yard : Yard Tree 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
68149 94937 6 504 2525 Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
70249 113112 6 109 1633 OAKDALE AVE 1 Sidewalk: Curb side : Cutout Tree 2           6014731 2095647 37.7350755495662 -122.391482947841 (37.7350755495662, -122.391482947841) 10 3 8 58 1
72268 94951 6 116 50 Pomona St   : Cutout Tree 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
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
78450 94948 6 40 50 Pomona St   Sidewalk: Property side : Cutout Tree 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
79851 94940 6 246 2525 Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 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
85934 88453 6 62 2801 Oakdale Ave 2 Front Yard : Cutout Tree 2       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 1
89508 98309 6 83 401X Newhall St 1 Front Yard : Tree 2     6 3x3   6016081.14502 2097910.94016 37.7413667159929 -122.386972815546 (37.7413667159929, -122.386972815546) 10 3 8 58 1
96193 88456 6 17 2801 Oakdale Ave 5 Sidewalk: Curb side : Cutout Tree 2   07/15/2008 12:00:00 AM     Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 1
96506 97264 6 9 300 Newhall St 1 Front Yard : Yard Tree 2   09/09/2011 12:00:00 AM     Permit Number 768179 6016549.1 2098591.6 37.7432615694897 -122.385402196424 (37.7432615694897, -122.385402196424) 10 3 8 58 1
101013 94947 6 40 50 Pomona St   Sidewalk: Property side : Cutout Tree 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
102464 248911 6 109 1633 Oakdale Ave 1 Front Yard : Yard Tree 2           6014844.92913 2095599.8976 37.7349525388235 -122.391085759591 (37.7349525388235, -122.391085759591) 10 3 8 58 1
117587 103942 6 17 1490X Evans Ave 1 Front Yard : Yard Tree 2   06/25/2013 12:00:00 AM     Permit Number 770233 6016485.18907 2097945.03196 37.7414826893772 -122.385578134526 (37.7414826893772, -122.385578134526) 10 3 8 58 1
118020 88454 6 62 2801 Oakdale Ave 3 Front Yard : Cutout Tree 2       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 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
119566 104691 6 17 1435X La Salle Ave 2 Front Yard : Yard Tree 2   10/31/2013 12:00:00 AM     Permit Number 770699 6016460.43075 2095036.98644 37.7334964128222 -122.385461132957 (37.7334964128222, -122.385461132957) 10 3 8 58 1
119862 107553 6 17 1 Newhall St 3 Front Yard : Yard Tree 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
126993 104281 6 17 150X Middle Point Rd 3 Front Yard : Yard Tree 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
130009 107550 6 52 198X Jennings St 3 Front Yard : Yard Tree 1           6018784.70414 2097136.12526 37.7393885572332 -122.377570991407 (37.7393885572332, -122.377570991407) 10 3 8 58 1
130983 94950 6 116 50 Pomona St   : Cutout Tree 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
132116 104289 6 17 10X Hare St 1 Front Yard : Yard Tree 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
133009 110951 6 15 220 Newhall St 1 Sidewalk: Property side : Yard Tree 2   05/12/2015 12:00:00 AM 3     6016803.8 2098347.9 37.7426065069695 -122.384504531053 (37.7426065069695, -122.384504531053) 10 3 8 58 1
133125 104286 6 17 200X West Point Rd 1 Front Yard : Yard Tree 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
133191 94939 6 246 2525 Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
135121 98310 6 22 1499@Newhall Evans Ave 2 Front Yard : Tree 2   01/25/2012 12:00:00 AM 4   Permit Number 768575 6016248.7932 2098029.27381 37.7417009175609 -122.386401389915 (37.7417009175609, -122.386401389915) 10 3 8 58 1
135218 94946 6 40 50 Pomona St   Sidewalk: Property side : Cutout Tree 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
138259 94938 6 504 2525 Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
138273 99106 6 11 1400 Evans Ave 3 Front Yard : Yard Tree 2   04/09/2012 12:00:00 AM     Permit Number 768768 6016404 2098045.1 37.7417529632601 -122.385865834439 (37.7417529632601, -122.385865834439) 10 3 8 58 1
138601 88455 6 62 2801 Oakdale Ave 4 Front Yard : Cutout Tree 2       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 1
140790 108047 6 22 1301 Evans Ave 4 Sidewalk: Curb side : Cutout Tree 2   06/12/2015 12:00:00 AM 3 3x3   6017036.14467 2097442.01922 37.7401319873023 -122.383638088928 (37.7401319873023, -122.383638088928) 10 3 8 58 1
141742 110952 6 15 220 Newhall St 8 Sidewalk: Property side : Yard Tree 2   05/12/2015 12:00:00 AM 3     6016803.8 2098347.9 37.7426065069695 -122.384504531053 (37.7426065069695, -122.384504531053) 10 3 8 58 1
144050 94941 6 246 2525 Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 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
146688 110953 6 15 220 Newhall St 10 Sidewalk: Property side : Yard Tree 2   05/12/2015 12:00:00 AM 3     6016803.8 2098347.9 37.7426065069695 -122.384504531053 (37.7426065069695, -122.384504531053) 10 3 8 58 1
148080 88457 6 17 2801 Oakdale Ave 6 Sidewalk: Curb side : Cutout Tree 2   07/15/2008 12:00:00 AM     Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 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