trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
154885 116096 6 59 300x EXECUTIVE PARK BLVD 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
156652 104284 6 17 45X Middle Point Rd 1 Front Yard : Yard Tree 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
162063 113132 6 109 1375 FAIRFAX AVE 1 Front Yard : Yard Tree 2           6016814 2097238 37.7395595104895 -122.384391976269 (37.7395595104895, -122.384391976269) 10 3 8 58 1
164393 120551 6 70 1485 Fairfax Ave 1 Front Yard : Yard Tree 2           6016296 2097688 37.7407664622153 -122.386214376382 (37.7407664622153, -122.386214376382) 10 3 8 58 1
170444 116097 6 59 300x EXECUTIVE PARK BLVD 7 Sidewalk: Curb side : Cutout Tree 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
172566 94942 6 364 2525 Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
173631 96998 6 68 2451X Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF         6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
174752 104282 6 17 150X Middle Point Rd 4 Front Yard : Yard Tree 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
175413 96996 6 82 2451X Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF         6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
177168 116092 6 59 300x EXECUTIVE PARK BLVD 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
178439 107539 6 52 198X JENNINGS ST 1 Front Yard : Yard Tree 1           6018784 2097136 37.739388174499 -122.377573417349 (37.739388174499, -122.377573417349) 10 3 8 58 1
179763 94944 6 568 2525 Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
179978 105160 6 28 1600X OAKDALE AVE 1 Front Yard : Yard Tree 19     13   Permit Number 770204 6015006 2095503 37.7346954145828 -122.390522107646 (37.7346954145828, -122.390522107646) 10 3 8 58 1
182512 104287 6 17 119X Middle Point Rd 1 Front Yard : Yard Tree 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
182637 94936 6 504 2525 Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
182689 108589 6 17 1139x HUDSON AVE 1 Sidewalk: Curb side : Yard Tree 2           6017760 2094672 37.7325660477977 -122.380942739781 (37.7325660477977, -122.380942739781) 10 3 8 58 1
185499 94945 6 168 1820X Palou Ave   : Cutout Tree 5 FUF 04/04/2009 12:00:00 AM       6013714.4 2096294.3 37.7367964240349 -122.395043047708 (37.7367964240349, -122.395043047708) 10 3 8 58 1
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
5712 258876 6 70 1326 Hayes St 1 Sidewalk: Curb side : Yard Tree 2       Width 0ft   6001504 2110473 37.7750411502564 -122.438275119801 (37.7750411502564, -122.438275119801) 15 5 11 29492 10
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
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
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
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
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
129276 93903 6 72 546 Page St   Front Yard : Tree 2           6003947 2109752 37.7732001072566 -122.429772814549 (37.7732001072566, -122.429772814549) 7 9 11 29492 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
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
158642 94066 6 273 548 Page St   Front Yard : Tree 2   06/02/2010 12:00:00 AM     Permit Number 53460 6003937 2109751 37.7731967952272 -122.429807334526 (37.7731967952272, -122.429807334526) 7 9 11 29492 10
160060 258238 6 37 200x Gough St 7 Sidewalk: Property side : Cutout Tree 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
161677 105090 6 45 344 Fulton St 10 Front Yard : Yard Tree 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
166073 112419 6 200 268 Lily St 1 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
167444 105083 6 45 344 Fulton St 3 Front Yard : Yard Tree 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
167525 258528 6 27 50 Hermann St 4 Sidewalk: Property side : Cutout Tree 2           6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
170978 108021 6 72 455X Ivy St 1 Front Yard : Cutout Tree 2           6005179.30837 2111099.83336 37.776970634543 -122.42560603936 (37.776970634543, -122.42560603936) 7 9 11 28852 10
172262 103613 6 42 200X Buchanan St 3 Sidewalk: Property side : Yard Tree 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
174521 258525 6 95 50 Hermann St 1 Sidewalk: Property side : Cutout Tree 2           6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
176793 98949 6 342 401 Grove St 9 Front Yard : Yard Tree 2           6005778.2 2111279 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313) 7 9 11 28852 10
182332 258021 6 17 201x Gough St 1 Sidewalk: Property side : Yard Tree 2       3x3   6006013 2110374 37.7750247439455 -122.422670446803 (37.7750247439455, -122.422670446803) 7 9 11 28852 10
182906 103611 6 42 200X Buchanan St 1 Sidewalk: Property side : Yard Tree 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
186789 105088 6 45 344 Fulton St 8 Front Yard : Yard Tree 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
194054 121158 6 11 350x Octavia St 2 Side Yard : Yard Tree 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
19027 260904 6 16 4228 Geary Blvd 1 Sidewalk: Property side : Cutout Tree 2       Width 4ft   5993841 2112866 37.7811728620679 -122.464956727678 (37.7811728620679, -122.464956727678) 11 6 2 54 11
61291 113491 6 43 366x 07TH AVE 1 Sidewalk: Property side : Cutout Tree 2   12/07/2015 12:00:00 AM 6 3x3 Permit Number 776681 5993712 2113143 37.7819259902039 -122.465423128165 (37.7819259902039, -122.465423128165) 11 6 2 54 11
78031 91107 6 17 2650 Turk Blvd 2 Front Yard : Yard Tree 2   01/12/2009 12:00:00 AM   On campus Permit Number 51996 5995208 2110277 37.7741428808777 -122.460040004978 (37.7741428808777, -122.460040004978) 11 6 2 54 11
87883 120156 6 53 758 10th Ave 1 Sidewalk: Curb side : Cutout Landscaping 2     10     5992930 2110298 37.7740692588728 -122.467921468059 (37.7740692588728, -122.467921468059) 11 6 2 54 11
94461 98038 6 17 147 Lake St 1 Front Yard : Yard Tree 2   12/09/2011 12:00:00 AM     Permit Number 768423 5994977.2 2114852.5 37.7866927029397 -122.461170103848 (37.7866927029397, -122.461170103848) 11 6 1 54 11
137332 112057 6 37 762 FUNSTON AVE 2 Sidewalk: Curb side : Cutout Tree 2 FUF   12     5991999 2110277 37.7739577928787 -122.47114039751 (37.7739577928787, -122.47114039751) 11 6 2 54 11
144517 112363 6 233 540 10th Ave 3 Front Yard : Yard Tree 2     24 6x6   5992860.82014 2111778.58973 37.778130563709 -122.468268503132 (37.778130563709, -122.468268503132) 11 6 2 54 11