trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
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                      
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                      
2649 20050 1 52 100 STAIRWAY52 6 Sidewalk: Curb side : Cutout Tree 1     12 10                      
3196 19917 1 52 100 STAIRWAY35 13 Sidewalk: Curb side : Cutout Tree 1     6 120ST                      
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                      
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                      
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                      
4870 19873 1 52 100 STAIRWAY33 5 Sidewalk: Curb side : Cutout Tree 1     30 25ST                      
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                    
6428 19770 1 52 100 STAIRWAY16 9 Sidewalk: Curb side : Cutout Tree 1     6 30ST                      
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                      
7383 17629 1 52 150 Phelps St 2 Sidewalk: Curb side : Cutout Tree 1     12 10M                      
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                      
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                      
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                      
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                      
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                      
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                      
13892 19884 1 52 100 STAIRWAY33 16 Sidewalk: Curb side : Cutout Tree 1     18 25ST                      
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                      
17526 19573 1 52 100 STAIRWAY1 7 Sidewalk: Curb side : Cutout Tree 1     12 100ST                      
18251 19765 1 52 100 STAIRWAY16 4 Sidewalk: Curb side : Cutout Tree 1     12 30ST                      
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
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
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
31523 98952 6 52 302 Ivy St 18 Front Yard : Yard Tree 2           6005888.5 2111234.3 37.7773798943726 -122.42316228433 (37.7773798943726, -122.42316228433) 7 9 11 28852 10
35379 254803 4 52 525 Hayes St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6005345 2110923 37.7764944541895 -122.425020275756 (37.7764944541895, -122.425020275756) 7 9 11 28852 10
38428 58101 7 52 535 Buchanan St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/15/1990 12:00:00 AM     Permit Number 29160 6004548.41463352 2110369.10321649 37.774928559979 -122.427736418344 (37.774928559979, -122.427736418344) 7 9 11 28852 10
42746 87674 7 52 770 Golden Gate Ave 10 Front Yard : Cutout Tree 2   05/22/2008 12:00:00 AM   3x3 Permit Number 50396 6005860.1 2112469.5 37.7807698496384 -122.423348359154 (37.7807698496384, -122.423348359154) 7 9 11 28852 41
70602 142225 1 52 641 HAYES ST 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 0ft   6004777.6628 2110866.818 37.7763081284007 -122.426978855787 (37.7763081284007, -122.426978855787) 7 9 11 28852 10
77919 32699 7 52 665 Geary St 3 Sidewalk: Curb side : Cutout Tree 2 FUF 10/29/1996 12:00:00 AM     Permit Number 37104 6008544.39382175 2114510.13304212 37.7865240684083 -122.414206472781 (37.7865240684083, -122.414206472781) 5 1 9 28852 36
137140 112418 1 52 268X Lily St 1 Sidewalk: Curb side : Cutout Tree 2       2.5x3   6005334.87738 2110100.0463 37.7742342515583 -122.424996726643 (37.7742342515583, -122.424996726643) 7 9 11 28852 10
140823 98951 6 52 401 Grove St 11 Front Yard : Yard Tree 2           6005778.2 2111279 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313) 7 9 11 28852 10
146575 122380 1 52 557 Grove St 1 Sidewalk: Curb side : Cutout Tree 2     18 3x3   6005149 2111246 37.777370259808 -122.425721291473 (37.777370259808, -122.425721291473) 7 9 11 28852 10
150229 87675 7 52 770 Golden Gate Ave 11 Front Yard : Cutout Tree 2   05/22/2008 12:00:00 AM   3x3 Permit Number 50396 6005860.1 2112469.5 37.7807698496384 -122.423348359154 (37.7807698496384, -122.423348359154) 7 9 11 28852 41
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
44857 6104 1 52 500X 08th St 6 Median : Cutout Tree 1     12 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
48855 6103 1 52 500X 08th St 5 Median : Cutout Tree 1     3 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
66384 66803 7 52 42 Woodward St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/20/1991 12:00:00 AM     Permit Number 30083 6006463.70585844 2108242.90937755 37.76919869647 -122.420960014682 (37.76919869647, -122.420960014682) 8 4 7 28853 19
82519 6106 1 52 500X 08th St 8 Median : Cutout Tree 1     18 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
83538 6101 1 52 500X 08th St 3 Median : Cutout Tree 1     3 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
92481 32999 7 52 666 Folsom St 8 Sidewalk: Curb side : Cutout Tree 2 FUF 11/01/1996 12:00:00 AM     Permit Number 37299 6013145.25876593 2113656.86996444 37.7844385625752 -122.39822862272 (37.7844385625752, -122.39822862272) 6 2 9 28853 6
108995 6102 1 52 500X 08th St 4 Sidewalk: Property side : Cutout Tree 1     6 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
140238 6100 1 52 500X 08th St 2 Median : Cutout Tree 1     24 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
152575 6105 1 52 500X 08th St 7 Sidewalk: Property side : Cutout Tree 1     3 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
180688 32992 7 52 666 Folsom St 9 Sidewalk: Curb side : Cutout Tree 2 FUF 11/01/1996 12:00:00 AM     Permit Number 37299 6013145.25876593 2113656.86996444 37.7844385625752 -122.39822862272 (37.7844385625752, -122.39822862272) 6 2 9 28853 6
181750 6099 6 52 500X 08th St 1 Sidewalk: Property side : Cutout Tree 2     18 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
184426 32990 7 52 666 Folsom St 11 Sidewalk: Curb side : Cutout Tree 2 FUF 11/01/1996 12:00:00 AM     Permit Number 37299 6013145.25876593 2113656.86996444 37.7844385625752 -122.39822862272 (37.7844385625752, -122.39822862272) 6 2 9 28853 6
186774 32991 7 52 666 Folsom St 10 Sidewalk: Curb side : Cutout Tree 2 FUF 11/01/1996 12:00:00 AM     Permit Number 37299 6013145.25876593 2113656.86996444 37.7844385625752 -122.39822862272 (37.7844385625752, -122.39822862272) 6 2 9 28853 6
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
53177 191717 1 52 554 Rhode Island St 1 : Tree 2     13 Width 6ft   6011757.49983 2105782.3491 37.762739532526 -122.402475918038 (37.762739532526, -122.402475918038) 8 3 8 28856 29
84713 116639 1 52 2100 20th St 4 Sidewalk: Curb side : Cutout Tree 2   06/13/2016 12:00:00 AM 3 3x3   6011723.51737 2104681.28704 37.7597143642338 -122.402516023304 (37.7597143642338, -122.402516023304) 10 3 8 28856 29
85125 101217 7 52 444 De Haro St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6011994.2 2106304.5 37.7641864535036 -122.401693953948 (37.7641864535036, -122.401693953948) 8 3 8 28856 29
85215 104424 1 52 917 Rhode Island St 2 Sidewalk: Curb side : Cutout Tree 2     12 3x3   6011907.00978 2104135.17777 37.7582251112167 -122.401843021952 (37.7582251112167, -122.401843021952) 10 3 8 28856 29
158313 30787 7 52 488 Bryant St 1 Sidewalk: Curb side : Cutout Tree 2   01/31/1995 12:00:00 AM   3x3 Permit Number 51964 6013865.01842582 2112595.14259648 37.7815633679001 -122.395664068446 (37.7815633679001, -122.395664068446) 6 2 9 28856 6
160280 191716 1 52 561 Rhode Island St 1 : Tree 2     15 Width 3ft   6011818.5901 2105765.65198 37.7626970962079 -122.402263453208 (37.7626970962079, -122.402263453208) 8 3 8 28856 29
192906 61359 7 52 1234 Washington St 1 Sidewalk: Curb side : Cutout Tree 2   01/12/2016 12:00:00 AM   3x3 Permit Number 21268 6008775.22346441 2117343.22168335 37.7943160027564 -122.413608310086 (37.7943160027564, -122.413608310086) 5 1 10 28857 21
40971 23414 1 52 1800X VAN NESS AVE 2 Median : Cutout Tree 1     30 9   6006192 2116736 37.7925033310543 -122.422503407712 (37.7925033310543, -122.422503407712) 13 9 10 28858 32
46714 9895 1 52 1800X Pine St 1 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6005051.0377 2115464.4068 37.7889474242075 -122.426360597873 (37.7889474242075, -122.426360597873) 13 9 1 28858 27
65566 32711 7 52 920 Larkin St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/01/2002 12:00:00 AM     Permit Number 44986 6007431.49416975 2114487.39461752 37.7863990597284 -122.418055227286 (37.7863990597284, -122.418055227286) 13 9 9 28858 36
124647 6173 1 52 1075 Ellis St 8 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6005893.15301 2113273.27935 37.782978696051 -122.423291166859 (37.782978696051, -122.423291166859) 7 9 11 28858 41
146550 32724 7 52 1082 Post St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 10/29/1996 12:00:00 AM     Permit Number 37114 6006978.17320306 2114692.47231461 37.7869366280698 -122.419638162258 (37.7869366280698, -122.419638162258) 13 9 10 28858 21
184342 139748 1 52 1330 Laguna St 5 Sidewalk: Curb side : Cutout Tree 2     20 Width 0ft   6004640.4611 2113601.4606 37.7838090228042 -122.427648355277 (37.7838090228042, -122.427648355277) 7 9 11 28858 41
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
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
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
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