trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1303 35175 7 16   7 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
1340 87020 7 16 10 Osceola Dr 2 Sidewalk: Property side : Cutout Tree 2   12/05/2007 12:00:00 AM     Permit Number 49949                    
1492 20444 1 16 495X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree 1     12 15                      
2323 35205 7 16   16 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2511 20282 1 16 20X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree 1     12 60                      
2538 20304 1 16 50X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree 1     12 60                      
3339 19580 1 16 100 STAIRWAY4 3 Sidewalk: Curb side : Cutout Tree 1     3 8                      
3634 20382 1 16 262X Sunset Blvd 28 Sidewalk: Curb side : Cutout Tree 1     18 60                      
3913 35208 7 16   13 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
3997 20436 1 16 495X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree 1     3 15                      
4295 20447 1 16 495X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree 1     12 15                      
4531 20442 1 16 495X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree 1     12 15                      
4587 35197 7 16   17 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
5218 19581 1 16 100 STAIRWAY4 4 Sidewalk: Curb side : Cutout Tree 1     3 8                      
5272 20437 1 16 495X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree 1     3 15                      
5362 109193 7 16 4124 Moraga Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/02/2015 12:00:00 AM 3 3x3 Permit Number 773525                    
5850 20445 1 16 495X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree 1     12 15                      
6596 20449 1 16 495X Sunset Blvd 14 Sidewalk: Curb side : Cutout Tree 1     12 15                      
6911 20443 1 16 495X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree 1     12 15                      
6998 20438 1 16 495X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree 1     12 15                      
7474 35177 7 16   5 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
8283 19872 1 16 100 STAIRWAY33 4 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
8676 34246 7 16   1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 38056                    
9631 35176 7 16   6 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
9856 35210 7 16   11 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
10004 20406 1 16 262X Sunset Blvd 51 Sidewalk: Curb side : Cutout Tree 1     12 60                      
10031 35174 7 16   8 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
10516 102842 4 16 1101X Portola Dr 8 Sidewalk: Property side : Yard Tree 1                              
10526 20383 1 16 262X Sunset Blvd 29 Sidewalk: Curb side : Cutout Tree 1     18 60                      
10547 20439 1 16 495X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree 1     3 15                      
10551 35179 7 16   3 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
10979 35203 7 16   20 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
11384 258014 1 16 4222 Moraga Ave 1 Sidewalk: Curb side : Tree 1                              
11690 35212 7 16   19 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
11860 20441 1 16 495X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree 1     18 15                      
11862 260530 1 16 1790x 46th Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 07/27/2019 12:00:00 AM 3                        
12844 35183 7 16   1 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
13065 20384 1 16 262X Sunset Blvd 30 Sidewalk: Curb side : Cutout Tree 1     18 60                      
13515 35181 7 16   9 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
13897 20448 1 16 495X Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree 1     12 15                      
14056 20375 1 16 262X Sunset Blvd 23 Sidewalk: Curb side : Cutout Tree 1     18 60                      
14273 20403 1 16 262X Sunset Blvd 48 Sidewalk: Curb side : Cutout Tree 1     12 60                      
14818 20309 1 16 50X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree 1     12 60                      
14889 35207 7 16   14 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
14939 20281 1 16 20X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree 1     12 60                      
15355 20450 1 16 495X Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree 1     12 15                      
15456 20376 1 16 262X Sunset Blvd 24 Sidewalk: Curb side : Cutout Tree 1     18 60                      
15754 35209 7 16   12 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
15758 260531 1 16 1790x 46th Ave 2 Sidewalk: Curb side : Cutout Tree 1 FUF 07/27/2019 12:00:00 AM 3                        
16160 20446 1 16 495X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree 1     6 15                      
16270 35178 7 16   4 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
16636 35198 7 16   10 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
17105 20440 1 16 495X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree 1     12 30                      
17110 35180 7 16   2 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
17377 260517 1 16 4711x Lincoln Way 2 Sidewalk: Curb side : Cutout Tree 1 FUF 04/27/2019 12:00:00 AM 3                        
17847 20000 1 16 100 STAIRWAY46 20 Sidewalk: Curb side : Cutout Tree 1     6 2                      
18187 35206 7 16   15 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
18230 35204 7 16   18 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
18875 46976 7 16 94122 47th Ave 1 Sidewalk: Curb side : Cutout Tree 2   05/01/2002 12:00:00 AM     Permit Number 44996                    
19559 19579 1 16 100 STAIRWAY4 2 Sidewalk: Curb side : Cutout Tree 1     3 3X3                      
46781 90290 1 16 4825X Balboa St 3 Sidewalk: Curb side : Cutout Tree 1   04/24/2008 12:00:00 AM 3 3x3   5980449 2110794 37.7747024934985 -122.511131484433 (37.7747024934985, -122.511131484433) 11 6 2 55 26
22814 65028 1 16 4875 Balboa St 1 Sidewalk: Curb side : Cutout Tree 2   05/01/1989 12:00:00 AM 3   Permit Number 26080 5980518.0662 2110908.19812 37.77502012338 -122.510901064292 (37.77502012338, -122.510901064292) 11 6 2 55 26
91851 90291 1 16 4800X Balboa St 4 Sidewalk: Curb side : Cutout Tree 1   04/24/2008 12:00:00 AM 3 3x3   5980520.08002 2110961.83438 37.7751675115073 -122.510898085477 (37.7751675115073, -122.510898085477) 11 6 2 55 26
2953 118676 1 16 4825 Balboa St 3 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   5980559.76523 2110909.18852 37.7750253031785 -122.510756894567 (37.7750253031785, -122.510756894567) 11 6 2 55 26
76279 118675 1 16 4825 Balboa St 2 Sidewalk: Curb side : Cutout Tree 2     3 Width 3ft   5980581.14799 2110910.44383 37.7750300115108 -122.510683021621 (37.7750300115108, -122.510683021621) 11 6 2 55 26
61519 118674 1 16 4825 Balboa St 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   5980614.91009 2110910.7476 37.7750328375051 -122.510566255892 (37.7750328375051, -122.510566255892) 11 6 2 55 26
103558 118904 1 16 701 La Playa 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   5980709.06279 2110874.30302 37.774938325765 -122.510237858768 (37.774938325765, -122.510237858768) 11 6 2 55 26
78192 46282 1 16 705 La Playa 1 Sidewalk: Curb side : Cutout Tree 2   01/31/2002 12:00:00 AM 5   Permit Number 44561 5980709.06285 2110831.64762 37.7748212066407 -122.510234688625 (37.7748212066407, -122.510234688625) 11 6 2 55 26
186180 46284 1 16 711 La Playa 1 Sidewalk: Curb side : Cutout Tree 2   01/31/2002 12:00:00 AM 7   Permit Number 44563 5980709.97353 2110788.74424 37.7747034603493 -122.510228350103 (37.7747034603493, -122.510228350103) 11 6 2 55 26
104383 41420 1 16 725 La Playa 1 Sidewalk: Curb side : Cutout Tree 2   03/17/2000 12:00:00 AM 6 5x5 Permit Number 42027 5980710.81691 2110753.36996 37.7746063827707 -122.510222803918 (37.7746063827707, -122.510222803918) 11 6 2 55 26
113922 41421 1 16 731A B C La Playa 1 Sidewalk: Curb side : Cutout Tree 2   03/17/2000 12:00:00 AM 7   Permit Number 42028 5980717.31821 2110693.46667 37.774442289512 -122.51019586344 (37.774442289512, -122.51019586344) 11 6 2 55 26
101064 41422 1 16 737A B C La Playa 1 Sidewalk: Curb side : Cutout Tree 2   03/17/2000 12:00:00 AM 7   Permit Number 42029 5980718.37612 2110657.40313 37.7743433320773 -122.510189524011 (37.7743433320773, -122.510189524011) 11 6 2 55 26
46558 41423 1 16 743A B C La Playa 1 Sidewalk: Curb side : Cutout Tree 2   03/17/2000 12:00:00 AM 6   Permit Number 42030 5980719.58689 2110639.12886 37.7742932277433 -122.510183977803 (37.7742932277433, -122.510183977803) 11 6 2 55 26
38854 40217 1 16 755 La Playa 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/06/1999 12:00:00 AM 9   Permit Number 41396 5980721.24963 2110609.89549 37.7742130596134 -122.51017605379 (37.7742130596134, -122.51017605379) 11 6 2 55 26
134919 46283 7 16 4801 Balboa St 1 Sidewalk: Curb side : Cutout Tree 2   01/31/2002 12:00:00 AM     Permit Number 44562 5980721.66048407 2110916.40891105 37.7750546792032 -122.510197410494 (37.7750546792032, -122.510197410494) 11 6 2 55 26
153617 118910 1 16 779 La Playa 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   5980721.87491 2110457.73462 37.7737953076248 -122.510162583557 (37.7737953076248, -122.510162583557) 11 6 2 55 26
148415 118909 1 16 775 La Playa 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   5980722.52384 2110466.61703 37.7738197343812 -122.510160998907 (37.7738197343812, -122.510160998907) 11 6 2 55 26
124925 118906 1 16 763 La Playa 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   5980722.84871 2110577.69802 37.7741247491826 -122.510168129734 (37.7741247491826, -122.510168129734) 11 6 2 55 26
59157 118907 1 16 767 La Playa 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   5980723.00275 2110520.89615 37.7739687970878 -122.510163375859 (37.7739687970878, -122.510163375859) 11 6 2 55 26
47234 118905 1 16 759 La Playa 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   5980723.1377 2110591.1502 37.7741617019468 -122.51016812974 (37.7741617019468, -122.51016812974) 11 6 2 55 26
98871 118911 1 16 783 La Playa 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   5980723.51809 2110427.58911 37.7737126338651 -122.510154659499 (37.7737126338651, -122.510154659499) 11 6 2 55 26
87742 118912 1 16 787 La Playa 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   5980724.35298 2110402.47948 37.7736437394687 -122.510149905624 (37.7736437394687, -122.510149905624) 11 6 2 55 26
120926 118908 1 16 771 La Playa 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   5980724.52574 2110506.49264 37.7739293391312 -122.510157037335 (37.7739293391312, -122.510157037335) 11 6 2 55 26
45822 118913 1 16 791 La Playa 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   5980726.27409 2110374.60886 37.7735673282771 -122.51014118926 (37.7735673282771, -122.51014118926) 11 6 2 55 26
63024 118914 1 16 795 La Playa 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   5980726.65599 2110349.737 37.7734990600053 -122.510138020006 (37.7734990600053, -122.510138020006) 11 6 2 55 26
129300 118915 1 16 825 La Playa 1 Sidewalk: Curb side : Cutout Tree 1   03/29/2018 12:00:00 AM 3 4x4   5980733.09837 2110116.47079 37.772858959689 -122.510098401613 (37.772858959689, -122.510098401613) 11 6 2 55 26
141530 118918 1 16 855 La Playa 2 Sidewalk: Curb side : Cutout Tree 2     9 Width 4ft   5980739.80677 2109948.89302 37.7723992361183 -122.510062744773 (37.7723992361183, -122.510062744773) 11 6 2 55 26
161371 118923 1 16 855 La Playa 7 Sidewalk: Curb side : Cutout Tree 2     11 Width 4ft   5980744.20111 2109822.88075 37.7720535026603 -122.510038181246 (37.7720535026603, -122.510038181246) 11 6 2 55 26
167368 118925 1 16 855 La Playa 9 Sidewalk: Curb side : Cutout Tree 2     9 Width 4ft   5980744.81689 2109798.23147 37.7719858593014 -122.510034219696 (37.7719858593014, -122.510034219696) 11 6 2 55 26
113108 90287 1 16 4740 Balboa St 1 Sidewalk: Curb side : Cutout Tree 1   04/24/2008 12:00:00 AM 3 3x3   5980821.75322 2110975.07524 37.775221663232 -122.509855533094 (37.775221663232, -122.509855533094) 11 6 2 55 26
24254 186636 1 16 1300 Lower Great Hwy 12 unknown : Yard Tree 2     3 Width 0ft   5980864.6099 2105729.0507 37.7608201372164 -122.509317602916 (37.7608201372164, -122.509317602916) 1 8 3 56 35
102296 186625 1 16 1300 Lower Great Hwy 1 unknown : Yard Tree 2     2 Width 0ft   5980868.2988 2105582.371 37.7604176144972 -122.50929395155 (37.7604176144972, -122.50929395155) 1 8 3 56 35
47826 186634 1 16 1300 Lower Great Hwy 10 unknown : Yard Tree 2     2 Width 0ft   5980874.0957 2105690.7559 37.7607155500113 -122.509281952349 (37.7607155500113, -122.509281952349) 1 8 3 56 35
91321 186519 1 16 1400 Lower Great Hwy 7 unknown : Yard Tree 2     3 Width 0ft   5980902.9388 2105057.6001 37.758978786758 -122.509135180581 (37.758978786758, -122.509135180581) 1 8 3 56 35
107456 186508 1 16 1400 Lower Great Hwy 9 unknown : Yard Tree 2     3 Width 0ft   5980903.4565 2105112.4796 37.7591295006299 -122.509137465432 (37.7591295006299, -122.509137465432) 1 8 3 56 35
61294 90296 1 16 4725 Balboa St 1 Sidewalk: Curb side : Cutout Tree 1   04/24/2008 12:00:00 AM 3 3x3   5980914.47368 2110921.9769 37.7750813387497 -122.509530853193 (37.7750813387497, -122.509530853193) 11 6 2 55 26
98577 181618 1 16 1396 La Playa 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 0ft   5980931.0935 2105583.8021 37.7604252460715 -122.509076883921 (37.7604252460715, -122.509076883921) 1 8 3 56 35
167968 183264 1 16 1396 La Playa 2 Sidewalk: Curb side : Cutout Tree 2     4 Width 0ft   5980931.0935 2105603.235 37.7604786032233 -122.509078326964 (37.7604786032233, -122.509078326964) 1 8 3 56 35
76858 47887 7 16 1396 La Playa St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/19/2002 12:00:00 AM     Permit Number 45633 5980936.26532386 2105566.37783375 37.7603777089466 -122.509057703423 (37.7603777089466, -122.509057703423) 1 8 3 56 35
188388 47888 7 16 1396 La Playa St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 06/19/2002 12:00:00 AM     Permit Number 45633 5980936.26532386 2105566.37783375 37.7603777089466 -122.509057703423 (37.7603777089466, -122.509057703423) 1 8 3 56 35
53430 83316 7 16 1516 Great Hwy 2 Sidewalk: Curb side : Cutout Tree 2   01/24/2008 12:00:00 AM   3x3 Permit Number 50185 5980939.77097966 2104729.07463785 37.7580789214423 -122.508983405944 (37.7580789214423, -122.508983405944) 1 8 3 56 35