trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
84 254457 6 43 1055X Duncan St 2 Side Yard : Yard Tree 2                              
394 119605 6 41 299x Avalon Ave 1 Front Yard : Yard Tree 2                              
1051 251262 6 41 3630x 19th Ave 1 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
2100 253677 6 35 199X Kissling St 1 Side Yard : Cutout Tree 2       5x10                      
3171 119608 6 185 299x Avalon Ave 4 Front Yard : Yard Tree 2                              
3182 261252 6 21 100 Collins St 1 Front Yard : Cutout Tree 2   12/18/2019 12:00:00 AM 3                        
4934 103659 6 17 350X Hickory St 3 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
5510 104813 6 28 1601X Portola Dr 5 Front Yard : Yard Tree 2                              
5622 251139 6 17 621X Gough St 1 Back Yard : Yard Tree 2   03/10/2017 12:00:00 AM 3   Permit Number 779685                    
6834 103660 6 17 350X Hickory St 4 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
7039 119606 6 62 299x Avalon Ave 2 Front Yard : Yard Tree 2                              
7389 119599 6 185 4357x Mission St 1 Front Yard : Yard Tree 2         Permit Number 774415                    
7411 103658 6 17 350X Hickory St 2 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
8509 103668 6 17 350X Hickory St 6 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
8535 251265 6 41 3630x 19th Ave 4 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
11338 85030 6 17 411 Panama St 1 Sidewalk: Curb side : Cutout Tree 2   06/26/2007 12:00:00 AM     Permit Number 49384                    
13434 260582 6 33 2101X Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree 2   09/25/2019 12:00:00 AM 3 5x5 Permit Number 782628                    
13805 119600 6 185 4357x Mission St 2 Front Yard : Yard Tree 2         Permit Number 774415                    
14241 251264 6 41 3630x 19th Ave 3 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
14456 103661 6 17 350X Hickory St 5 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
15093 119607 6 15 299x Avalon Ave 3 Front Yard : Yard Tree 2                              
15289 119601 6 185 4357x Mission St 3 Front Yard : Yard Tree 2         Permit Number 774415                    
15795 251263 6 41 3630x 19th Ave 2 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
16207 254459 6 17 1055X Duncan St 4 Side Yard : Yard Tree 2   02/15/2018 12:00:00 AM 3   Permit Number 780800                    
18988 103657 6 17 350X Hickory St 1 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
19367 254458 6 17 1055X Duncan St 3 Side Yard : Yard Tree 2   02/15/2018 12:00:00 AM 3   Permit Number 780800                    
19573 254456 6 113 1055X Duncan St 1 Side Yard : Yard Tree 2                              
127144 258338 6 71 209 Spear St 1 Sidewalk: Property side : Cutout Tree 2                              
194363 265042 6 17 1000X Mandalay Ln 2 Unaccepted Street : Yard Tree 2   12/17/2020 12:00:00 AM 3 10x010 Permit Number 787936                    
803 105089 6 45 344 Fulton St 9 Front Yard : Yard Tree 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
3436 103654 6 17 307X Octavia St 3 Front Yard : Yard Tree 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
4164 260061 6 27 100 Larkin St 8 Sidewalk: Property side : Yard Tree 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
8078 260059 6 27 100 Larkin St 6 Sidewalk: Property side : Yard Tree 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
9215 260060 6 27 100 Larkin St 7 Sidewalk: Property side : Yard Tree 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
12063 95300 6 11 701 Golden Gate Ave   Front Yard : Yard Tree 2   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617 -122.422419858646 (37.780652317617, -122.422419858646) 7 9 11 28852 41
15911 105081 6 45 344 Fulton St 1 Front Yard : Yard Tree 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
17108 105086 6 45 344 Fulton St 6 Front Yard : Yard Tree 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
18171 260058 6 27 100 Larkin St 5 Sidewalk: Property side : Yard Tree 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
22312 116999 6 127 880x MCALLISTER ST 2 Front Yard : Cutout Tree 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41
22976 103600 6 41 50X Hermann St 1 Front Yard : Yard Tree 2           6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
29114 103653 6 17 307X Octavia St 2 Front Yard : Yard Tree 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
30260 114430 6 9 455 EDDY ST 2 Sidewalk: Curb side : Pot Tree 2       3x3   6008254 2113439 37.7835666804498 -122.415135318852 (37.7835666804498, -122.415135318852) 7 10 9 28852 36
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
41224 258232 6 37 200x Gough St 1 Sidewalk: Property side : Cutout Tree 2   04/24/2019 12:00:00 AM 3 3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
43239 258527 6 27 50 Hermann St 3 Sidewalk: Property side : Cutout Tree 2           6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
44345 253366 6 341 20 Laussat St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6004582 2109434 37.7723628942784 -122.427553605007 (37.7723628942784, -122.427553605007) 7 9 11 28852 10
48151 98950 6 95 401 Grove St 10 Front Yard : Yard Tree 2           6005778.2 2111279 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313) 7 9 11 28852 10
53621 258239 6 37 200x Gough St 8 Sidewalk: Property side : Cutout Tree 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
60038 258526 6 15 50 Hermann St 2 Sidewalk: Property side : Cutout Tree 2           6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
60074 98947 6 342 401 Grove St 7 Front Yard : Yard Tree 2           6005778.2 2111279 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313) 7 9 11 28852 10
60332 112420 6 200 268 Lily St 2 Back Yard : Yard Tree 2   07/29/2015 12:00:00 AM 3     6005334.87738 2110100.0463 37.7742342515583 -122.424996726643 (37.7742342515583, -122.424996726643) 7 9 11 28852 10
60900 103616 6 95 201X Haight St 1 Sidewalk: Property side : Yard Tree 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
65723 108022 6 76 455X Ivy St 2 Front Yard : Cutout Tree 2           6005179.30837 2111099.83336 37.776970634543 -122.42560603936 (37.776970634543, -122.42560603936) 7 9 11 28852 10
66091 100771 6 95 450 Hayes St 2 Back Yard : Yard Tree 2         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
67916 258235 6 37 200x Gough St 4 Sidewalk: Property side : Cutout Tree 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
69454 98948 6 95 401 Grove St 8 Front Yard : Yard Tree 2           6005778.2 2111279 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313) 7 9 11 28852 10
71208 98953 6 42 302 Ivy St 19 Front Yard : Yard Tree 2           6005888.5 2111234.3 37.7773798943726 -122.42316228433 (37.7773798943726, -122.42316228433) 7 9 11 28852 10
71526 258236 6 37 200x Gough St 5 Sidewalk: Property side : Cutout Tree 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
74407 121161 6 11 350x Octavia St 5 Side Yard : Yard Tree 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
75459 105084 6 45 344 Fulton St 4 Front Yard : Yard Tree 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
75842 103617 6 36 201X Haight St 2 Sidewalk: Property side : Yard Tree 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
79081 121163 6 11 350x Octavia St 7 Side Yard : Yard Tree 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
80590 98954 6 42 302 Ivy St 20 Front Yard : Yard Tree 2           6005888.5 2111234.3 37.7773798943726 -122.42316228433 (37.7773798943726, -122.42316228433) 7 9 11 28852 10
83376 121162 6 11 350x Octavia St 6 Side Yard : Yard Tree 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
88383 103615 6 42 200X Buchanan St 5 Sidewalk: Property side : Yard Tree 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
91093 105091 6 45 344 Fulton St 11 Front Yard : Yard Tree 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
92359 120121 6 457 444 Page St 1 Front Yard : Yard Tree 2           6004415 2109849 37.7734929358756 -122.428160854421 (37.7734929358756, -122.428160854421) 7 9 11 28852 10
94077 103591 6 113 55X Laguna St 3 Front Yard : Yard Tree 2           6005242.6 2108960.5 37.7711001201992 -122.425234826708 (37.7711001201992, -122.425234826708) 7 9 5 28852 10
95437 103618 6 36 201X Haight St 3 Sidewalk: Property side : Yard Tree 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
96773 92813 6 17 365 Fulton St 2 Sidewalk: Curb side : Cutout Tree 1       3x3 Permit Number 53020 6006011 2111744 37.7787863189721 -122.42277474798 (37.7787863189721, -122.42277474798) 7 9 11 28852 10
99529 103588 6 31 101X Laguna St 1 Front Yard : Yard Tree 2           6005198.60314 2109385.58511 37.772264815602 -122.425417269432 (37.772264815602, -122.425417269432) 7 9 5 28852 10
99672 121159 6 11 350x Octavia St 3 Side Yard : Yard Tree 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
99950 117000 6 127 880x MCALLISTER ST 3 Front Yard : Cutout Tree 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41
100242 106956 6 17 50 Fell St 3 Front Yard : Yard Tree 2     14 10x10   6007226 2110908 37.7765593411304 -122.418512280303 (37.7765593411304, -122.418512280303) 7 9 9 28852 36
100606 100772 6 95 450 Hayes St 3 Back Yard : Yard Tree 2         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
103945 258237 6 37 200x Gough St 6 Sidewalk: Property side : Cutout Tree 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
105893 116998 6 127 880x MCALLISTER ST 1 Front Yard : Cutout Tree 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41
106415 121157 6 11 350x Octavia St 1 Side Yard : Yard Tree 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
108684 103655 6 17 307X Octavia St 4 Front Yard : Yard Tree 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
109250 107818 6 101 474 Oak St 1 Sidewalk: Property side : Cutout Tree 2       3X3   6004715.2 2110227.8 37.7745500089947 -122.427149405032 (37.7745500089947, -122.427149405032) 7 9 11 28852 10
109449 103656 6 17 307X Octavia St 5 Front Yard : Yard Tree 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
110134 103612 6 42 200X Buchanan St 2 Sidewalk: Property side : Yard Tree 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
113506 108002 6 72 461X Ivy St 1 Front Yard : Cutout Tree 2           6005199.36333 2111122.83043 37.7770349120596 -122.425538300101 (37.7770349120596, -122.425538300101) 7 9 11 28852 10
120358 103590 6 113 55X Laguna St 2 Front Yard : Yard Tree 2           6005242.6 2108960.5 37.7711001201992 -122.425234826708 (37.7711001201992, -122.425234826708) 7 9 5 28852 10
120900 258240 6 37 200x Gough St 9 Sidewalk: Property side : Cutout Tree 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
121235 86895 6 17 321 Haight St   Front Yard : Yard Tree 2   10/26/2007 12:00:00 AM     Permit Number 49844 6004599.9 2109420.1 37.7723257406977 -122.427490696784 (37.7723257406977, -122.427490696784) 7 9 11 28852 10
123818 121160 6 11 350x Octavia St 4 Side Yard : Yard Tree 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
125282 110236 6 15 100 BUCHANAN ST 1 Sidewalk: Curb side : Yard Tree 2   05/12/2015 12:00:00 AM 3 3x20   6004868.5 2109011.4 37.7712187378523 -122.426532477218 (37.7712187378523, -122.426532477218) 7 9 5 28852 10
126537 105082 6 45 344 Fulton St 2 Front Yard : Yard Tree 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
138832 258234 6 37 200x Gough St 3 Sidewalk: Property side : Cutout Tree 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 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
144064 103614 6 42 200X Buchanan St 4 Sidewalk: Property side : Yard Tree 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
145102 105085 6 45 344 Fulton St 5 Front Yard : Yard Tree 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
147643 100770 6 95 450 Hayes St 1 Back Yard : Yard Tree 2         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
151632 95299 6 11 701 Golden Gate Ave   Front Yard : Yard Tree 2   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617 -122.422419858646 (37.780652317617, -122.422419858646) 7 9 11 28852 41
152489 103652 6 17 307X Octavia St 1 Front Yard : Yard Tree 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
154153 105087 6 45 344 Fulton St 7 Front Yard : Yard Tree 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
154569 103589 6 113 55X Laguna St 1 Front Yard : Yard Tree 2           6005242.6 2108960.5 37.7711001201992 -122.425234826708 (37.7711001201992, -122.425234826708) 7 9 5 28852 10
155172 258233 6 37 200x Gough St 2 Sidewalk: Property side : Cutout Tree 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
157383 110560 6 27 320x FULTON ST 2 Sidewalk: Property side : Yard Tree 2       10x36   6006080 2112015 37.7795343118474 -122.422555311635 (37.7795343118474, -122.422555311635) 7 9 11 28852 10
157916 110559 6 27 320x FULTON ST 1 Sidewalk: Property side : Yard Tree 2       10x36   6006080 2112015 37.7795343118474 -122.422555311635 (37.7795343118474, -122.422555311635) 7 9 11 28852 10