sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
12440 100166 7 218 2340 Twin Peaks Blvd   7 1 1         Permit Number 769026          
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)
124085 116154 7 105 324 POPE ST 1 13 1 1       3x3   6000502.0 2087202.0 37.711087470467795 -122.440072212787 (37.7110874704678, -122.440072212787)
107492 98715 7 3 26 Vernon St   13 1 1           5992459.0 2088068.0 37.713004133171 -122.46793347935301 (37.713004133171, -122.467933479353)
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)
13321 187670 7 3 230 Victoria St 1 13 1 1       3x3   5993274.0 2088748.0 37.7149182807441 -122.465165952001 (37.7149182807441, -122.465165952001)
79011 108637 7 3 15 TUCKER AVE   13 1 1           6011049.2 2088423.2 37.715035447895396 -122.403704200211 (37.7150354478954, -122.403704200211)
18793 114373 7 62 805 GONZALEZ DR 1 7 1 1     18     5988302.0 2089566.0 37.7168763353695 -122.482410970247 (37.7168763353695, -122.482410970247)
104891 102101 7 141 331 Vernon St 1 1 1 1 1 12/19/2012 12:00:00 AM 12 3x3 Permit Number 769722 5992434.3 2090067.3 37.718492301183204 -122.468164197766 (37.7184923011832, -122.468164197766)
77987 100070 7 17 331 Serrano Dr 1 7 1 1         Permit Number 777990 5990400.0 2090718.0 37.7201612636948 -122.47524333880699 (37.7201612636948, -122.475243338807)
22300 248974 7 2 716 Goettingen St 1 13 1 1       3x3   6010713.0 2091306.0 37.7229322393396 -122.405069122237 (37.7229322393396, -122.405069122237)
109029 108973 7 3 3485X SAN BRUNO AVE 1 3 1 10           6011510.0 2091910.0 37.724635221414 -122.402356490066 (37.724635221414, -122.402356490066)
76017 106971 7 3 3479X San Bruno Ave 1 7 1 1     30     6011510.60551 2091910.0343099998 37.7246353494236 -122.402354399294 (37.7246353494236, -122.402354399294)
107936 118318 7 22 20 Norton St 1 7 1 6           6002015.686319999 2092167.12899 37.724806667280895 -122.435195459751 (37.7248066672809, -122.435195459751)
98180 120995 7 64 231 Delano Ave 1 7 2 1       3x3   6000066.0 2092260.0 37.72495076112679 -122.44194193563999 (37.7249507611268, -122.44194193564)
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)
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)
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)
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)
146191 101904 7 75 1100 Ocean Ave 5 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
21199 97237 7 41 125 Excelsior Ave   9 1 4 1 09/07/2011 12:00:00 AM     Permit Number 767513 6002911.0 2092621.3 37.7261045201699 -122.43213288829399 (37.7261045201699, -122.432132888294)
100052 97238 7 41 125 Excelsior Ave 1 9 1 4 1 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767513 6002911.0 2092621.3 37.7261045201699 -122.43213288829399 (37.7261045201699, -122.432132888294)
127434 97236 7 458 125 Excelsior Ave   9 1 4 1 09/07/2011 12:00:00 AM     Permit Number 767513 6002911.0 2092621.3 37.7261045201699 -122.43213288829399 (37.7261045201699, -122.432132888294)
144179 102639 7 3 251 Dorado Ter 1 13 1 1           5994312.1 2092840.7 37.726215661035106 -122.461874461465 (37.7262156610351, -122.461874461465)
78509 102745 7 47 222 Moncada Way 1 7 1 1           5992354.0 2093377.4 37.727576385896604 -122.468682482409 (37.7275763858966, -122.468682482409)
11978 112948 7 4 400 Pioche St 1 1 1 1     12 3x15   6005670.66964 2093276.94718 37.7280608613968 -122.42263943148599 (37.7280608613968, -122.422639431486)
76012 97025 7 88 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
78805 97021 7 180 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
81165 97014 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
81341 97022 7 195 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
82893 97042 7 322 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
85013 97015 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
87538 97027 7 1 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
88802 97029 7 232 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
90248 97040 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
92954 97034 7 54 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
94845 97016 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
99914 97028 7 112 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
104476 97043 7 322 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
104783 96999 7 20 195A Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
107550 97032 7 477 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
125485 97041 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
125835 97004 7 20 195A Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
127473 97045 7 207 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
128784 97039 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
140389 97037 7 477 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
140586 97044 7 322 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
140629 97038 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
142369 97035 7 309 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
145213 97026 7 208 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
145522 97036 7 477 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
98218 122480 7 3 596X Buckingham Way 1 18 1 1       3x3   5990152.0 2094375.0 37.7301880902761 -122.476367577616 (37.7301880902761, -122.476367577616)
140030 103504 7 3 148 Huntington Dr 1 13 1 1           5984515.0 2095210.0 37.732152252278794 -122.49591670504999 (37.7321522522788, -122.49591670505)
110958 108680 7 19 240 SANTA ANA AVE 1 13 1 1           5992606.9 2095181.7 37.73254515275271 -122.46793939448999 (37.7325451527527, -122.46793939449)
126465 101951 7 17 21 Lyell St   19 1 1           6003106.0 2094969.0 37.7325618289587 -122.43162632292 (37.7325618289587, -122.43162632292)
85853 114950 7 3 1X WOODACRE DR 2 19 1 2       30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
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)
87429 108624 7 19 101 GENEBERN WAY 1 7 1 1           6005050.2 2095237.8 37.733409902631 -122.42492386614401 (37.733409902631, -122.424923866144)
118579 108625 7 113 100 GENEBERN WAY 1 7 1 1     12     6004991.8 2095242.4 37.7334192343039 -122.42512609869301 (37.7334192343039, -122.425126098693)
124987 98548 7 116 132 Hamerton Ave 1 7 1 1           6001332.8 2095440.7 37.7337563407686 -122.437790462907 (37.7337563407686, -122.437790462907)
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)
105598 106227 7 103 38 Stanford Heights Ave 1 13 1 1           5997884.0 2095808.5 37.7345695210024 -122.44974042873999 (37.7345695210024, -122.44974042874)
115179 106275 7 103 42 Stanford Heights Ave 1 13 1 1           5997882.5 2095834.4 37.7346405503947 -122.449747480555 (37.7346405503947, -122.449747480555)
112387 109194 7 180 4705 03rd St   13 1 19     45     6015121.6 2095617.0 37.7350148477359 -122.39013039721901 (37.7350148477359, -122.390130397219)
119700 100472 7 3 70 Stanford Heights Ave   13 1 1           5997872.4 2096006.9 37.735113616296 -122.44979482672899 (37.735113616296, -122.449794826729)
83931 105169 7 60 4755X 03RD ST 3 8 1 19     23 4x4   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
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)
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)
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)
81598 94690 7 329 749 Congo St   7 1 1   10/28/2010 12:00:00 AM     Permit Number 53820 6000274.0 2096023.0 37.735294937499 -122.441492809367 (37.735294937499, -122.441492809367)
142266 98139 7 124 556 Laidley St   13 1 1       3x3   6003085.0 2096041.0 37.7355041065287 -122.431775438062 (37.7355041065287, -122.431775438062)
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)
122333 97685 7 47 84 Coventry Ct   13 1 1           5997084.0 2096485.0 37.7363812239889 -122.452555087132 (37.7363812239889, -122.452555087132)
141038 102381 7 3 258 Molimo Dr   13 1 1           5997615.0 2096604.0 37.7367383790998 -122.450727783905 (37.7367383790998, -122.450727783905)
129310 99268 7 17 292 Whitney St   8 1 1           6004280.0 2096681.0 37.7373290690714 -122.42768945491501 (37.7373290690714, -122.427689454915)
74398 97290 7 3 55 Hiliritas Ave   7 1 1         Permit Number 778896 6001461.7 2096833.2 37.7375871516219 -122.437444499981 (37.7375871516219, -122.437444499981)
101635 121104 7 3 477 Myra Way 1 13 1 1       3x3   5997298.0 2097021.0 37.7378652095891 -122.45185385938998 (37.7378652095891, -122.45185385939)
145393 98880 7 47 101 Lansdale Ave 1 7 1 1     11     5994747.9 2097283.1 37.738438484278895 -122.460689725403 (37.7384384842789, -122.460689725403)
110904 109242 7 64 2479 DIAMOND ST   2 2 1           6002238.1 2097343.7 37.7390329760373 -122.434796615916 (37.7390329760373, -122.434796615916)
125761 108576 7 54 2479 Diamond St 1 7 2 1           6002240.0 2097369.0 37.7391025518434 -122.434791855338 (37.7391025518434, -122.434791855338)
114948 113440 7 47 190 BEACON ST   13 1 1     32 3x3   6003193.0 2097540.0 37.739626138558705 -122.43150902083299 (37.7396261385587, -122.431509020833)
120579 114365 7 3 2546 28th Ave 1 13 1 1     35     5987735.7 2097954.4 37.739875761389605 -122.48498344199601 (37.7398757613896, -122.484983441996)
89166 102275 7 17 267 Topaz Way   13 2 1           6001225.6 2097744.2 37.740075118911705 -122.438326054857 (37.7400751189117, -122.438326054857)
102914 112377 7 36 801 ULLOA ST 3 1 1 6     36     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
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)
1996 252848 7 164 99 Reposa Way 1 13 1 1       3x3   5998022.0 2098104.0 37.7408803073177 -122.44942865965 (37.7408803073177, -122.44942865965)
80595 102251 7 458 125X Powhattan Ave 4 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)
99354 102249 7 41 125X Powhattan Ave 2 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)
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)
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)
82794 110929 7 3 445 BEACON ST   13 1 1       3x3   6002243.0 2098437.0 37.7420352018096 -122.434857838675 (37.7420352018096, -122.434857838675)
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)
81246 109097 7 12 601 29th St 1 1 1 1 1 01/27/2015 12:00:00 AM 3 3x3 Permit Number 774331 6002630.6 2098839.9 37.743163470374895 -122.43354642924999 (37.7431634703749, -122.43354642925)
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)
85764 115641 7 3 81x ELSIE ST 7 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
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)
Powered by Datasette · Query took 4.889ms · Data source: data.sfgov.org