trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
113165 113482 8 15 2839 Pierce St   Back Yard : Yard Tree 2           6001345 2118077 37.7959107386074 -122.439370308548 (37.7959107386074, -122.439370308548) 13 9 1 57 17
113384 98890 8 17 256 Glenview Dr   Back Yard : Yard Landscaping 2           5999134 2100748 37.7482036421854 -122.44577389345 (37.7482036421854, -122.44577389345) 2 5 5 63 38
113507 253768 8 41 100 Raccoon Dr 1 Back Yard : Yard Tree 2           5998692 2104165 37.7575606372552 -122.447548237739 (37.7575606372552, -122.447548237739) 15 5 5 28862 3
116904 105236 8 41 235X STATES ST 1 Back Yard : Yard Tree 2     30     6001213 2106258 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423) 15 5 5 28862 3
116957 97032 8 242 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
117229 102248 8 9 125X Powhattan Ave 1 Front Yard : Yard Tree 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606 2098071 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
117341 104397 8 285 350 Collingwood St 1 Front Yard : Yard Tree 2           6002086 2103822 37.7568122198273 -122.435785890783 (37.7568122198273, -122.435785890783) 2 4 5 28862 3
120469 96606 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
120621 101625 8 272 64 Levant St 1 Front Yard : Cutout Tree 2         Permit Number 769362 6000275.9 2106473.5 37.7639895997076 -122.442236202383 (37.7639895997076, -122.442236202383) 15 5 5 28862 3
120627 100045 8 111 556 28th St   Front Yard : Yard Tree 2         Not sure which property tree is located on. 6002301 2099461 37.7448501592716 -122.434730501666 (37.7448501592716, -122.434730501666) 2 7 5 63 22
120723 97043 8 186 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
122314 97023 8 50 1443 Alabama St   Sidewalk: Curb side : Cutout Tree 2   08/16/2011 12:00:00 AM     Permit Number 768190 6009347.4 2100788.9 37.7488938036461 -122.410459018192 (37.7488938036461, -122.410459018192) 2 4 7 28859 19
123806 256658 8 15 7014 Fulton St 1 Back Yard : Cutout Tree 2           5981603 2109659 37.7716541501084 -122.507055421099 (37.7716541501084, -122.507055421099) 11 6 2 55 26
124153 118318 8 58 20 Norton St 1 Front Yard : Yard Tree 3           6002015.68632 2092167.12899 37.7248066672809 -122.435195459751 (37.7248066672809, -122.435195459751) 9 7 6 28861 25
124823 98405 8 14 84 Richland Ave   Sidewalk: Curb side : Cutout Tree 2   02/08/2012 12:00:00 AM     Permit Number 768549 6005038.1 2096133 37.735867237922 -122.425029371072 (37.735867237922, -122.425029371072) 2 7 5 28859 2
125967 96999 8 60 195A Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
127263 98715 8 15 26 Vernon St   Back Yard : Yard Tree 2           5992459 2088068 37.713004133171 -122.467933479353 (37.713004133171, -122.467933479353) 9 8 6 64 24
128219 101903 8 72 1100 Ocean Ave 4 Front Yard : Yard Tree 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
128716 108973 8 15 3485X SAN BRUNO AVE 1 Median : Yard Tree 14           6011510 2091910 37.724635221414 -122.402356490066 (37.724635221414, -122.402356490066) 10 3 7 309 28
129765 105353 8 17 1979 SAN JOSE AVE 2 Front Yard : Yard Tree 2   04/16/2014 12:00:00 AM 27   Permit Number 772405 5999886.5 2092393.4 37.7253068164695 -122.442572018552 (37.7253068164695, -122.442572018552) 9 7 6 28861 25
129920 106227 8 56 38 Stanford Heights Ave 1 Back Yard : Yard Tree 2           5997884 2095808.5 37.7345695210024 -122.44974042874 (37.7345695210024, -122.44974042874) 9 7 4 59 40
134592 102469 8 15 1021 Kirkham St 1 Back Yard : Yard Tree 2           5991773 2105198 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129) 1 8 4 56 12
136363 252834 8 230 98 Prosper St 2 Sidewalk: Property side : Cutout Tree 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
136541 96599 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
137033 114410 8 15 10 GARDENSIDE DR   Sidewalk: Curb side : Cutout Tree 2           5999306 2102458 37.7529087049134 -122.445302055175 (37.7529087049134, -122.445302055175) 2 5 5 63 38
137283 109242 8 284 2479 DIAMOND ST   Sidewalk: Curb side : Yard Landscaping 2           6002238.1 2097343.7 37.7390329760373 -122.434796615916 (37.7390329760373, -122.434796615916) 2 7 5 63 7
137488 98501 8 17 232 Glenview Dr   Back Yard : Yard Landscaping 2           5998998 2100740 37.7481739100487 -122.446243600021 (37.7481739100487, -122.446243600021) 2 5 5 63 38
137889 109378 8 59 111 BAY ST 5 Back Yard : Yard Tree 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
138264 96604 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
139843 108680 8 113 240 SANTA ANA AVE 1 Back Yard : Yard Tree 2           5992606.9 2095181.7 37.7325451527527 -122.46793939449 (37.7325451527527, -122.46793939449) 9 8 4 59 40
141124 100244 8 34 71 Sanchez St   Back Yard : Yard Tree 2         Interior courtyard 6003507 2107903 37.7680982797144 -122.431162830878 (37.7680982797144, -122.431162830878) 7 9 5 28862 3
141783 110320 8 45 9 Imperial Aly   Back Yard : Yard Landscaping 2           6005040.9 2119421.8 37.7998128500526 -122.426677597274 (37.7998128500526, -122.426677597274) 13 9 1 57 17
142618 96600 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
144842 101905 8 72 1100 Ocean Ave 6 Front Yard : Yard Tree 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
145479 96592 8 8 450 Church St   Sidewalk: Property side : Cutout Tree 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
145638 105686 8 97 635 08TH ST 3 Front Yard : Pot Tree 2     6     6011418.5 2109097.9 37.7718243537934 -122.403881727597 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
149052 105232 8 15 460X ROOSEVELT WAY 2 Front Yard : Yard Tree 2     17     5999944 2106286 37.7634558498539 -122.443370673769 (37.7634558498539, -122.443370673769) 15 5 5 29492 3
149268 106458 8 17 71 HANCOCK ST   Back Yard : Yard Tree 2           6003861.6 2105050 37.7602847161222 -122.429732794413 (37.7602847161222, -122.429732794413) 2 4 5 28862 3
149518 109194 8 172 4705 03rd St   Back Yard : Yard Tree 19     45     6015121.6 2095617 37.7350148477359 -122.390130397219 (37.7350148477359, -122.390130397219) 10 3 8 58 1
150502 97162 8 82 478 10th Ave   Back Yard : Yard Tree 2         Tree in backyard on private property; not significant. 5992861.5 2112216.7 37.7793335349967 -122.468298031686 (37.7793335349967, -122.468298031686) 11 6 2 54 11
150726 106275 8 56 42 Stanford Heights Ave 1 Back Yard : Yard Tree 2           5997882.5 2095834.4 37.7346405503947 -122.449747480555 (37.7346405503947, -122.449747480555) 9 7 4 59 40
155569 109374 8 59 111 BAY ST 1 Back Yard : Yard Tree 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
155860 96938 8 17 1306 Cole St   Back Yard : Yard Tree 2         Backyard tree on private property 5998246 2105961 37.7624665052811 -122.449220068104 (37.7624665052811, -122.449220068104) 15 5 11 29492 9
156111 96589 8 8 450 Church St   Sidewalk: Property side : Cutout Tree 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
157400 97685 8 41 84 Coventry Ct   Back Yard : Yard Tree 2           5997084 2096485 37.7363812239889 -122.452555087132 (37.7363812239889, -122.452555087132) 9 7 4 59 40
158127 104008 8 15 357 Collingwood St 1 Back Yard : Yard Tree 2     36     6002124 2103789 37.7567237682266 -122.435652112093 (37.7567237682266, -122.435652112093) 2 4 5 28862 3
162706 94228 8 216 1097 Church St   Front Yard : Yard Tree 2   06/25/2010 12:00:00 AM     Permit Number 53567 6004455 2102510 37.7533440588084 -122.427499544702 (37.7533440588084, -122.427499544702) 2 4 5 28862 22
163139 112668 8 15 129 Henry St   Back Yard : Yard Tree 2           6002668 2107340.8 37.7665070360696 -122.434024647923 (37.7665070360696, -122.434024647923) 15 5 5 28862 3
167578 100472 8 15 70 Stanford Heights Ave   Back Yard : Yard Tree 2           5997872.4 2096006.9 37.735113616296 -122.449794826729 (37.735113616296, -122.449794826729) 9 7 4 59 40
168913 114365 8 15 2546 28th Ave 1 Back Yard : Yard Tree 2     35     5987735.7 2097954.4 37.7398757613896 -122.484983441996 (37.7398757613896, -122.484983441996) 1 8 3 29491 35
169065 108625 8 34 100 GENEBERN WAY 1 Front Yard : Yard Tree 2     12     6004991.8 2095242.4 37.7334192343039 -122.425126098693 (37.7334192343039, -122.425126098693) 2 7 7 28861 2
170932 102752 8 155 2452 Green St   Back Yard : Yard Tree 2           6001313 2117994 37.7956810212331 -122.43947508164 (37.7956810212331, -122.43947508164) 13 9 1 57 17
175126 97044 8 186 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
175634 97037 8 242 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
176195 102381 8 15 258 Molimo Dr   Back Yard : Yard Tree 2           5997615 2096604 37.7367383790998 -122.450727783905 (37.7367383790998, -122.450727783905) 9 7 4 59 40
176465 97038 8 73 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
176836 102639 8 15 251 Dorado Ter 1 Back Yard : Yard Tree 2           5994312.1 2092840.7 37.7262156610351 -122.461874461465 (37.7262156610351, -122.461874461465) 9 8 4 28861 40
177432 102706 8 41 1342 Funston Ave 1 Back Yard : Yard Tree 2           5992135.4 2106294.8 37.7630316255695 -122.470378504645 (37.7630316255695, -122.470378504645) 1 8 11 56 12
177799 103504 8 15 148 Huntington Dr 1 Back Yard : Yard Tree 2           5984515 2095210 37.7321522522788 -122.49591670505 (37.7321522522788, -122.49591670505) 1 8 4 64 35
179317 103673 8 45 64 Henry St   Back Yard : Yard Tree 2           6003097 2107420 37.7667488371496 -122.432546472662 (37.7667488371496, -122.432546472662) 15 5 5 28862 3
179653 97035 8 173 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
181064 104568 8 113 1101 Van Ness Ave 9 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
182344 104541 8 113 1101 Van Ness Ave 5 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
183841 252835 8 230 98 Prosper St 3 Sidewalk: Property side : Cutout Tree 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
184992 96603 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
186894 96605 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
189767 97036 8 242 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
191552 101904 8 72 1100 Ocean Ave 5 Front Yard : Yard Tree 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
192149 98878 8 17 11 Panorama Dr   Back Yard : Yard Landscaping 2           5998029 2100213 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849) 2 5 4 63 38
192549 98880 8 41 101 Lansdale Ave 1 Front Yard : Yard Tree 2     11     5994747.9 2097283.1 37.7384384842789 -122.460689725403 (37.7384384842789, -122.460689725403) 9 7 4 59 40
192727 97026 8 12 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
193463 102056 8 15 332 19th Ave 1 Back Yard : Yard Tree 2           5990007.7 2113121.3 37.7816520743217 -122.478236569715 (37.7816520743217, -122.478236569715) 11 6 2 55 26
136282 110181 8 19 2620 Sutter St 1 Sidewalk: Curb side : Cutout Tree 2     11 1.5x4   5999902.8272 2114053.62 37.7847814144727 -122.444071244627 (37.7847814144727, -122.444071244627) 15 6 1 29490 31
390 255918 8 15 80 Molimo Dr 1 Back Yard : Yard Tree 2       10x10   5998634.42423 2096706.77911 37.7370788872961 -122.447210599537 (37.7370788872961, -122.447210599537) 9 7 4 59 40
533 257925 8 15 274 Staples Ave   Back Yard : Yard Tree 2       10x10   5998272.17919 2093819.44967 37.7291302611298 -122.448255187535 (37.7291302611298, -122.448255187535) 9 7 4 28861 40
1189 261265 8 15 1100X Portola Dr 5 Median : Yard Tree 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
3020 260513 8 15 1990 41st Ave 1 Back Yard : Yard Tree 13       10x10   5983703 2101544 37.7494961014415 -122.499191781388 (37.7494961014415, -122.499191781388) 1 8 3 29491 35
5758 262529 8 63 555 Portola Dr 8 Front Yard : Yard Tree 4       10x10   5997546 2099815 37.7455510557903 -122.451197845188 (37.7455510557903, -122.451197845188) 2 7 5 63 7
13075 261490 8 15 1100X Portola Dr 4 Median : Yard Tree 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
20402 257888 8 28 155X Magellan Ave 1 Front Yard : Yard Tree 3       10x10   5995070 2100842 37.7482288640106 -122.459833790503 (37.7482288640106, -122.459833790503) 1 8 4 29491 40
28314 256608 8 15 279 Oak Park Dr 2 Back Yard : Yard Tree 2       10x10   5995764 2102990 37.7541666190925 -122.457589367448 (37.7541666190925, -122.457589367448) 1 5 4 63 12
46471 253626 8 41 1671 Funston Ave 1 Back Yard : Yard Tree 2       10x10   5992125 2104081 37.7569525124502 -122.470253253306 (37.7569525124502, -122.470253253306) 1 8 4 56 12
53415 254271 8 15 1201X Junipero Serra Blvd 1 Side Yard : Yard Tree 8       10x10   5991180 2089593 37.717117469349 -122.472465193375 (37.717117469349, -122.472465193375) 9 8 6 64 24
55834 121404 8 155 1900 08th Ave 1 Back Yard : Yard Tree 2     3 10x10   5993817 2102486 37.7526707300666 -122.464285931649 (37.7526707300666, -122.464285931649) 1 8 4 29491 40
80950 255115 8 11 301X Chester Ave 2 Sidewalk: Property side : Cutout Tree 2       10x10   5991786 2087190 37.7105544703116 -122.470195673297 (37.7105544703116, -122.470195673297) 9 8 4 64 24
87678 254111 8 15 279 Oak Park Dr 1 Back Yard : Yard Tree 2       10x10   5995764 2102990 37.7541666190925 -122.457589367448 (37.7541666190925, -122.457589367448) 1 5 4 63 12
89692 122453 8 15 217 San Marcos Ave 1 Back Yard : Yard Tree 2       10x10   5993325.07095 2100296.14299 37.7466295758311 -122.465827998209 (37.7466295758311, -122.465827998209) 1 8 4 29491 40
104559 254162 8 15 301X Chester Ave 1 Back Yard : Cutout Tree 2       10x10   5991786 2087190 37.7105544703116 -122.470195673297 (37.7105544703116, -122.470195673297) 9 8 4 64 24
104699 114731 8 56 934 BRANNAN ST   Back Yard : Yard Tree 2 Dept of Real Estate     10x10   6010724 2108745 37.7708165471861 -122.406259194073 (37.7708165471861, -122.406259194073) 14 2 9 28853 34
153614 255116 8 28 301X Chester Ave 3 Sidewalk: Property side : Cutout Tree 1       10x10   5991786 2087190 37.7105544703116 -122.470195673297 (37.7105544703116, -122.470195673297) 9 8 4 64 24
194461 265095 8 35 1100 Junipero Serra Blvd 1 Side Yard : Cutout Tree 2       10x10   5991104 2090006 37.7182470667789 -122.472757983106 (37.7182470667789, -122.472757983106) 9 8 4 64 40
75714 114950 8 15 1X WOODACRE DR 2 unknown : Yard Tree 1       30x100   5991187 2095315 37.7328290635508 -122.472857998502 (37.7328290635508, -122.472857998502) 1 8 4 64 40
133884 114949 8 15 1X WOODACRE DR 1 unknown : Yard Tree 1     30 30x100   5991187 2095315 37.7328290635508 -122.472857998502 (37.7328290635508, -122.472857998502) 1 8 4 64 40
39981 256672 8 15 15 Kenwood Way 11 Back Yard : Yard Tree 2       30x30   5994751 2093714 37.7286387886762 -122.4604204683 (37.7286387886762, -122.4604204683) 9 8 4 59 40
154591 112948 8 1 400 Pioche St 1 Sidewalk: Curb side : Cutout Tree 1 FUF   12 3x15   6005670.66964 2093276.94718 37.7280608613968 -122.422639431486 (37.7280608613968, -122.422639431486) 9 7 7 309 5
34 262408 8 15 66X Edgehill Way 1 Unaccepted Street : Yard Tree 2       3x3   5994840 2098758 37.7424934921887 -122.46047813267 (37.7424934921887, -122.46047813267) 1 8 4 59 40
342 115652 8 15 81x ELSIE ST 18 Back Yard : Cutout Tree 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
364 255980 8 17 541 Baker St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6000551 2110847 37.7760138103106 -122.441598590487 (37.7760138103106, -122.441598590487) 15 5 11 29492 16
628 256542 8 15 133 Olympia Way 1 Back Yard : Yard Tree 2       3x3   5996852 2101844 37.7510824274474 -122.453744067192 (37.7510824274474, -122.453744067192) 1 5 4 63 38
2059 264900 8 15 35X Parkridge Dr 1 Median : Yard Tree 2       3x3   5999060 2101975 37.7515684597407 -122.446118026985 (37.7515684597407, -122.446118026985) 2 5 5 63 38
2474 256556 8 75 3401X 16th St 5 Side Yard : Yard Tree 4   02/08/2019 09:18:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3