trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
79 121399 1 28 349X Cargo Way 1 Sidewalk: Curb side : Cutout Tree 1                              
100 255131 1 28 401X Brotherhood Way 9 Sidewalk: Property side : Yard Tree 1                              
1723 19755 1 28 100 STAIRWAY15 13 Sidewalk: Curb side : Cutout Tree 1     6 3X3                      
1845 20002 1 28 100 STAIRWAY46 22 Sidewalk: Curb side : Cutout Tree 1     6 2                      
2868 255125 1 28 401X Brotherhood Way 3 Sidewalk: Property side : Yard Tree 1                              
3319 255128 1 28 401X Brotherhood Way 6 Sidewalk: Property side : Yard Tree 1                              
3449 19754 1 28 100 STAIRWAY15 12 Sidewalk: Curb side : Cutout Tree 1     6 3X3                      
4083 19998 1 28 100 STAIRWAY46 18 Sidewalk: Curb side : Cutout Tree 1     12 40                      
5059 255129 1 28 401X Brotherhood Way 7 Sidewalk: Property side : Yard Tree 1                              
5129 255126 1 28 401X Brotherhood Way 4 Sidewalk: Property side : Yard Tree 1                              
5510 104813 6 28 1601X Portola Dr 5 Front Yard : Yard Tree 2                              
6473 48743 7 28   1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
7374 48751 7 28   9 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
8604 48746 7 28   4 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
8612 255133 1 28 401X Brotherhood Way 11 Sidewalk: Property side : Yard Tree 1                              
8893 50823 7 28   2 Sidewalk: Curb side : Cutout Tree 2   03/19/2004 12:00:00 AM     Permit Number 47344                    
9839 48748 7 28   6 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
10173 48744 7 28   2 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
10238 255130 1 28 401X Brotherhood Way 8 Sidewalk: Property side : Yard Tree 1                              
10360 30354 7 28   1 Sidewalk: Curb side : Cutout Tree 2   02/17/1956 12:00:00 AM     Permit Number 43                    
10635 255127 1 28 401X Brotherhood Way 5 Sidewalk: Property side : Yard Tree 1                              
11935 50824 7 28   1 Sidewalk: Curb side : Cutout Tree 2   03/19/2004 12:00:00 AM     Permit Number 47344                    
12040 48742 7 28   10 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
12785 48747 7 28   5 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
12883 255123 1 28 401X Brotherhood Way 1 Sidewalk: Property side : Yard Tree 1                              
15071 48749 7 28   7 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
15641 48745 7 28   3 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
17595 255124 1 28 401X Brotherhood Way 2 Sidewalk: Property side : Yard Tree 1                              
18540 48750 7 28   8 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
19147 255132 1 28 401X Brotherhood Way 10 Sidewalk: Property side : Yard Tree 1                              
2152 33675 1 28 469 Ivy St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/03/1996 12:00:00 AM 13   Permit Number 37757 6005116.23557125 2111084.96150687 37.7769262359606 -122.425823168919 (37.7769262359606, -122.425823168919) 7 9 11 28852 10
8782 22575 1 28 799X Turk St 3 Sidewalk: Curb side : Cutout Tree 2     18 4X4   6006314.95978 2112814.99848 37.7817441651975 -122.421799324385 (37.7817441651975, -122.421799324385) 7 9 11 28852 41
11636 249410 4 28 698 Polk St 1 : Tree 2     17 Width 3ft   6007114.55441 2113257.76141 37.7830049436594 -122.419064511231 (37.7830049436594, -122.419064511231) 7 9 9 28852 36
11714 24315 1 28 600X Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6006566.61253 2112551.64159 37.7810352395317 -122.420910018978 (37.7810352395317, -122.420910018978) 7 9 11 28852 41
20912 24331 1 28 601X Golden Gate Ave 7 Sidewalk: Curb side : Cutout Tree 1     18     6006691.6523257 2112520.4868544 37.7809567435024 -122.420475231256 (37.7809567435024, -122.420475231256) 7 9 9 28852 36
21249 112640 4 28 299X STOCKTON ST 1 Sidewalk: Curb side : Cutout Tree 2     15 6x9   6010693 2115178 37.7884783251045 -122.406819877074 (37.7884783251045, -122.406819877074) 5 1 10 28852 6
25658 7812 1 28 700X Franklin St 5 Sidewalk: Curb side : Cutout Tree 1     18 4X4   6006212.78826 2112695.72596 37.7814109097272 -122.422144314234 (37.7814109097272, -122.422144314234) 7 9 11 28852 41
27004 141435 1 28 511 HAYES ST 5 Sidewalk: Curb side : Cutout Tree 2     12 Width 0ft   6005366.2195 2110950.1956 37.776570325295 -122.424948806725 (37.776570325295, -122.424948806725) 7 9 11 28852 10
28479 126251 1 28 100 Elm St 3 Sidewalk: Curb side : Cutout Tree 2     21 Width 4ft   6007028.01622 2112773.92137 37.7816715629397 -122.419329563908 (37.7816715629397, -122.419329563908) 7 9 9 28852 36
28914 24330 1 28 601X Golden Gate Ave 6 Sidewalk: Curb side : Cutout Tree 1     18     6006691.6523257 2112520.4868544 37.7809567435024 -122.420475231256 (37.7809567435024, -122.420475231256) 7 9 9 28852 36
28970 7813 1 28 700X Franklin St 6 Sidewalk: Curb side : Cutout Tree 2     18 4X4   6006213.15076 2112713.37247 37.7814593831787 -122.422144314209 (37.7814593831787, -122.422144314209) 7 9 11 28852 41
29063 22577 1 28 799X Turk St 5 Sidewalk: Curb side : Cutout Tree 2     18 4X4   6006373.00538 2112825.19303 37.7817754301315 -122.421599237822 (37.7817754301315, -122.421599237822) 7 9 11 28852 41
29506 33680 1 28 419 Ivy St 1 Sidewalk: Curb side : Cutout Tree 2   12/03/1996 12:00:00 AM 13   Permit Number 37760 6005344.46198727 2111116.85391927 37.7770266994083 -122.425035932953 (37.7770266994083, -122.425035932953) 7 9 11 28852 10
30511 103595 7 28 10X Hermann St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
31160 7815 1 28 700X Franklin St 8 Sidewalk: Curb side : Cutout Tree 1     18 4X4   6006205.55902 2112775.31728 37.781629040289 -122.422174980189 (37.781629040289, -122.422174980189) 7 9 11 28852 41
31425 103598 7 28 10X Hermann St 7 Sidewalk: Curb side : Cutout Tree 2       3x3   6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
32098 23170 1 28 202X Van Ness Ave 2 Median : Cutout Tree 1     30 9   6006871.78386 2111296.65749 37.7776065535391 -122.419765202716 (37.7776065535391, -122.419765202716) 7 9 9 28852 36
35935 24314 1 28 600X Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6006601.99404 2112547.97273 37.7810271600142 -122.420787355977 (37.7810271600142, -122.420787355977) 7 9 11 28852 41
42257 115376 4 28 500 BUCHANAN ST 1 Sidewalk: Curb side : Cutout Tree 2       4x4   6004637 2110246 37.7745955592359 -122.427421211008 (37.7745955592359, -122.427421211008) 7 9 11 28852 10
42309 24332 1 28 600X Golden Gate Ave 8 Sidewalk: Curb side : Cutout Tree 1   01/22/1999 12:00:00 AM 9     6006393.27479 2112527.98365 37.7809605085733 -122.421508000714 (37.7809605085733, -122.421508000714) 7 9 11 28852 41
42596 103592 7 28 10X Hermann St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
44167 141431 1 28 501 HAYES ST 1 Sidewalk: Curb side : Cutout Tree 2   10/26/2005 12:00:00 AM 17 Width 0ft Permit Number 48304 6005404.7905 2110954.8993 37.7765854191309 -122.424815713066 (37.7765854191309, -122.424815713066) 7 9 11 28852 10
44305 126250 1 28 611 Golden Gate Ave 3 Sidewalk: Curb side : Cutout Tree 2     10 Width 4ft   6006607.01339 2112503.55173 37.7809054736589 -122.420766837016 (37.7809054736589, -122.420766837016) 7 9 11 28852 41
47322 248672 1 28 97 Hermann St 4 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6004845.3119 2108840.52494 37.7707482453776 -122.426600516098 (37.7707482453776, -122.426600516098) 7 9 5 28852 10
47482 22584 1 28 799X Turk St 12 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6006566.74341 2112845.87169 37.7818431310978 -122.420930462379 (37.7818431310978, -122.420930462379) 7 9 11 28852 41
50941 24317 1 28 600X Golden Gate Ave 4 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6006479.1525 2112537.25416 37.7809908049215 -122.421211565287 (37.7809908049215, -122.421211565287) 7 9 11 28852 41
54643 258523 1 28 50 Hermann St 11 Sidewalk: Curb side : Cutout Tree 2 FUF         6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
54789 126249 1 28 611 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 4ft   6006560.14321 2112498.86101 37.7808899522457 -122.420928651146 (37.7808899522457, -122.420928651146) 7 9 11 28852 41
55548 248673 1 28 95 Hermann St 1 Sidewalk: Curb side : Cutout Tree 2     24 Width 3ft   6005207.14412 2108888.77574 37.7709011795763 -122.425352365033 (37.7709011795763, -122.425352365033) 7 9 5 28852 10
56021 24324 1 28 600X Golden Gate Ave 11 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6006305.76929 2112511.39113 37.7809100152295 -122.421809546989 (37.7809100152295, -122.421809546989) 7 9 11 28852 41
56140 248668 1 28 500 Buchanan St 1 Sidewalk: Curb side : Cutout Tree 2     28 Width 4ft   6004619.27289 2110222.43512 37.7745298532048 -122.427480853466 (37.7745298532048, -122.427480853466) 7 9 11 28852 10
57896 24322 7 28 600X Golden Gate Ave 9 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6006352.81998 2112520.5015 37.7809376833117 -122.421647422525 (37.7809376833117, -122.421647422525) 7 9 11 28852 41
60934 258521 1 28 50 Hermann St 9 Sidewalk: Curb side : Cutout Tree 2 FUF         6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
62274 258513 1 28 50 Hermann St 1 Sidewalk: Curb side : Cutout Tree 2 FUF         6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
64623 141433 1 28 511 HAYES ST 3 Sidewalk: Curb side : Cutout Tree 2     12 Width 0ft   6005339.4079 2110947.8437 37.7765623530515 -122.425041388509 (37.7765623530515, -122.425041388509) 7 9 11 28852 10
65764 103594 7 28 10X Hermann St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
70820 138840 1 28 451 IVY ST 3 Sidewalk: Curb side : Cutout Tree 2     16 Width 0ft   6005172.3876 2111107.6921 37.7769918216657 -122.425630539914 (37.7769918216657, -122.425630539914) 7 9 11 28852 10
71025 126240 1 28 700 Van Ness Ave 1 Sidewalk: Curb side : Yard Tree 2     18 Width 4ft   6006641.75911 2112973.79327 37.7821986007353 -122.42068002636 (37.7821986007353, -122.42068002636) 7 9 9 28852 36
73622 24333 1 28 601X Golden Gate Ave 9 Sidewalk: Curb side : Cutout Tree 1     18     6006691.6523257 2112520.4868544 37.7809567435024 -122.420475231256 (37.7809567435024, -122.420475231256) 7 9 9 28852 36
73970 23177 1 28 300X Van Ness Ave 2 Median : Cutout Tree 1     30 9   6006874.5373229 2111536.5864673 37.778265495762 -122.419772706207 (37.778265495762, -122.419772706207) 7 9 9 28852 36
74481 66033 7 28 176 Page St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/28/1990 12:00:00 AM 18 5x5 Permit Number 29070 6005715.54101004 2110005.55330132 37.7739962917294 -122.423673221036 (37.7739962917294, -122.423673221036) 7 9 11 28852 10
78660 126245 1 28 679 Golden Gate Ave 4 Sidewalk: Curb side : Cutout Tree 2     14 Width 4ft   6006341.80281 2112471.00109 37.7808011460043 -122.421682019523 (37.7808011460043, -122.421682019523) 7 9 11 28852 41
79926 52113 7 28 501 Hayes St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/26/2005 12:00:00 AM   4x4 Permit Number 48304 6005450.41519372 2110958.1148217 37.7765968250138 -122.424658112662 (37.7765968250138, -122.424658112662) 7 9 11 28852 10
81117 141436 1 28 511 HAYES ST 6 Sidewalk: Curb side : Cutout Tree 2     20 Width 0ft   6005378.4493 2110951.6067 37.7765748906289 -122.424906600688 (37.7765748906289, -122.424906600688) 7 9 11 28852 10
82924 47042 7 28 50 Webster St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/02/2002 12:00:00 AM   6x9 Permit Number 45032 6004340.5553933 2108752.14114491 37.7704770161634 -122.428340177957 (37.7704770161634, -122.428340177957) 7 9 11 28852 10
83927 117355 1 28 500 Hayes St 3 Sidewalk: Curb side : Cutout Tree 2     15 3x3   6005443.21862963 2111009.61442816 37.7767378239513 -122.424686672119 (37.7767378239513, -122.424686672119) 7 9 11 28852 10
84823 33683 7 28 400 Ivy St 1 Sidewalk: Curb side : Cutout Tree 2   12/03/1996 12:00:00 AM     Permit Number 37762 6005419.42693285 2111179.83479418 37.7772038638652 -122.4247810873 (37.7772038638652, -122.4247810873) 7 9 11 28852 10
87435 248671 1 28 50 Webster St 1 Sidewalk: Curb side : Cutout Tree 2     18 Width 4ft   6004331.06987 2108798.07115 37.7706025920658 -122.428376262559 (37.7706025920658, -122.428376262559) 7 9 11 28852 10
87538 103597 7 28 10X Hermann St 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
92796 244245 1 28 176 Page St 1 Sidewalk: Curb side : Cutout Tree 2     17 Width 0ft   6005740.1233 2110010.337 37.7740108141999 -122.423588526804 (37.7740108141999, -122.423588526804) 7 9 11 28852 10
93162 126243 1 28 679 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree 2     18 Width 4ft   6006291.93692 2112463.21725 37.7807769614403 -122.421853977089 (37.7807769614403, -122.421853977089) 7 9 11 28852 41
95244 22579 1 28 799X Turk St 7 Sidewalk: Curb side : Cutout Tree 2     18 4X4   6006429.75961 2112830.68466 37.7817937088462 -122.421403284548 (37.7817937088462, -122.421403284548) 7 9 11 28852 41
96227 22583 1 28 799X Turk St 11 Sidewalk: Curb side : Cutout Tree 1     18 4X4   6006548.99233 2112844.76483 37.7818390913318 -122.420991794355 (37.7818390913318, -122.420991794355) 7 9 11 28852 41
98369 7809 1 28 700X Franklin St 2 Sidewalk: Curb side : Cutout Tree 2     18 4X4   6006235.14399 2112561.39045 37.7810433181208 -122.422057428004 (37.7810433181208, -122.422057428004) 7 9 11 28852 41
99804 141432 1 28 511 HAYES ST 2 Sidewalk: Curb side : Cutout Tree 2     17 Width 0ft   6005324.8262 2110946.4325 37.7765576545373 -122.425091730432 (37.7765576545373, -122.425091730432) 7 9 11 28852 10
100668 24327 1 28 601X Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6006691.6523257 2112520.4868544 37.7809567435024 -122.420475231256 (37.7809567435024, -122.420475231256) 7 9 9 28852 36
100689 126247 1 28 649 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree 2     17 Width 4ft   6006451.94637 2112482.08949 37.7808378023715 -122.421301766381 (37.7808378023715, -122.421301766381) 7 9 11 28852 41
107918 142012 1 28 749 LAGUNA ST 1 Sidewalk: Curb side : Cutout Tree 2     22 Width 0ft   6004871.6299 2111553.6762 37.7781993856574 -122.426702721407 (37.7781993856574, -122.426702721407) 7 9 11 28852 10
107994 24335 1 28 601X Golden Gate Ave 11 Sidewalk: Curb side : Cutout Tree 1     12     6006691.6523257 2112520.4868544 37.7809567435024 -122.420475231256 (37.7809567435024, -122.420475231256) 7 9 9 28852 36
108047 57553 1 28 601 Hayes St 1 Sidewalk: Curb side : Cutout Tree 2   10/26/1976 12:00:00 AM 18 3x3 Permit Number 16416 6004949.77312 2110889.41028 37.7763798917414 -122.426385087108 (37.7763798917414, -122.426385087108) 7 9 11 28852 10
108348 23178 1 28 300X Van Ness Ave 3 Median : Cutout Tree 1     30 9   6006874.5373229 2111536.5864673 37.778265495762 -122.419772706207 (37.778265495762, -122.419772706207) 7 9 9 28852 36
108400 24320 1 28 600X Golden Gate Ave 7 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6006433.20726 2112530.1062 37.7809685880643 -122.421370005128 (37.7809685880643, -122.421370005128) 7 9 11 28852 41
111613 47011 7 28 190 Hermann St 3 Sidewalk: Curb side : Cutout Tree 2   05/02/2002 12:00:00 AM     Permit Number 45008 6004362.86360721 2108776.26099442 37.7705445057003 -122.428264732992 (37.7705445057003, -122.428264732992) 7 9 11 28852 10
113345 33684 7 28 400 Ivy St 2 Sidewalk: Curb side : Cutout Tree 2   12/03/1996 12:00:00 AM     Permit Number 37762 6005419.42693285 2111179.83479418 37.7772038638652 -122.4247810873 (37.7772038638652, -122.4247810873) 7 9 11 28852 10
113425 248674 1 28 95 Hermann St 6 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   6005037.30148 2108867.21091 37.7708323706535 -122.425938320109 (37.7708323706535, -122.425938320109) 7 9 5 28852 10
118515 138823 1 28 628 IVY ST 1 Sidewalk: Curb side : Cutout Tree 2     33 Width 0ft   6004357.247 2111017.4097 37.7766978348647 -122.428443926863 (37.7766978348647, -122.428443926863) 7 9 11 28852 10
119098 7810 1 28 700X Franklin St 3 Sidewalk: Curb side : Cutout Tree 2     18 3X3   6006241.41357 2112578.91563 37.7810917915932 -122.422036983727 (37.7810917915932, -122.422036983727) 7 9 11 28852 41
123044 22574 1 28 799X Turk St 2 Sidewalk: Curb side : Cutout Tree 2     18 4X4   6006283.90302 2112813.42944 37.7817381055674 -122.421906654863 (37.7817381055674, -122.421906654863) 7 9 11 28852 41
123437 7801 1 28 690X Franklin St 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6006253.103271 2112460.108328 37.7807662350176 -122.421988100815 (37.7807662350176, -122.421988100815) 7 9 11 28852 41
124262 22582 1 28 799X Turk St 9 Sidewalk: Curb side : Cutout Tree 2     18 4X4   6006498.64773 2112839.17836 37.7818209142342 -122.421165566743 (37.7818209142342, -122.421165566743) 7 9 11 28852 41
126093 142248 1 28 603 HAYES ST 1 Sidewalk: Curb side : Cutout Tree 2     17 Width 0ft   6004941.624 2110891.392 37.7763848724075 -122.42641341835 (37.7763848724075, -122.42641341835) 7 9 11 28852 10