trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
116 113159 4 52 555 GROVE ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6005146 2111243 37.777361853017 -122.425731455878 (37.777361853017, -122.425731455878) 7 9 11 28852 10
163 17253 1 52 15 Osceola Ln 1 Sidewalk: Curb side : Cutout Tree 1     24 3X3   6017345.102761 2094248.0837329 37.7313791485056 -122.382347671583 (37.7313791485056, -122.382347671583) 10 3 8 58 1
308 102295 7 52 1500 Michigan St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6016449 2101073.5 37.7500708170088 -122.385921283567 (37.7500708170088, -122.385921283567) 10 3 8 58 1
400 104991 4 52 669X NOE ST 1 Sidewalk: Curb side : Cutout Tree 2     18 3x3   6003139 2104447 37.7585880783392 -122.432188863302 (37.7585880783392, -122.432188863302) 2 4 5 28862 3
445 110235 4 52 2346x CASTRO ST 1 Median : Cutout Tree 2       3x3   6002664.5 2098664.4 37.7426835115852 -122.433416673574 (37.7426835115852, -122.433416673574) 2 7 5 63 7
454 11293 1 52 1199X Ingalls St 5 Sidewalk: Curb side : Cutout Tree 1     60 3X3   6017612.0195749 2093925.7037957 37.7305086962257 -122.381402471608 (37.7305086962257, -122.381402471608) 10 3 8 58 1
900 19637 1 52 100 STAIRWAY5 36 Sidewalk: Curb side : Cutout Tree 1     12 30                      
1171 19952 1 52 100 STAIRWAY39 9 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
1272 113499 1 52 200x Mansell St 5 Median : Cutout Tree 1     19 3x3   6011193.56936 2090563.53064 37.7209204242214 -122.403355677147 (37.7209204242214, -122.403355677147) 10 7 7 309 28
1350 19628 1 52 100 STAIRWAY5 27 Sidewalk: Curb side : Cutout Tree 1     6 30                      
1420 19991 1 52 100 STAIRWAY46 11 Sidewalk: Curb side : Cutout Tree 1     12 40                      
2026 19643 1 52 100 STAIRWAY5 42 Sidewalk: Curb side : Cutout Tree 1     12 30                      
2604 224449 1 52 1201 San Jose Ave 62 Front Yard : Yard Tree 2     22     6004503.55801 2096138.79869 37.7358529500558 -122.426877907491 (37.7358529500558, -122.426877907491) 2 7 5 28861 2
2633 261854 1 52 1900x Bay Shore Blvd 12 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
2649 20050 1 52 100 STAIRWAY52 6 Sidewalk: Curb side : Cutout Tree 1     12 10                      
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
3070 52712 7 52 53@ FAIR AVE Coleridge St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/31/2006 12:00:00 AM     Permit Number 48768 6006913.27477728 2099421.81000315 37.7450033243522 -122.418779304454 (37.7450033243522, -122.418779304454) 2 7 7 28859 2
3174 224198 1 52 1001 San Jose Ave 30 Front Yard : Yard Tree 2     9     6005259.16763 2097058.51402 37.7384209767501 -122.424330858406 (37.7384209767501, -122.424330858406) 2 7 5 28859 2
3196 19917 1 52 100 STAIRWAY35 13 Sidewalk: Curb side : Cutout Tree 1     6 120ST                      
3480 40261 7 52 3543 24th St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/16/2005 12:00:00 AM     Permit Number 47928 6005992.45992589 2101968.12777251 37.7519430420387 -122.422144186794 (37.7519430420387, -122.422144186794) 2 4 5 28859 19
3489 244479 1 52 124 Lily St 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 0ft   6005906.1302 2110197.2252 37.7745333330343 -122.423027565946 (37.7745333330343, -122.423027565946) 7 9 11 28852 10
3527 19876 1 52 100 STAIRWAY33 8 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
3552 19877 1 52 100 STAIRWAY33 9 Sidewalk: Curb side : Cutout Tree 1     24 25ST                      
3737 51577 1 52 584 43rd Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF   28   Permit Number 47871 5982583.51771 2111812.9357 37.7776259284617 -122.50382336032 (37.7776259284617, -122.50382336032) 11 6 2 55 26
3823 121262 1 52 505 Grove St 1 Sidewalk: Curb side : Cutout Tree 2     18 3x3   6005321 2111256 37.7774074352434 -122.42512699851 (37.7774074352434, -122.42512699851) 7 9 11 28852 10
3992 9289 1 52 13X George Ct 6 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6017208.5497632 2094048.0250587 37.7308222832509 -122.382805848563 (37.7308222832509, -122.382805848563) 10 3 8 58 1
4099 19572 1 52 100 STAIRWAY1 6 Sidewalk: Curb side : Cutout Tree 1     24 100ST                      
4115 19918 1 52 100 STAIRWAY35 14 Sidewalk: Curb side : Cutout Tree 1     6 120ST                      
4220 11355 1 52 1339 Ingalls St 4 Sidewalk: Curb side : Cutout Tree 1     70 3X3   6017292.9099838 2093920.0801467 37.7304756321775 -122.382505299944 (37.7304756321775, -122.382505299944) 10 3 8 58 1
4242 19575 1 52 100 STAIRWAY1 10 Sidewalk: Curb side : Cutout Tree 1     36 100ST                      
4705 19622 1 52 100 STAIRWAY5 21 Sidewalk: Curb side : Cutout Tree 1     12 30                      
4768 17628 1 52 150 Phelps St 1 Sidewalk: Curb side : Cutout Tree 1     12 10M                      
4835 261613 1 52 1900x Bay Shore Blvd 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
4870 19873 1 52 100 STAIRWAY33 5 Sidewalk: Curb side : Cutout Tree 1     30 25ST                      
4933 261616 1 52 1900x Bay Shore Blvd 9 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
4982 62308 7 52 930@ Lorraine Ct Anza St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/11/1985 12:00:00 AM     Permit Number 22446 5996162.7133263 2112267.41531283 37.77966290152 -122.456881494589 (37.77966290152, -122.456881494589) 11 6 2 54 16
5213 84938 6 52 145 Guerrero St 1 Front Yard : Yard Tree 2         Permit Number 49347 6005480 2108218 37.7690748022624 -122.42436083172 (37.7690748022624, -122.42436083172) 8 4 5 28853 19
5641 19822 1 52 100 STAIRWAY25 6 Sidewalk: Curb side : Cutout Tree 1     6 10ST                      
5768 87061 7 52     unknown : Yard Tree 2       3x3 Permit Number 50003                    
5847 261615 1 52 1900x Bay Shore Blvd 8 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
5870 11357 1 52 1350X Ingalls St 1 Sidewalk: Curb side : Cutout Tree 1     70 3X3   6017253.696644 2093959.2156364 37.7305809242894 -122.382643589629 (37.7305809242894, -122.382643589629) 10 3 8 58 1
6428 19770 1 52 100 STAIRWAY16 9 Sidewalk: Curb side : Cutout Tree 1     6 30ST                      
6505 261618 4 52 1900x Bay Shore Blvd 11 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
6890 19879 1 52 100 STAIRWAY33 11 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
7211 19619 1 52 100 STAIRWAY5 18 Sidewalk: Curb side : Cutout Tree 1     12 30                      
7246 264704 1 52 95 Middle Point Rd 37 Front Yard : Cutout Tree 2       3x3   6018242 2095673 37.7353411892906 -122.379345838246 (37.7353411892906, -122.379345838246) 10 3 8 58 1
7383 17629 1 52 150 Phelps St 2 Sidewalk: Curb side : Cutout Tree 1     12 10M                      
7446 243531 1 52 2095 Harrison St 3 Sidewalk: Curb side : Cutout Tree 2     0 3x3   6008748.77289 2106455.16153 37.764418495754 -122.412929646495 (37.764418495754, -122.412929646495) 8 4 7 28859 19
7681 19824 1 52 100 STAIRWAY25 8 Sidewalk: Curb side : Cutout Tree 1     6 10ST                      
8240 20391 1 52 262X Sunset Blvd 37 Sidewalk: Curb side : Cutout Tree 1     12 60                      
8446 19823 1 52 100 STAIRWAY25 7 Sidewalk: Curb side : Cutout Tree 1     6 10ST                      
8556 19623 1 52 100 STAIRWAY5 22 Sidewalk: Curb side : Cutout Tree 1     12 30                      
8624 52193 1 52 2050x Buchanan St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   14   Permit Number 48383 6003893.10220549 2115458.97047215 37.7888669751572 -122.430366510079 (37.7888669751572, -122.430366510079) 13 9 11 29490 27
8705 224209 1 52 1001 San Jose Ave 70 Front Yard : Yard Tree 2     20     6005356.45271 2097454.81484 37.7395146225008 -122.424022667913 (37.7395146225008, -122.424022667913) 2 7 5 28859 2
8778 19630 1 52 100 STAIRWAY5 29 Sidewalk: Curb side : Cutout Tree 1     12 30                      
9166 19571 1 52 100 STAIRWAY1 5 Sidewalk: Curb side : Cutout Tree 1     24 100ST                      
9314 19995 1 52 100 STAIRWAY46 15 Sidewalk: Curb side : Cutout Tree 1     12 40                      
9456 19881 1 52 100 STAIRWAY33 13 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
9686 19629 1 52 100 STAIRWAY5 28 Sidewalk: Curb side : Cutout Tree 1     6 30                      
9690 19636 1 52 100 STAIRWAY5 35 Sidewalk: Curb side : Cutout Tree 1     12 30                      
9767 19990 1 52 100 STAIRWAY46 10 Sidewalk: Curb side : Cutout Tree 1     6 40                      
9982 261614 1 52 1900x Bay Shore Blvd 7 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
10139 19618 1 52 100 STAIRWAY5 17 Sidewalk: Curb side : Cutout Tree 1     6 30                      
10150 19701 1 52 100 STAIRWAY12 1 Sidewalk: Curb side : Cutout Tree 1     12 60                      
10734 20046 1 52 100 STAIRWAY52 2 Sidewalk: Curb side : Cutout Tree 1     3 10                      
11237 19870 1 52 100 STAIRWAY33 2 Sidewalk: Curb side : Cutout Tree 1     36 25ST                      
11530 261611 1 52 1900x Bay Shore Blvd 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
11589 19641 1 52 100 STAIRWAY5 40 Sidewalk: Curb side : Cutout Tree 1     12 30                      
11997 20028 1 52 100 STAIRWAY49 1 Sidewalk: Curb side : Cutout Tree 1     12 10                      
12194 261567 4 52 1299 Wisconsin St 12 Sidewalk: Property side : Yard Tree 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
12219 19617 1 52 100 STAIRWAY5 16 Sidewalk: Curb side : Cutout Tree 1     6 30                      
12413 19734 1 52 100 STAIRWAY14 12 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
12534 19640 1 52 100 STAIRWAY5 39 Sidewalk: Curb side : Cutout Tree 1     6 30                      
12925 122943 1 52 300 09th Ave 2 Sidewalk: Curb side : Cutout Tree 2     29 Width 3ft   5993094 2113125 37.7818409059319 -122.467559795372 (37.7818409059319, -122.467559795372) 11 6 2 54 11
13069 19574 1 52 100 STAIRWAY1 8 Sidewalk: Curb side : Cutout Tree 1     12 100ST                      
13619 19639 1 52 100 STAIRWAY5 38 Sidewalk: Curb side : Cutout Tree 1     6 30                      
13651 19987 1 52 100 STAIRWAY46 7 Sidewalk: Curb side : Cutout Tree 1     6 40                      
13854 9287 1 52 13X George Ct 4 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6017208.5497632 2094048.0250587 37.7308222832509 -122.382805848563 (37.7308222832509, -122.382805848563) 10 3 8 58 1
13892 19884 1 52 100 STAIRWAY33 16 Sidewalk: Curb side : Cutout Tree 1     18 25ST                      
14136 112391 6 52 2201X LYON ST 2 Sidewalk: Property side : Cutout Tree 2       3x12   5999307 2116423 37.7912531030346 -122.446303107227 (37.7912531030346, -122.446303107227) 13 6 1 29490 31
14460 261617 4 52 1900x Bay Shore Blvd 10 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
15245 19996 1 52 100 STAIRWAY46 16 Sidewalk: Curb side : Cutout Tree 1     12 40                      
15612 19626 1 52 100 STAIRWAY5 25 Sidewalk: Curb side : Cutout Tree 1     12 30                      
15637 19921 1 52 100 STAIRWAY37 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3                      
15654 19916 1 52 100 STAIRWAY35 12 Sidewalk: Curb side : Cutout Tree 1     6 120ST                      
16165 19703 1 52 100 STAIRWAY13 1 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
16570 19635 1 52 100 STAIRWAY5 34 Sidewalk: Curb side : Cutout Tree 1     12 30                      
16689 19767 1 52 100 STAIRWAY16 6 Sidewalk: Curb side : Cutout Tree 1     12 30ST                      
16816 19567 1 52 100 STAIRWAY1 1 Sidewalk: Curb side : Cutout Tree 1     24 100ST                      
16913 34491 7 52 1723 Alabama St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38214 6009344.79247114 2099429.66611089 37.7451615013423 -122.410372074504 (37.7451615013423, -122.410372074504) 2 7 7 28859 2
16933 176313 1 52 500x Mansell St 18 Median : Cutout Tree 1     38 Width 0ft   6010259.13784 2090270.57035 37.7200637812891 -122.406565108408 (37.7200637812891, -122.406565108408) 10 7 8 309 28
16957 261853 1 52 1900x Bay Shore Blvd 13 Sidewalk: Curb side : Cutout Tree 1       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
17526 19573 1 52 100 STAIRWAY1 7 Sidewalk: Curb side : Cutout Tree 1     12 100ST                      
18106 25447 1 52 1261X La Salle Ave 15 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6017141.6501925 2094501.7221284 37.732064349457 -122.383068698568 (37.732064349457, -122.383068698568) 10 3 8 58 1
18183 261610 1 52 1900x Bay Shore Blvd 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
18251 19765 1 52 100 STAIRWAY16 4 Sidewalk: Curb side : Cutout Tree 1     12 30ST                      
18337 113889 4 52 1x STORRIE ST 2 Sidewalk: Property side : Yard Tree 1     90     6000722 2105303 37.7608011093363 -122.440609317727 (37.7608011093363, -122.440609317727) 15 4 5 28862 3
18515 12492 7 52 307 Lake Merced Blvd 37 Sidewalk: Curb side : Cutout Tree 8     36 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
19028 17266 1 52 40 Osceola Dr 1 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6017197.5430923 2094354.669125 37.7316636592684 -122.382865232677 (37.7316636592684, -122.382865232677) 10 3 8 58 1
19364 10993 1 52 1514 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6016151.5025 2097133.86056 37.7392369091669 -122.386675366572 (37.7392369091669, -122.386675366572) 10 3 8 58 1
19379 261609 1 52 1900x Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1