sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
101894 102250 7 41 125X Powhattan Ave 3 7 1 1   01/07/2013 12:00:00 AM     Permit Number 768486 6007606.0 2098071.0 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592)
102208 110843 7 231 2037 TURK BLVD   7 1 1     15     6000252.0 2111948.0 37.779019836036206 -122.442711981138 (37.7790198360362, -122.442711981138)
102307 99256 7 116 1466 York St   13 1 1           6010099.0 2100741.0 37.7488043872035 -122.407856595429 (37.7488043872035, -122.407856595429)
102527 115648 7 3 81x ELSIE ST 14 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
102675 115649 7 3 81x ELSIE ST 15 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
102914 112377 7 36 801 ULLOA ST 3 1 1 6     36     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
103103 91108 7 17 2650 Turk Blvd 1 7 1 1       On campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915)
103566 94487 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
103600 98436 7 17 238 Glenview Dr   13 1 1           5999035.0 2100736.0 37.7481650400364 -122.446115368035 (37.7481650400364, -122.446115368035)
104184 104318 7 21 22 Beaver St 1 7 1 1       3x3   6002763.0 2106816.0 37.765071454107996 -122.433658549479 (37.765071454108, -122.433658549479)
104754 102248 7 41 125X Powhattan Ave 1 7 1 1   01/07/2013 12:00:00 AM     Permit Number 768486 6007606.0 2098071.0 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592)
105403 105236 7 47 235X STATES ST 1 13 1 1     30     6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
105590 121144 7 3 400 Franconia St 1 13 1 1     15 3x3   6010016.0 2098808.0 37.743492145498294 -122.40800731166901 (37.7434921454983, -122.408007311669)
105598 106227 7 103 38 Stanford Heights Ave 1 13 1 1           5997884.0 2095808.5 37.7345695210024 -122.44974042873999 (37.7345695210024, -122.44974042874)
105687 122518 7 3 772X Panorama Dr 1 16 1 1       3x3   5996713.0 2102901.0 37.753976715350106 -122.45430108189 (37.7539767153501, -122.45430108189)
107232 98405 7 12 84 Richland Ave   1 1 1   02/08/2012 12:00:00 AM     Permit Number 768549 6005038.1 2096133.0 37.735867237922 -122.425029371072 (37.735867237922, -122.425029371072)
107366 101903 7 75 1100 Ocean Ave 4 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
107492 98715 7 3 26 Vernon St   13 1 1           5992459.0 2088068.0 37.713004133171 -122.46793347935301 (37.713004133171, -122.467933479353)
107936 118318 7 22 20 Norton St 1 7 1 6           6002015.686319999 2092167.12899 37.724806667280895 -122.435195459751 (37.7248066672809, -122.435195459751)
107998 97023 7 52 1443 Alabama St   1 1 1   08/16/2011 12:00:00 AM     Permit Number 768190 6009347.4 2100788.9 37.748893803646105 -122.410459018192 (37.7488938036461, -122.410459018192)
108009 115652 7 3 81x ELSIE ST 18 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
108286 100045 7 181 556 28th St   7 1 1         Not sure which property tree is located on. 6002301.0 2099461.0 37.7448501592716 -122.434730501666 (37.7448501592716, -122.434730501666)
108324 105353 7 17 1979 SAN JOSE AVE 2 7 1 1   04/16/2014 12:00:00 AM 27   Permit Number 772405 5999886.5 2092393.4 37.7253068164695 -122.442572018552 (37.7253068164695, -122.442572018552)
108742 110939 7 3 38 SAINT CHARLES AVE 1 16 1 1     30 3x3   5992046.0 2088201.0 37.7133454608488 -122.46937060641001 (37.7133454608488, -122.46937060641)
109029 108973 7 3 3485X SAN BRUNO AVE 1 3 1 10           6011510.0 2091910.0 37.724635221414 -122.402356490066 (37.724635221414, -122.402356490066)
109200 101625 7 250 64 Levant St 1 8 1 1         Permit Number 769362 6000275.9 2106473.5 37.76398959970761 -122.442236202383 (37.7639895997076, -122.442236202383)
109233 104397 7 231 350 Collingwood St 1 7 1 1           6002086.0 2103822.0 37.756812219827296 -122.43578589078301 (37.7568122198273, -122.435785890783)
110212 110320 7 54 9 Imperial Aly   13 2 1           6005040.9 2119421.8 37.7998128500526 -122.426677597274 (37.7998128500526, -122.426677597274)
110616 101905 7 75 1100 Ocean Ave 6 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
110904 109242 7 64 2479 DIAMOND ST   2 2 1           6002238.1 2097343.7 37.7390329760373 -122.434796615916 (37.7390329760373, -122.434796615916)
110958 108680 7 19 240 SANTA ANA AVE 1 13 1 1           5992606.9 2095181.7 37.73254515275271 -122.46793939448999 (37.7325451527527, -122.46793939449)
111345 114949 7 3 1X WOODACRE DR 1 19 1 2     30 30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
111875 115636 7 3 81x ELSIE ST 2 16 1 2     16 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
111891 105167 7 60 4755X 03RD ST 1 8 1 19     8 3x3   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
112237 109378 7 86 111 BAY ST 5 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
112387 109194 7 180 4705 03rd St   13 1 19     45     6015121.6 2095617.0 37.7350148477359 -122.39013039721901 (37.7350148477359, -122.390130397219)
112389 105171 7 21 4755X 03RD ST 5 7 1 19     14 4x4   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
112498 106458 7 17 71 HANCOCK ST   13 1 1           6003861.6 2105050.0 37.7602847161222 -122.429732794413 (37.7602847161222, -122.429732794413)
112911 33786 7 21 200x Mission St 4 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
113071 108574 7 17 1891 15th St 1 13 1 1       7x8   6004884.86016 2107160.4412599998 37.7661373754728 -122.426344078904 (37.7661373754728, -122.426344078904)
113280 105686 7 94 635 08TH ST 3 30 1 1     6     6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597)
113407 115650 7 3 81x ELSIE ST 16 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
113649 102469 7 3 1021 Kirkham St 1 13 1 1           5991773.0 2105198.0 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129)
114652 97162 7 235 478 10th Ave   13 1 1         Tree in backyard on private property; not significant. 5992861.5 2112216.7 37.7793335349967 -122.468298031686 (37.7793335349967, -122.468298031686)
114948 113440 7 47 190 BEACON ST   13 1 1     32 3x3   6003193.0 2097540.0 37.739626138558705 -122.43150902083299 (37.7396261385587, -122.431509020833)
115179 106275 7 103 42 Stanford Heights Ave 1 13 1 1           5997882.5 2095834.4 37.7346405503947 -122.449747480555 (37.7346405503947, -122.449747480555)
115312 100244 7 113 71 Sanchez St   13 1 1         Interior courtyard 6003507.0 2107903.0 37.7680982797144 -122.431162830878 (37.7680982797144, -122.431162830878)
115357 98501 7 17 232 Glenview Dr   13 2 1           5998998.0 2100740.0 37.748173910048706 -122.446243600021 (37.7481739100487, -122.446243600021)
116003 114410 7 3 10 GARDENSIDE DR   1 1 1           5999306.0 2102458.0 37.752908704913395 -122.445302055175 (37.7529087049134, -122.445302055175)
116035 105232 7 3 460X ROOSEVELT WAY 2 7 1 1     17     5999944.0 2106286.0 37.7634558498539 -122.443370673769 (37.7634558498539, -122.443370673769)
117738 104008 7 3 357 Collingwood St 1 13 1 1     36     6002124.0 2103789.0 37.7567237682266 -122.435652112093 (37.7567237682266, -122.435652112093)
117969 105170 7 21 4755X 03RD ST 4 8 1 19     2 3x3   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
118024 94228 7 175 1097 Church St   7 1 1   06/25/2010 12:00:00 AM     Permit Number 53567 6004455.0 2102510.0 37.753344058808395 -122.427499544702 (37.7533440588084, -122.427499544702)
118325 109374 7 86 111 BAY ST 1 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
118558 115640 7 3 81x ELSIE ST 6 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
118579 108625 7 113 100 GENEBERN WAY 1 7 1 1     12     6004991.8 2095242.4 37.7334192343039 -122.42512609869301 (37.7334192343039, -122.425126098693)
119332 120526 7 3 1439 47th Ave 1 13 1 1     20 3x3   5981489.0 2105275.0 37.759610238830206 -122.50712446853998 (37.7596102388302, -122.50712446854)
119700 100472 7 3 70 Stanford Heights Ave   13 1 1           5997872.4 2096006.9 37.735113616296 -122.44979482672899 (37.735113616296, -122.449794826729)
119975 112668 7 3 129 Henry St   13 1 1           6002668.0 2107340.8 37.766507036069605 -122.434024647923 (37.7665070360696, -122.434024647923)
120104 33790 7 21 200x Mission St 8 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
120579 114365 7 3 2546 28th Ave 1 13 1 1     35     5987735.7 2097954.4 37.739875761389605 -122.48498344199601 (37.7398757613896, -122.484983441996)
120804 96938 7 17 1306 Cole St   13 1 1         Backyard tree on private property 5998246.0 2105961.0 37.7624665052811 -122.449220068104 (37.7624665052811, -122.449220068104)
120823 33791 7 21 200x Mission St 9 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
122253 115643 7 3 81x ELSIE ST 9 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
122333 97685 7 47 84 Coventry Ct   13 1 1           5997084.0 2096485.0 37.7363812239889 -122.452555087132 (37.7363812239889, -122.452555087132)
124085 116154 7 105 324 POPE ST 1 13 1 1       3x3   6000502.0 2087202.0 37.711087470467795 -122.440072212787 (37.7110874704678, -122.440072212787)
124150 121198 7 141 2521 18th Ave 1 5 1 1     3 3x3   5990743.0 2098231.0 37.740809941753 -122.47460574514 (37.740809941753, -122.47460574514)
124250 99374 7 3 21 Panorama Dr   13 1 1     24     5998009.0 2100230.0 37.7467170430405 -122.449626769288 (37.7467170430405, -122.449626769288)
124724 115642 7 3 81x ELSIE ST 8 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
124771 105685 7 94 635 08TH ST 2 30 1 1     8     6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597)
124987 98548 7 116 132 Hamerton Ave 1 7 1 1           6001332.8 2095440.7 37.7337563407686 -122.437790462907 (37.7337563407686, -122.437790462907)
125004 115653 7 3 81x ELSIE ST 19 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
125343 99276 7 17 85X 10th St 2 7 1 1   04/25/2012 12:00:00 AM     Permit Number 768878 6007907.6 2110517.0 37.7755240963356 -122.416126724722 (37.7755240963356, -122.416126724722)
125346 100148 7 17 209 Vicksburg St   13 1 1           6004141.0 2102142.0 37.7523158521071 -122.428559192815 (37.7523158521071, -122.428559192815)
125761 108576 7 54 2479 Diamond St 1 7 2 1           6002240.0 2097369.0 37.7391025518434 -122.434791855338 (37.7391025518434, -122.434791855338)
125858 104539 7 19 1101 Van Ness Ave 2 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
126368 105684 7 94 635 08TH ST 1 30 1 1     10     6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597)
126465 101951 7 17 21 Lyell St   19 1 1           6003106.0 2094969.0 37.7325618289587 -122.43162632292 (37.7325618289587, -122.43162632292)
126549 94468 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
127152 115647 7 3 81x ELSIE ST 13 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
127758 109376 7 86 111 BAY ST 3 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
128066 98503 7 47 208 Glenview Dr   13 1 1           5998871.0 2100779.0 37.74827374071911 -122.44668556582701 (37.7482737407191, -122.446685565827)
128175 33776 7 21 200x Mission St 1 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
128311 98265 7 143 755 O'Farrell St   13 1 1         Backyard tree; not significant 6007700.0 2113968.3 37.784988860902295 -122.417089467607 (37.7849888609023, -122.417089467607)
128562 33799 7 21 200x Mission St 10 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
129004 108871 7 17 99x OAKWOOD ST 1 13 1 1           6005305.0 2104962.0 37.760124716943295 -122.424734485609 (37.7601247169433, -122.424734485609)
129259 122558 7 3 1760 Diamond St 1 13 1 1     20 3x3   6001927.0 2098732.0 37.7428272563398 -122.43597156823799 (37.7428272563398, -122.435971568238)
129310 99268 7 17 292 Whitney St   8 1 1           6004280.0 2096681.0 37.7373290690714 -122.42768945491501 (37.7373290690714, -122.427689454915)
129485 97033 7 70 61 Vicksburg St   13 1 1         Possible significant tree; Nellie RoW; rear yard 6004120.0 2102703.0 37.753855038047 -122.428671801406 (37.753855038047, -122.428671801406)
138525 104568 7 19 1101 Van Ness Ave 9 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
139401 115654 7 3 81x ELSIE ST 20 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
139657 117644 7 47 1111X SANSOME ST 1 13 1 1       3x30   6011937.0 2119613.0 37.8007253016149 -122.402827843034 (37.8007253016149, -122.402827843034)
139921 115637 7 3 81x ELSIE ST 3 16 1 2     14 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
140030 103504 7 3 148 Huntington Dr 1 13 1 1           5984515.0 2095210.0 37.732152252278794 -122.49591670504999 (37.7321522522788, -122.49591670505)
140502 104541 7 19 1101 Van Ness Ave 5 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
140844 102706 7 47 1342 Funston Ave 1 13 1 1           5992135.4 2106294.8 37.7630316255695 -122.470378504645 (37.7630316255695, -122.470378504645)
140943 120977 7 3 794x Gates St 1 2 1 1     3030 3x3   6008103.0 2095407.0 37.7340464539486 -122.414381414226 (37.7340464539486, -122.414381414226)
141038 102381 7 3 258 Molimo Dr   13 1 1           5997615.0 2096604.0 37.7367383790998 -122.450727783905 (37.7367383790998, -122.450727783905)
141354 120533 7 103 951 Brannan St 1 5 1 1     22 3x3   6010745.0 2108673.0 37.7706200263658 -122.40618148078501 (37.7706200263658, -122.406181480785)
141787 103673 7 54 64 Henry St   13 1 1           6003097.0 2107420.0 37.7667488371496 -122.432546472662 (37.7667488371496, -122.432546472662)
142076 115655 7 3 81x ELSIE ST 21 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
Powered by Datasette · Query took 4.503ms · Data source: data.sfgov.org