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                    
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
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
178439 107539 6 52 198X JENNINGS ST 1 Front Yard : Yard Tree 1           6018784 2097136 37.739388174499 -122.377573417349 (37.739388174499, -122.377573417349) 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
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
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
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
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
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
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
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
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
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
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
156652 104284 6 17 45X 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
174752 104282 6 17 150X Middle Point Rd 4 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
182512 104287 6 17 119X 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
182689 108589 6 17 1139x HUDSON AVE 1 Sidewalk: Curb side : Yard Tree 2           6017760 2094672 37.7325660477977 -122.380942739781 (37.7325660477977, -122.380942739781) 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
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
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
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
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
162063 113132 6 109 1375 FAIRFAX AVE 1 Front Yard : Yard Tree 2           6016814 2097238 37.7395595104895 -122.384391976269 (37.7395595104895, -122.384391976269) 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
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
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
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
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
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
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
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
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
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
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
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
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
172566 94942 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
179763 94944 6 568 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
182637 94936 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
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
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
164393 120551 6 70 1485 Fairfax Ave 1 Front Yard : Yard Tree 2           6016296 2097688 37.7407664622153 -122.386214376382 (37.7407664622153, -122.386214376382) 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
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
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
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
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
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
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
173631 96998 6 68 2451X Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF         6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
175413 96996 6 82 2451X Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF         6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
41328 121446 6 17 500 Terry A Francois Blvd 1 Sidewalk: Property side : Cutout Tree 2       3x3   6016102 2110410 37.775687633053 -122.387772601034 (37.775687633053, -122.387772601034) 14 3 9 310 20
4313 105327 6 17 2051 03rd St 1 Back Yard : Yard Tree 2         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631) 14 3 8 28856 29
7964 105328 6 17 2051 03rd St 2 Back Yard : Yard Tree 2         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631) 14 3 8 28856 29
60629 106612 6 91 1189 TENNESSEE ST   Front Yard : Yard Tree 2     55     6015654.1 2103577.3 37.7569017014681 -122.388844893024 (37.7569017014681, -122.388844893024) 10 3 8 28856 29
40244 115123 6 11 499X MAIN ST 1 Sidewalk: Curb side : Cutout Tree 2     12     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
46337 115125 6 11 499X MAIN ST 3 Sidewalk: Curb side : Cutout Tree 2     8     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
110338 115124 6 11 499X MAIN ST 2 Sidewalk: Curb side : Cutout Tree 2     8     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
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
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
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
179978 105160 6 28 1600X OAKDALE AVE 1 Front Yard : Yard Tree 19     13   Permit Number 770204 6015006 2095503 37.7346954145828 -122.390522107646 (37.7346954145828, -122.390522107646) 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
3099 104652 6 97 953 Indiana St 1 Front Yard : Cutout Tree 2           6015057.1 2104275.7 37.7587862506702 -122.390958369803 (37.7587862506702, -122.390958369803) 10 3 8 28856 29
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
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
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
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
48723 96186 6 17 333 Harrison St 3 Sidewalk: Property side : Tree 2         Permit Number 767224 6015127.7 2114620.1 37.7871935976335 -122.39143736362 (37.7871935976335, -122.39143736362) 6 2 9 28855 6
93660 96184 6 17 333 Harrison St 1 Sidewalk: Property side : Tree 2         Permit Number 767224 6015127.7 2114620.1 37.7871935976335 -122.39143736362 (37.7871935976335, -122.39143736362) 6 2 9 28855 6