sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
79586 94645 1 40 30 Middle Point Rd 34 4 1 1           6018215.0 2095138.0 37.733870695497295 -122.37940203679399 (37.7338706954973, -122.379402036794)
113544 94646 1 5 30 Middle Point Rd 35 4 1 1           6018215.0 2095138.0 37.733870695497295 -122.37940203679399 (37.7338706954973, -122.379402036794)
140036 105148 1 17 185 Stratford Dr   4 1 1   12/26/2013 12:00:00 AM     Permit Number 770387 5990916.9 2091282.3 37.7217406386467 -122.473497746062 (37.7217406386467, -122.473497746062)
145389 94463 6 3 744 Carolina St 1 4 1 1   06/10/2010 12:00:00 AM     Permit Number 53681 6012327.5 2104524.9 37.759318660176504 -122.40041614875601 (37.7593186601765, -122.400416148756)
31579 198708 2 215 1601 Bay Shore Blvd 4 4 1 1     0 Width 3ft   6012024.53747 2091412.02554 37.723296594957 -122.40054282438999 (37.723296594957, -122.40054282439)
33965 196585 2 9 1295 Harrison St 2 4 1 1     0 Width 3ft   6009272.40874 2109874.5965 37.7738368509301 -122.411360111888 (37.7738368509301, -122.411360111888)
72618 199649 2 54 1601 Evans Ave 22 4 1 1     0 Width 1ft   6015107.35337 2098882.19142 37.7439796026678 -122.390407721252 (37.7439796026678, -122.390407721252)
135877 199650 2 54 0 1 4 1 1     0 Width 0ft   6014963.58685 2093280.8179400002 37.728591398452394 -122.390513521988 (37.7285913984524, -122.390513521988)
148375 196586 2 9 1295 Harrison St 3 4 1 1     0 Width 3ft   6009287.47644 2109885.83253 37.7738685475242 -122.411308783978 (37.7738685475242, -122.411308783978)
178220 199651 2 54 0 37 4 1 1     0 Width 0ft   6018297.01834 2097895.80454 37.7414476037323 -122.37930996579901 (37.7414476037323, -122.379309965799)
1969 198010 2 37 213 Clara St 1 4 1 1     1 Width 3ft Permit Number 779305 6011863.46506 2111836.2655700003 37.7793681257663 -122.40253514649099 (37.7793681257663, -122.402535146491)
24358 211712 2 26 418 San Miguel St 1 4 1 1     1 Width 3ft   5997865.28032 2089936.92549 37.7184464872957 -122.449382239324 (37.7184464872957, -122.449382239324)
24374 192945 2 21 238 11th St 2 4 1 1     1 Width 3ft   6008246.27864 2109382.4071299997 37.7724278093356 -122.41487483150401 (37.7724278093356, -122.414874831504)
24599 225999 2 44 700 Duboce Ave 3 4 1 1     1 Width 3ft   6002335.19401 2108315.06979 37.7691632487104 -122.435245457027 (37.7691632487104, -122.435245457027)
24622 247221 2 44 187 Divisadero St 1 4 1 1     1 Width 3ft   6001849.330080001 2108668.89946 37.770107174421796 -122.436951364836 (37.7701071744218, -122.436951364836)
25659 194764 2 26 1101 Newhall St 1 4 1 1     1 Width 6ft   6014997.18752 2096468.24359 37.737345287747395 -122.390620003515 (37.7373452877474, -122.390620003515)
25944 233355 2 306 45 Clarendon Ave 1 4 1 1     1 Width 3ft   5998067.992430001 2104637.9237599997 37.758823486839 -122.449740378141 (37.758823486839, -122.449740378141)
26062 247051 2 197 519 Valley St 1 4 1 1     1 Width 3ft   6002519.90495 2099141.5459 37.743985438385295 -122.43395073994499 (37.7439854383853, -122.433950739945)
26321 247172 2 235 145 Buena Vista Ave East 3 4 1 1     1 Width 4ft   6001372.05344 2108496.3443400003 37.7696062421579 -122.438589890015 (37.7696062421579, -122.438589890015)
27153 197239 2 76 830 Rhode Island St 1 4 1 1     1 Width 6ft   6011827.26305 2104492.53285 37.7592018783746 -122.40214394588999 (37.7592018783746, -122.40214394589)
27799 208686 2 21 207 Lakeview Ave 1 4 1 1     1 Width 3ft   5997054.6676199995 2089435.45045 37.7170231509855 -122.45214801343201 (37.7170231509855, -122.452148013432)
28061 250087 2 249 1608 Bush St 2 4 1 1     1 Width 1ft   6005770.74957 2115225.4613099997 37.7883319959812 -122.423853491051 (37.7883319959812, -122.423853491051)
28080 198006 2 37 238 Shipley St 2 4 1 1     1 Width 3ft   6011475.496280001 2111728.4985 37.7790505553711 -122.403869715215 (37.7790505553711, -122.403869715215)
28254 235714 2 16 575 Florida St 1 4 1 1     1 Width 3ft   6009284.05083 2105508.94115 37.761850423188704 -122.41101142226499 (37.7618504231887, -122.411011422265)
28441 189265 2 49 2203 Newcomb Ave 1 4 1 1     1 Width 3ft   6011972.28331 2098093.92114 37.7416407727111 -122.40119276536001 (37.7416407727111, -122.40119276536)
28661 189257 2 49 2231 Newcomb Ave 1 4 1 1     1 Width 3ft   6011833.55798 2098197.58892 37.7419176820557 -122.40167971856 (37.7419176820557, -122.40167971856)
28700 189264 2 49 2207 Newcomb Ave 1 4 1 1     1 Width 3ft   6011951.89121 2098108.4509400004 37.741679530779294 -122.401264295606 (37.7416795307793, -122.401264295606)
28877 188060 2 12 1241 Evans Ave 2 4 1 1     1 Width 4ft   6017512.496169999 2097088.9484700002 37.7391888439962 -122.381966489387 (37.7391888439962, -122.381966489387)
29741 196461 2 18 615 Mississippi St 1 4 1 1     1 Width 3ft   6014144.28645 2104277.08263 37.7587393543665 -122.39411542098999 (37.7587393543665, -122.39411542099)
29757 198021 2 37 217 Clara St 2 4 1 1     1 Width 3ft   6011882.31824 2111817.0211 37.7793163374183 -122.40246857147699 (37.7793163374183, -122.402468571477)
30043 193801 2 2 776 Wisconsin St 1 4 1 1     1 Width 3ft   6012701.04475 2103917.58098 37.7576719193319 -122.39908161224899 (37.7576719193319, -122.399081612249)
30296 202045 2 18 41 Exeter St 1 4 1 1     1 Width 3ft   6012584.35783 2091031.2434099999 37.7222822496095 -122.39858091108201 (37.7222822496095, -122.398580911082)
30636 193062 2 21 1601 Evans Ave 12 4 1 1     1 Width 4ft   6014912.025280001 2099027.7617599997 37.7443684713257 -122.391093299634 (37.7443684713257, -122.391093299634)
31159 242866 2 51 98 McCoppin St 5 4 1 1     1 Width 3ft   6006095.439119999 2109158.70233 37.7716924795429 -122.422298906788 (37.7716924795429, -122.422298906788)
31173 225996 2 44 47 Octavia St 4 4 1 1     1 Width 4ft   6005638.67194 2109514.80428 37.7726444739859 -122.423904220905 (37.7726444739859, -122.423904220905)
31788 241075 2 321 158 Tiffany Ave 1 4 1 1     1 Width 1ft   6006085.09407 2099316.84572 37.74466845098979 -122.421635555133 (37.7446684509898, -122.421635555133)
32400 192428 2 44 480 Bryant St 1 4 1 1     1 Width 3ft   6014110.58587 2112833.82618 37.782232395453796 -122.39483123728 (37.7822323954538, -122.39483123728)
32814 214424 2 35 732 Shields St 1 4 1 1     1 Width 3ft   5992045.199469999 2089870.8873400001 37.7179305201634 -122.469494855606 (37.7179305201634, -122.469494855606)
32988 196389 2 35 93 Stillman St 1 4 1 1     1 Width 3ft   6013924.26567 2112893.70041 37.7823864349182 -122.395480022606 (37.7823864349182, -122.395480022606)
33587 198007 2 37 274 Shipley St 2 4 1 1     1 Width 2ft   6011297.08858 2111564.84003 37.7785912185545 -122.404475379844 (37.7785912185545, -122.404475379844)
33767 190391 2 44 571 Texas St 2 4 1 1     1 Width 6ft   6013851.28196 2104449.17868 37.75919560292179 -122.395140827087 (37.7591956029218, -122.395140827087)
33953 247763 2 37 55 Alpine Ter 1 4 1 1     1 Width 5ft   6001651.1462 2108480.6901700003 37.769579132108205 -122.43762339851101 (37.7695791321082, -122.437623398511)
34271 196527 2 102 333 Texas St 1 4 1 1     1 Width 3ft   6013792.65149 2105531.32389 37.7621636768226 -122.395419411895 (37.7621636768226, -122.395419411895)
35117 190404 2 44 2323 Cesar Chavez St 11 4 1 1     1 Width 3ft   6012224.99422 2100912.98992 37.74939542707129 -122.40051694820801 (37.7493954270713, -122.400516948208)
35195 196310 2 16 928 Clara St 3 4 1 1     1 Width 3ft   6011726.41935 2111671.91567 37.778909207118204 -122.402997684908 (37.7789092071182, -122.402997684908)
35416 246955 2 21 2101 15th St 7 4 1 1     1 Width 3ft   6003442.97283 2107114.24236 37.765928914304794 -122.43132798319401 (37.7659289143048, -122.431327983194)
35914 196425 2 18 282 Shipley St 1 4 1 1     1 Width 5ft   6011155.7597199995 2111427.64984 37.778206627062296 -122.404954631245 (37.7782066270623, -122.404954631245)
36121 189263 2 49 2211 Newcomb Ave 1 4 1 1     1 Width 3ft   6011935.60653 2098120.24236 37.7417109989595 -122.401321431357 (37.7417109989595, -122.401321431357)
36209 190444 2 44 1301 Evans Ave 7 4 1 1     1 Width 3ft   6017091.55638 2097401.29734 37.7400232358798 -122.383443661803 (37.7400232358798, -122.383443661803)
36484 207243 2 27 324 Lakeview Ave 1 4 1 1     1 Width 3ft   5996808.75565 2089668.4523599998 37.7176488300194 -122.453014817795 (37.7176488300194, -122.453014817795)
36521 187478 2 61 1888 Geneva Ave 1 4 1 1     1 Width 3ft   6004785.02328 2086870.2631599999 37.710419493035104 -122.425245442839 (37.7104194930351, -122.425245442839)
36650 242863 2 51 98 McCoppin St 1 4 1 1     1 Width 3ft   6006168.47171 2109163.73568 37.7717104192431 -122.422046639762 (37.7717104192431, -122.422046639762)
36945 250489 2 21 240 El Camino Del Mar 1 4 1 1     1 Width 3ft   5987807.77183 2115352.13466 37.7876493619664 -122.48601098323499 (37.7876493619664, -122.486010983235)
37151 208700 2 21 144 Eucalyptus Dr 2 4 1 1     1 Width 3ft   5990998.47136 2094705.0168400002 37.731143287718 -122.473465306694 (37.731143287718, -122.473465306694)
37346 190445 2 44 1201 Evans Ave 3 4 1 1     1 Width 3ft   6017686.12557 2096959.12409 37.738841959282205 -122.381357125839 (37.7388419592822, -122.381357125839)
37647 136662 2 241 1307 Bay St 4 4 1 1     1 Width 1ft   6004522.84241 2120815.90939 37.803611411885704 -122.428569697738 (37.8036114118857, -122.428569697738)
37995 228900 2 11 1 Haight St 1 4 1 1     1 Width 3ft   6006045.73511 2109652.55935 37.7730456885414 -122.422505934299 (37.7730456885414, -122.422505934299)
38544 189841 2 97 101 Newhall St 3 4 1 1     1 Width 3ft   6017113.188630001 2098207.21128 37.742237308295294 -122.38342495321899 (37.7422373082953, -122.383424953219)
38708 228886 2 11 526 Hickory St 1 4 1 1     1 Width 3ft   6004289.67474 2110317.5310299997 37.774772315811795 -122.42862777776399 (37.7747723158118, -122.428627777764)
39264 204069 2 12 161 Byxbee St 8 4 1 1     1 Width 2ft   5991925.79364 2089647.35065 37.7173098413624 -122.469891319037 (37.7173098413624, -122.469891319037)
39356 204071 2 12 161 Byxbee St 10 4 1 1     1 Width 2ft   5991926.528080001 2089611.9892799999 37.7172127901068 -122.469886207299 (37.7172127901068, -122.469886207299)
39506 198280 2 51 951 Phelps St 2 4 1 1     1 Width 3ft   6014735.9327300005 2097232.0415 37.739428022289204 -122.39157667443001 (37.7394280222892, -122.39157667443)
39757 202047 2 44 55 Exeter St 1 4 1 1     1 Width 3ft   6012547.51313 2090916.47332 37.721965061416796 -122.398700225048 (37.7219650614168, -122.398700225048)
39953 246990 2 44 78 Clipper St 1 4 1 1     1 Width 4ft   6004670.61163 2101066.74727 37.7493934152835 -122.426651147943 (37.7493934152835, -122.426651147943)
40169 211398 2 108 500 Junipero Serra Blvd 57 4 1 1     1 Width 0ft   5991312.42459 2093316.55821 37.7273491037745 -122.47227875018801 (37.7273491037745, -122.472278750188)
40355 207621 2 49 259 Bright St 1 4 1 1     1 Width 3ft   5993736.2843 2088924.46634 37.7154294623887 -122.463580914754 (37.7154294623887, -122.463580914754)
40539 189270 2 49 59 Robblee Ave 1 4 1 1     1 Width 3ft   6012477.87962 2095853.3507 37.735516831132 -122.39928732315 (37.735516831132, -122.39928732315)
40590 208699 2 21 144 Eucalyptus Dr 1 4 1 1     1 Width 3ft   5991017.2717699995 2094704.6203400001 37.731143287728706 -122.473400282119 (37.7311432877287, -122.473400282119)
40809 247807 2 26 500 30th St 2 4 1 1     1 Width 3ft   6003285.4194 2098358.0891 37.7418776604327 -122.431247854519 (37.7418776604327, -122.431247854519)
40822 187972 2 126 75 Bridgeview Dr 1 4 1 1     1 Width 2ft   6013703.3858900005 2095554.5779799998 37.734764687625706 -122.395029332752 (37.7347646876257, -122.395029332752)
40837 220771 2 28 301 Webster St 3 4 1 1     1 Width 3ft   6004135.7148 2109869.98632 37.7735347533659 -122.429128439333 (37.7735347533659, -122.429128439333)
40843 192425 2 44 187 Clara St 6 4 1 1     1 Width 2ft   6011952.39777 2111919.37561 37.779601291212394 -122.402233334018 (37.7796012912124, -122.402233334018)
41558 205942 2 304 700 Junipero Serra Blvd 41 4 1 1     1 Width 0ft   5991261.76371 2092534.5655 37.7251990144957 -122.47239689950399 (37.7251990144957, -122.472396899504)
41885 247192 2 11 98 Broderick St 1 4 1 1     1 Width 3ft   6001382.446819999 2108930.15672 37.770797974263104 -122.43858502738199 (37.7707979742631, -122.438585027382)
41931 204135 2 12 700 Junipero Serra Blvd 114 4 1 1     1 Width 0ft   5991224.97526 2091857.93043 37.72333901327 -122.47247476549299 (37.72333901327, -122.472474765493)
42115 192437 2 44 106 Langton St 2 4 1 1     1 Width 3ft   6010237.3697 2110691.53515 37.7761340485805 -122.40807976548099 (37.7761340485805, -122.408079765481)
43246 247776 2 35 228 30th St 1 4 1 1     1 Width 3ft   6005091.07435 2098463.74529 37.7422699303121 -122.425011997728 (37.7422699303121, -122.425011997728)
43525 250638 2 37 2609 Lake St 1 4 1 1     1 Width 3ft   5987350.36914 2114602.8431 37.7855653557873 -122.487538422371 (37.7855653557873, -122.487538422371)
43967 221664 2 175 65 McCoppin St 1 4 1 1     1 Width 5ft   6006280.59621 2109108.9089099998 37.771566201261294 -122.421654898657 (37.7715662012613, -122.421654898657)
44312 211400 2 108 500 Junipero Serra Blvd 59 4 1 1     1 Width 0ft   5991311.81969 2093306.95297 37.727322695173605 -122.472280141417 (37.7273226951736, -122.472280141417)
44650 200395 2 11 460 Bryant St 7 4 1 1     1 Width 3ft   6014040.62231 2112770.68821 37.782055142674 -122.395068857958 (37.782055142674, -122.395068857958)
45125 193342 2 88 401 Texas St 4 4 1 1     1 Width 3ft   6013812.69862 2105193.07398 37.7612360315304 -122.39532637971901 (37.7612360315304, -122.395326379719)
45491 198139 2 37 150 Bridgeview Dr 1 4 1 1     1 Width 3ft   6013283.18276 2095780.0515 37.735360415658704 -122.396497929253 (37.7353604156587, -122.396497929253)
45625 211202 2 3 700 Junipero Serra Blvd 146 4 1 1     1 Width 0ft   5991184.50895 2091529.2933900002 37.722434315083 -122.472590699819 (37.722434315083, -122.472590699819)
47689 189251 2 49 120 Loomis St 1 4 1 1     1 Width 4ft   6010844.92077 2097998.29295 37.7413152397136 -122.405084094075 (37.7413152397136, -122.405084094075)
47982 212845 2 168 459 Victoria St 1 4 1 1     1 Width 3ft   5993232.298140001 2090226.8914 37.7189765558014 -122.465417457153 (37.7189765558014, -122.465417457153)
48234 196302 2 16 271 Shipley St 1 4 1 1     1 Width 5ft   6011407.60626 2111629.45684 37.7787748169373 -122.404097603449 (37.7787748169373, -122.404097603449)
48237 205333 2 141 10 Caine Ave 15 4 1 1     1 Width 0ft   5997549.343280001 2089570.2528799998 37.717421611803495 -122.45044787838002 (37.7174216118035, -122.45044787838)
48713 197355 2 232 10 Cargo Way 1 4 1 1     1 Width 3ft   6018943.2735 2097519.21753 37.740449188069896 -122.37704929319099 (37.7404491880699, -122.377049293191)
48966 196545 2 237 938 Rhode Island St 1 4 1 1     1 Width 4ft   6011854.06587 2104027.62304 37.7579268348784 -122.40201856510599 (37.7579268348784, -122.402018565106)
49055 235713 2 16 2828 18th St 1 4 1 1     1 Width 3ft   6009324.87579 2105481.33415 37.7617769099015 -122.410868274463 (37.7617769099015, -122.410868274463)
49434 247805 2 44 488 30th St 2 4 1 1     1 Width 3ft   6003450.91279 2098365.25645 37.741906717527705 -122.43067614380199 (37.7419067175277, -122.430676143802)
50112 250548 2 22 120 El Camino Del Mar 3 4 1 1     1 Width 4ft   5988224.68514 2115371.29245 37.787726251325395 -122.484569968025 (37.7877262513254, -122.484569968025)
50394 190425 2 44 1300 Evans Ave 23 4 1 1     1 Width 3ft   6017693.17965 2097070.35958 37.739147779140396 -122.38134046861299 (37.7391477791404, -122.381340468613)
50519 201808 2 48 247 Friedell St 1 4 1 1     1 Width 6ft   6020927.8472 2093035.08257 37.7282457215548 -122.369877496672 (37.7282457215548, -122.369877496672)
50600 219079 2 44 2674 Ocean Ave 1 4 1 1     1 Width 3ft   5990725.25402 2095140.06488 37.7323219940584 -122.474441593613 (37.7323219940584, -122.474441593613)
51469 235709 2 16 2800 18th St 2 4 1 1     1 Width 3ft   6009468.56012 2105488.54947 37.7618047772022 -122.41037183521601 (37.7618047772022, -122.410371835216)
51729 176543 2 44 100 Panama St 6 4 1 1     1 Width 3ft   5992283.95996 2086838.07777 37.709616952417704 -122.468449043003 (37.7096169524177, -122.468449043003)
52316 190655 2 91 354 Arkansas St 1 4 1 1     1 Width 3ft   6012900.86657 2105367.98453 37.7616655423506 -122.398492314369 (37.7616655423506, -122.398492314369)
53305 208696 2 21 235 Bright St 1 4 1 1     1 Width 3ft   5993735.7088 2088773.5229599997 37.7150149747485 -122.46357195568399 (37.7150149747485, -122.463571955684)
53841 221665 2 175 415 Buchanan St 2 4 1 1     1 Width 6ft   6004608.713169999 2109961.56798 37.7738129784269 -122.427498793141 (37.7738129784269, -122.427498793141)
Powered by Datasette · Query took 30.401ms · Data source: data.sfgov.org