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                      
25771 194495 1 15 2 Tulare St 13 Front Yard : Yard Tree 2     6     6016190.05979 2100302.20421 37.7479386656413 -122.38676294076 (37.7479386656413, -122.38676294076)   3 8 58 1
43756 194494 1 15 3305 03rd St 2 Sidewalk: Property side : Yard Tree 2     22 Width 10ft   6016095.96516 2099918.62991 37.7468802400244 -122.387061569634 (37.7468802400244, -122.387061569634)   3 8 58 1
72343 194496 1 15 2 Tulare St 10 Front Yard : Yard Tree 2     9     6016213.72406 2100305.90107 37.7479501266034 -122.386681367746 (37.7479501266034, -122.386681367746)   3 8 58 1
34 262408 8 15 66X Edgehill Way 1 Unaccepted Street : Yard Tree 2       3x3   5994840 2098758 37.7424934921887 -122.46047813267 (37.7424934921887, -122.46047813267) 1 8 4 59 40
63 264975 6 15 445 Ortega St 1 Front Yard : Yard Tree 2       10x30   5992686 2102646 37.7530447932571 -122.468208733714 (37.7530447932571, -122.468208733714) 1 8 4 56 12
68 264976 6 15 445 Ortega St 2 Front Yard : Yard Tree 2       10x30   5992686 2102646 37.7530447932571 -122.468208733714 (37.7530447932571, -122.468208733714) 1 8 4 56 12
182 20628 1 15 1492X Sunset Blvd 11 Median : Cutout Tree 1     36 60   5984803.7392562 2105036.6950477 37.7591505890295 -122.495643037613 (37.7591505890295, -122.495643037613) 1 8 3 56 35
228 256437 4 15 3001 Sunset Blvd 25 Median : Yard Tree 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
230 114428 4 15 34x HIGUERA AVE 2 Median : Yard Tree 2     56     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
243 21365 1 15 2592X Sunset Blvd 27 Sidewalk: Curb side : Cutout Tree 1     48 60   5985018.1742183 2097562.094386 37.7386399329486 -122.494350460592 (37.7386399329486, -122.494350460592) 1 8 3 29491 35
256 254254 6 15 45X Everglade Dr 1 Sidewalk: Property side : Yard Tree 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
306 20543 1 15 1303X Sunset Blvd 21 Sidewalk: Curb side : Cutout Tree 1     36 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.495741360313 (37.7626943540195, -122.495741360313) 1 8 3 56 35
451 114938 4 15 4400x OCEAN AVE 14 Front Yard : Cutout Tree 2       3x3   5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
515 262251 4 15 4210 Ocean Ave 4 Sidewalk: Property side : Yard Tree 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
567 181420 1 15 1500 Sunset Blvd 53 Sidewalk: Property side : Yard Tree 2     5 Width 0ft   5984891.1718 2104759.369 37.7583942485176 -122.495320206303 (37.7583942485176, -122.495320206303) 1 8 3 56 35
628 256542 8 15 133 Olympia Way 1 Back Yard : Yard Tree 2       3x3   5996852 2101844 37.7510824274474 -122.453744067192 (37.7510824274474, -122.453744067192) 1 5 4 63 38
724 178311 1 15 300 Serrano Dr 1 Sidewalk: Curb side : Yard Tree 2     38 10x10   5989003 2090507 37.7195008394357 -122.480056810171 (37.7195008394357, -122.480056810171) 1 8 4 64 14
932 111099 4 15 480X LAKESHORE DR 20 Median : Cutout Tree 1       30x200   5984942 2095282 37.7323749444343 -122.494445798495 (37.7323749444343, -122.494445798495) 1 8 4 64 35
1189 261265 8 15 1100X Portola Dr 5 Median : Yard Tree 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
1378 95407 1 15 2X Cranleigh Dr 9 Median : Yard Tree 1     80     5991370.3 2095943.7 37.7345659248964 -122.472270103664 (37.7345659248964, -122.472270103664) 1 8 4 64 40
1536 187084 1 15 2600 Sunset Blvd 20 Sidewalk: Property side : Yard Tree 2     23 Width 0ft   5985178.0339 2097042.9902 37.7372239657972 -122.493759507537 (37.7372239657972, -122.493759507537) 1 8 3 29491 35
2174 173658 1 15 1200X JUNIPERO SERRA BLVD 46 Sidewalk: Property side : Yard Tree 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
2194 261477 1 15 1000 Portola Dr 6 Median : Yard Tree 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40