trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
689 119914 1 15 400X Brotherhood Way 1 Front Yard : Yard Tree 1       100x100                      
815 20416 1 15 453X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree 1     18 60                      
844 254210 1 15 300x Esmeralda Ave 20 Unaccepted Street : Yard Tree 1                              
1144 20400 1 15 262X Sunset Blvd 45 Sidewalk: Curb side : Cutout Tree 1     18 60                      
1176 119263 1 15 495X Lakeshore Dr 1 Median : Yard Tree 1       10x30                      
1531 20287 1 15 20X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree 1     12 60                      
1886 20313 1 15 101X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree 1     12 60                      
1978 87100 7 15 700 Connecticut St 1 Front Yard : Yard Tree 5       3x3 Permit Number 50056                    
1982 20405 1 15 262X Sunset Blvd 50 Sidewalk: Curb side : Cutout Tree 1     6 60                      
2568 20451 1 15 495X Sunset Blvd 16 Sidewalk: Curb side : Cutout Tree 1     42 60                      
2812 19775 1 15 100 STAIRWAY18 1 Sidewalk: Curb side : Cutout Tree 1     12 50ST                      
3000 20052 1 15 100 STAIRWAY53 1 Sidewalk: Curb side : Cutout Tree 1     12 30                      
3106 20323 1 15 101X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree 1     12 60                      
3639 20284 1 15 20X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree 1     12 60                      
4038 20457 1 15 495X Sunset Blvd 22 Sidewalk: Curb side : Cutout Tree 1     12 60                      
4494 20293 1 15 20X Sunset Blvd 14 Sidewalk: Curb side : Cutout Tree 1     42 60                      
4731 19749 1 15 100 STAIRWAY15 5 Sidewalk: Curb side : Cutout Tree 1     6 10ST                      
4776 19969 1 15 100 STAIRWAY43 2 Sidewalk: Curb side : Cutout Tree 1     6 15                      
5041 20311 1 15 50X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree 1     36 60                      
5216 20045 1 15 100 STAIRWAY52 1 Sidewalk: Curb side : Cutout Tree 1     12 10                      
6109 20338 1 15 101X Sunset Blvd 25 Sidewalk: Curb side : Cutout Tree 1     48 40                      
6239 261665 1 15 401X Greenwich St 1 Unaccepted Street : Cutout Tree 1                              
6415 20399 1 15 262X Sunset Blvd 44 Sidewalk: Curb side : Cutout Tree 1     42 60                      
6528 20289 1 15 20X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree 1     42 60                      
6752 20418 1 15 453X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree 1     12 60                      
6984 20069 1 15 100 STAIRWAY55 2 Sidewalk: Curb side : Cutout Tree 1     36 40ST                      
7041 20329 1 15 101X Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree 1     42 60                      
7330 20367 1 15 262X Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree 1     42 60                      
7403 20408 1 15 262X Sunset Blvd 53 Sidewalk: Curb side : Cutout Tree 1     12 60                      
7420 20458 1 15 495X Sunset Blvd 23 Sidewalk: Curb side : Cutout Tree 1     42 60                      
8084 20421 1 15 453X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree 1     12 60                      
8135 20290 1 15 20X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree 1     42 60                      
8660 20402 1 15 262X Sunset Blvd 47 Sidewalk: Curb side : Cutout Tree 1     48 60                      
8757 20337 1 15 101X Sunset Blvd 24 Sidewalk: Curb side : Cutout Tree 1     48 40                      
8781 94862 7 15   2 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 53932                    
9087 20433 1 15 485X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree 1     6 30                      
9165 20427 1 15 453X Sunset Blvd 16 Sidewalk: Curb side : Cutout Tree 1     12 60                      
9285 20285 1 15 20X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree 1     12 60                      
9368 20394 1 15 262X Sunset Blvd 39 Sidewalk: Curb side : Cutout Tree 1     36 60                      
10032 254212 1 15 81X Elsie St 10 Back Yard : Yard Tree 1                              
10108 94859 7 15   1 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 53932                    
10142 20420 1 15 453X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree 1     12 60                      
11212 20461 1 15 495X Sunset Blvd 26 Sidewalk: Curb side : Cutout Tree 1     6 60                      
11436 20292 1 15 20X Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree 1     36 60                      
11490 20283 1 15 20X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree 1     36 60                      
11544 20435 1 15 485X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree 1     6 30                      
11775 173632 1 15 3300X Market St 1 Side Yard : Yard Tree 2                              
11955 20344 1 15 101X Sunset Blvd 30 Sidewalk: Curb side : Cutout Tree 1     24 40                      
11962 19853 1 15 100 STAIRWAY29 3 Sidewalk: Curb side : Cutout Tree 1     12 100ST                      
11998 20308 1 15 50X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree 1     48 60                      
12112 20431 1 15 485X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree 1     36 30                      
12400 20426 1 15 453X Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree 1     12 60                      
12659 122532 1 15 1900X Castro St 1 Unaccepted Street : Yard Tree 2                              
12894 20288 1 15 20X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree 1     12 60                      
13192 20368 1 15 262X Sunset Blvd 18 Sidewalk: Curb side : Cutout Tree 1     3 60                      
13588 20425 1 15 453X Sunset Blvd 14 Sidewalk: Curb side : Cutout Tree 1     18 60                      
14170 20388 1 15 262X Sunset Blvd 34 Sidewalk: Curb side : Cutout Tree 1     24 60                      
14280 20070 1 15 100 STAIRWAY55 3 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
14435 20307 1 15 50X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree 1     48 60                      
14843 19968 1 15 100 STAIRWAY43 1 Sidewalk: Curb side : Cutout Tree 1     12 15                      
15008 20387 1 15 262X Sunset Blvd 33 Sidewalk: Curb side : Cutout Tree 1     24 60                      
15020 20401 1 15 262X Sunset Blvd 46 Sidewalk: Curb side : Cutout Tree 1     12 60                      
15093 119607 6 15 299x Avalon Ave 3 Front Yard : Yard Tree 2                              
15154 102838 4 15 1101X Portola Dr 1 Sidewalk: Property side : Yard Tree 1                              
15388 20295 1 15 20X Sunset Blvd 16 Sidewalk: Curb side : Cutout Tree 1     6 60                      
16184 19977 1 15 100 STAIRWAY45 4 Sidewalk: Curb side : Cutout Tree 1     24 30ST                      
16196 251543 1 15 0X Bay Shore Blvd Off Ramp   Side Yard : Yard Tree 2                              
16290 20286 1 15 20X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree 1     12 60                      
16411 20053 1 15 100 STAIRWAY53 2 Sidewalk: Curb side : Cutout Tree 1     12 30                      
17047 20343 1 15 101X Sunset Blvd 29 Sidewalk: Curb side : Cutout Tree 1     48 40                      
17057 20306 1 15 50X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree 1     18 60                      
18328 20339 1 15 101X Sunset Blvd 26 Sidewalk: Curb side : Cutout Tree 1     48 40                      
18358 20374 1 15 262X Sunset Blvd 22 Sidewalk: Curb side : Cutout Tree 1     18 60                      
18372 121500 1 15 251X Pennsylvania Ave 1 Back Yard : Yard Tree 1                              
18633 20454 1 15 495X Sunset Blvd 19 Sidewalk: Curb side : Cutout Tree 1     36 60                      
18945 20432 1 15 485X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree 1     42 30                      
19039 20396 1 15 262X Sunset Blvd 41 Sidewalk: Curb side : Cutout Tree 1     48 60                      
19072 20380 1 15 262X Sunset Blvd 26 Sidewalk: Curb side : Cutout Tree 1     48 60                      
104502 201550 1 15 200 Jerrold Ave 1 Sidewalk: Property side : Yard Tree 2     31     6020135.10106 2093474.49697 37.7294087400981 -122.372648486831 (37.7294087400981, -122.372648486831) 10 3 8 58 1
179421 201551 1 15 200 Jerrold Ave 2 Sidewalk: Property side : Yard Tree 2     31     6020116.66531 2093486.63817 37.7294410644355 -122.372713061779 (37.7294410644355, -122.372713061779) 10 3 8 58 1
64408 201553 1 15 200 Jerrold Ave 4 Sidewalk: Property side : Yard Tree 2     31     6019956.36355 2093604.98051 37.72975719952 -122.373275437534 (37.72975719952, -122.373275437534) 10 3 8 58 1
90979 201554 1 15 200 Jerrold Ave 5 Sidewalk: Property side : Yard Tree 2     37     6019933.48911 2093619.80077 37.7297966356963 -122.373355543719 (37.7297966356963, -122.373355543719) 10 3 8 58 1
191706 201555 1 15 200 Jerrold Ave 6 Sidewalk: Property side : Yard Tree 2     10     6019901.03231 2093652.00045 37.7298832655955 -122.373469980666 (37.7298832655955, -122.373469980666) 10 3 8 58 1
109134 201556 1 15 200 Jerrold Ave 7 Sidewalk: Property side : Yard Tree 2     27     6019865.26747 2093672.49383 37.729937570248 -122.373595043971 (37.729937570248, -122.373595043971) 10 3 8 58 1
107167 201557 1 15 200 Jerrold Ave 8 Sidewalk: Property side : Yard Tree 2     25 Width 9ft   6019843.77362 2093685.40293 37.7299718344327 -122.373670245296 (37.7299718344327, -122.373670245296) 10 3 8 58 1
177739 201558 1 15 200 Jerrold Ave 9 Sidewalk: Property side : Yard Tree 2     12 Width 7ft   6019824.62434 2093697.32313 37.7300035121512 -122.373737272669 (37.7300035121512, -122.373737272669) 10 3 8 58 1
154609 201560 1 15 200 Jerrold Ave 11 Sidewalk: Property side : Yard Tree 2     19 Width 5ft   6019794.81537 2093720.05192 37.7300642820202 -122.373841900702 (37.7300642820202, -122.373841900702) 10 3 8 58 1
37949 201567 1 15 799 Jerrold Ave 2 Sidewalk: Property side : Yard Tree 2     15 Width 9ft   6019712.53243 2093705.44833 37.7300196585793 -122.374125355309 (37.7300196585793, -122.374125355309) 10 3 8 58 1
25286 201566 1 15 799 Jerrold Ave 1 Sidewalk: Property side : Yard Tree 2     11     6019697.16467 2093717.76615 37.7300526357971 -122.374179337111 (37.7300526357971, -122.374179337111) 10 3 8 58 1
4778 201565 1 15 200 Jerrold Ave 16 Sidewalk: Property side : Yard Tree 2     45     6019673.98228 2093813.82501 37.7303151200443 -122.374266134286 (37.7303151200443, -122.374266134286) 10 3 8 58 1
31671 194519 1 15 1108 Griffith St 1 Sidewalk: Property side : Yard Tree 2     24 Width 8ft   6018142.03115 2092982.0233 37.7279467796967 -122.379504594361 (37.7279467796967, -122.379504594361) 10 3 8 58 1
118529 194499 1 15 1300 Evans Ave 2 Sidewalk: Property side : Yard Tree 2     17     6018054.76691 2096792.7027 37.7384053438433 -122.380070961312 (37.7384053438433, -122.380070961312) 10 3 8 58 1
129898 254394 4 15 1237 Ingalls St 1 Sidewalk: Property side : Yard Tree 2       3x3   6017509 2093925 37.7305010756826 -122.381758580005 (37.7305010756826, -122.381758580005) 10 3 8 58 1
61677 194518 1 15 15x Reuel Ct 2 Median : Yard Tree 1     16     6017388.67134 2096078.81136 37.7364083704432 -122.382324365581 (37.7364083704432, -122.382324365581) 10 3 8 58 1
62956 194517 1 15 15 Reuel Ct 1 : Tree 2     31     6017370.39077 2096095.66056 37.7364536252419 -122.382388741749 (37.7364536252419, -122.382388741749) 10 3 8 58 1
5980 113539 1 15 100X CASHMERE ST 2 Median : Yard Tree 1     20     6017054 2095889 37.7358686950692 -122.383468266853 (37.7358686950692, -122.383468266853) 10 3 8 58 1
66798 113536 1 15 100X CASHMERE ST 3 Median : Yard Tree 1           6017054 2095889 37.7358686950692 -122.383468266853 (37.7358686950692, -122.383468266853) 10 3 8 58 1
77642 113535 1 15 100X CASHMERE ST 1 Median : Yard Tree 1   12/05/2015 12:49:00 PM 3     6017054 2095889 37.7358686950692 -122.383468266853 (37.7358686950692, -122.383468266853) 10 3 8 58 1
104162 113537 1 15 100X CASHMERE ST 4 Median : Yard Tree 1           6017054 2095889 37.7358686950692 -122.383468266853 (37.7358686950692, -122.383468266853) 10 3 8 58 1
128651 113538 1 15 100X CASHMERE ST 5 Median : Yard Tree 1           6017054 2095889 37.7358686950692 -122.383468266853 (37.7358686950692, -122.383468266853) 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