sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
107492 98715 7 3 26 Vernon St   13 1 1           5992459.0 2088068.0 37.713004133171 -122.46793347935301 (37.713004133171, -122.467933479353)
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)
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)
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)
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)
112237 109378 7 86 111 BAY ST 5 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
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)
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)
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)
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)
122333 97685 7 47 84 Coventry Ct   13 1 1           5997084.0 2096485.0 37.7363812239889 -122.452555087132 (37.7363812239889, -122.452555087132)
122755 102079 7 12 76 Manchester St 1 1 1 1 1 12/18/2012 12:00:00 AM   3x3 Permit Number 769729 6008162.3 2099676.4 37.7457726186307 -122.414478397936 (37.7457726186307, -122.414478397936)
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)
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)
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)
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)
139657 117644 7 47 1111X SANSOME ST 1 13 1 1       3x30   6011937.0 2119613.0 37.8007253016149 -122.402827843034 (37.8007253016149, -122.402827843034)
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)
142266 98139 7 124 556 Laidley St   13 1 1       3x3   6003085.0 2096041.0 37.7355041065287 -122.431775438062 (37.7355041065287, -122.431775438062)
142682 102752 7 116 2452 Green St   13 1 1           6001313.0 2117994.0 37.7956810212331 -122.43947508164 (37.7956810212331, -122.43947508164)
142955 33788 7 21 200x Mission St 6 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)
144179 102639 7 3 251 Dorado Ter 1 13 1 1           5994312.1 2092840.7 37.726215661035106 -122.461874461465 (37.7262156610351, -122.461874461465)
145060 102056 7 3 332 19th Ave 1 13 1 1           5990007.7 2113121.3 37.781652074321705 -122.47823656971501 (37.7816520743217, -122.478236569715)
145393 98880 7 47 101 Lansdale Ave 1 7 1 1     11     5994747.9 2097283.1 37.738438484278895 -122.460689725403 (37.7384384842789, -122.460689725403)
145716 98878 7 17 11 Panorama Dr   13 2 1           5998029.0 2100213.0 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849)
146266 109076 7 18 1137 Munich St 1 1 1 1 1     3x3 Permit Number 772744 6001554.7 2087011.6 37.7106245477128 -122.43642021389401 (37.7106245477128, -122.436420213894)
154560 110181 7 21 2620 Sutter St 1 1 1 1     11 1.5x4   5999902.8272 2114053.62 37.784781414472704 -122.444071244627 (37.7847814144727, -122.444071244627)
1273 251481 7 3 32 Peralta Ave 1 13 1 2       3x3   6010779.0 2100499.0 37.7481779538542 -122.40548810426901 (37.7481779538542, -122.405488104269)
19656 101900 7 3 1100 Ocean Ave 1 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
78854 101901 7 2 1100 Ocean Ave 2 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
85764 115641 7 3 81x ELSIE ST 7 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
85853 114950 7 3 1X WOODACRE DR 2 19 1 2       30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
86412 115638 7 3 81x ELSIE ST 4 16 1 2     7 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
90360 115646 7 3 81x ELSIE ST 12 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
95069 115635 7 3 81x ELSIE ST 1 16 1 2     20 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
96699 115645 7 3 81x ELSIE ST 11 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
97160 115639 7 3 81x ELSIE ST 5 16 1 2     6 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
99755 115644 7 3 81x ELSIE ST 10 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
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)
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)
108009 115652 7 3 81x ELSIE ST 18 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
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)
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)
113407 115650 7 3 81x ELSIE ST 16 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
118558 115640 7 3 81x ELSIE ST 6 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
122253 115643 7 3 81x ELSIE ST 9 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
124724 115642 7 3 81x ELSIE ST 8 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
125004 115653 7 3 81x ELSIE ST 19 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
127152 115647 7 3 81x ELSIE ST 13 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
139401 115654 7 3 81x ELSIE ST 20 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
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)
Powered by Datasette · Query took 4.752ms · Data source: data.sfgov.org