sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
23396 218586 2 37 3666 19th Ave 1 2 1 1     1 Width 3ft   5990534.77048 2091965.7217599999 37.7235950079882 -122.474868513494 (37.7235950079882, -122.474868513494)
23401 202171 2 16 20 Kalmanovitz St 3 2 1 1     8 Width 2ft   6013157.586080001 2093193.49557 37.7282512748665 -122.39675089323799 (37.7282512748665, -122.396750893238)
23402 123384 2 5 735 03rd Ave 3 2 1 1     15 Width 4ft   5995024.54572 2110548.53973 37.7748779041184 -122.460694283234 (37.7748779041184, -122.460694283234)
23409 218091 2 16 62 Eastwood Dr 1 2 1 1     4 Width 3ft   5995658.864080001 2092992.02847 37.726708612908 -122.45722974236601 (37.726708612908, -122.457229742366)
23417 183167 2 54 2422 45th Ave 1 2 1 1     0 Width 0ft   5982411.0498 2098597.3573 37.741329561902596 -122.50344114283101 (37.7413295619026, -122.503441142831)
23425 236043 2 26 821 Duboce Ave 1 2 1 1     16 Width 3ft   6001824.27489 2108233.40905 37.768910001429 -122.43700684760701 (37.768910001429, -122.437006847607)
23431 213073 2 16 50 Castenada Ave 3 2 1 1     7 Width 3ft   5994467.524230001 2101712.07423 37.7505832012692 -122.46198020334299 (37.7505832012692, -122.461980203343)
23444 201445 2 8 50 Middle Point Rd 5 2 1 1     4 Width 5ft   6018205.83588 2096062.22823 37.7364079387746 -122.379497902505 (37.7364079387746, -122.379497902505)
23445 222731 2 270 1435 Douglass St 3 2 1 1     4 Width 2ft   6001402.34337 2099545.22287 37.7450303552734 -122.437843913168 (37.7450303552734, -122.437843913168)
23447 140934 2 26 120 JORDAN AVE 2 2 1 1     9 Width 0ft   5996249.4558 2113606.8719 37.7833456744969 -122.456678312901 (37.7833456744969, -122.456678312901)
23448 121887 2 5 50 18th Ave 1 2 1 1     15 Width 5ft   5990232.62779 2114784.35142 37.78623140306821 -122.47758002792801 (37.7862314030682, -122.477580027928)
23452 207071 2 30 1927 08th Ave 3 2 1 1     11 Width 6ft   5993749.481269999 2102344.6615 37.752278758765605 -122.464509159894 (37.7522787587656, -122.464509159894)
23456 122922 2 160 2 11th Ave 7 2 1 1     7 Width 6ft   5992430.88304 2114907.16681 37.7866959384714 -122.469983652903 (37.7866959384714, -122.469983652903)
23481 218410 2 16 205 Castenada Ave 2 2 1 1     4 Width 0ft   5994280.90702 2100599.38004 37.7475172792951 -122.462544833698 (37.7475172792951, -122.462544833698)
23485 206309 2 60 226 Sadowa St 1 2 1 1     16 Width 3ft   5994744.569130001 2087779.6169999999 37.712344021541796 -122.46001297051599 (37.7123440215418, -122.460012970516)
23492 202174 2 75 100 Kalmanovitz St 1 2 1 1     21 Width 2ft   6013138.83373 2093054.0318599998 37.7278672922301 -122.39680594795401 (37.7278672922301, -122.396805947954)
23514 190971 2 47 800 Vermont St 11 2 1 1     42     6011272.24417 2104307.20268 37.7586620081736 -122.40405043579099 (37.7586620081736, -122.404050435791)
23523 208876 2 235 24 Sotelo Ave 2 2 1 1     2 Width 4ft   5993960.680430001 2101012.29566 37.7486325942246 -122.463682112736 (37.7486325942246, -122.463682112736)
23530 222049 2 12 201 Treat Ave 12 2 1 1     6 Width 6ft   6008976.23011 2107818.47181 37.768174596097104 -122.41223929451401 (37.7681745960971, -122.412239294514)
23531 212068 2 60 65 San Pablo Ave 1 2 1 1     19 Width 6ft   5994349.34377 2097659.88165 37.7394500943456 -122.46209504585501 (37.7394500943456, -122.462095045855)
23538 213933 2 82 2176 16th Ave 1 2 1 1     7 Width 3ft   5991344.08373 2100608.05246 37.7473715261751 -122.472700716564 (37.7473715261751, -122.472700716564)
23539 122063 2 163 5 17th Ave 2 2 1 1     7 Width 5ft   5990505.08019 2115005.32961 37.786853953760705 -122.476653573827 (37.7868539537607, -122.476653573827)
23557 213451 2 18 4 Cortes Ave 1 2 1 1     11 Width 3ft   5993177.52134 2099659.6696900004 37.7448734694269 -122.466291957027 (37.7448734694269, -122.466291957027)
23577 118033 2 141 89 Shore View Ave 1 2 1 1     17 Width 6ft   5984120.82492 2112822.3596099997 37.780487786596204 -122.498579960483 (37.7804877865962, -122.498579960483)
23592 218660 2 37 70 Eastwood Dr 2 2 1 1     14 Width 3ft   5995653.32428 2093064.51564 37.726907327111 -122.45725413468901 (37.726907327111, -122.457254134689)
23600 135193 2 15 35 Bay St 4 2 1 1     18 Width 8ft   6010885.4927900005 2121705.9799599997 37.806413341469 -122.40661408636801 (37.806413341469, -122.406614086368)
23638 179012 2 18 575 Lisbon St 3 2 1 1     2 Width 6ft   6001860.73543 2090148.2767900003 37.719254552441704 -122.435586742551 (37.7192545524417, -122.435586742551)
23640 218911 2 32 623 Laguna Honda Blvd 4 2 1 1     1 Width 4ft   5995731.43182 2099885.12493 37.745639539837605 -122.457477374284 (37.7456395398376, -122.457477374284)
23652 210826 2 41 62 Castenada Ave 4 2 1 1     1 Width 3ft   5994426.39557 2101510.85772 37.7500283438364 -122.462107837801 (37.7500283438364, -122.462107837801)
23683 250745 2 60 2850 Lake St 1 2 1 1     23 Width 4ft   5986584.92122 2114476.3273400003 37.7851733080538 -122.490177303062 (37.7851733080538, -122.490177303062)
23686 250437 2 2 95 Seacliff Ave 1 2 1 1     13 Width 4ft   5987583.4221 2115772.2854400002 37.7887898983715 -122.48681804471902 (37.7887898983715, -122.486818044719)
23689 185447 2 2 2400 Sunset Blvd 4 2 1 1     7 Width 0ft   5985080.5667 2098519.0396 37.7412710983901 -122.494205254183 (37.7412710983901, -122.494205254183)
23696 212999 2 16 1639 08th Ave 2 2 1 1     8 Width 4ft   5993681.9391 2104325.0016900003 37.7577123690443 -122.46488653520201 (37.7577123690443, -122.464886535202)
23722 206382 2 60 6 San Pablo Ave 3 2 1 1     8 Width 4ft   5994455.43125 2097793.85045 37.7398240468482 -122.46173795563601 (37.7398240468482, -122.461737955636)
23724 181665 2 54 1275 34th Ave 2 2 1 1     0 Width 0ft   5985511.3315 2106531.7973 37.7632971348656 -122.49330603001499 (37.7632971348656, -122.493306030015)
23735 213223 2 2 18 Lobos St 1 2 1 1     15     5996685.56427 2088703.70423 37.7149927956564 -122.45337101855101 (37.7149927956564, -122.453371018551)
23738 215457 2 119 170 Santa Ana Ave 2 2 1 1     5 Width 5ft   5992608.79004 2095578.76173 37.7336354943765 -122.467961730965 (37.7336354943765, -122.467961730965)
23761 123510 2 5 2714 Fulton St 1 2 1 1     19 Width 8ft   5994935.84099 2110268.0504400004 37.774102650784 -122.460980795496 (37.774102650784, -122.460980795496)
23763 194461 2 143 2000 25th St 3 2 1 1     27     6012563.257130001 2101880.94422 37.7520720792617 -122.399415164477 (37.7520720792617, -122.399415164477)
23769 133285 2 15 2800 Divisadero St 8 2 1 1     12 Width 6ft   6000622.64068 2117960.51369 37.7955497631676 -122.44186143746401 (37.7955497631676, -122.441861437464)
23775 250341 2 2 26 25th Ave 1 2 1 1     14 Width 3ft   5988236.1256800005 2115814.85446 37.7889448119981 -122.48456293444599 (37.7889448119981, -122.484562934446)
23777 183752 2 54 2287 27th Ave 1 2 1 1     0 Width 0ft   5987917.4443 2099749.9687 37.7448165037016 -122.484486720736 (37.7448165037016, -122.484486720736)
23791 245271 2 142 217 Ogden Ave 1 2 1 1     8 Width 4ft   6008459.65813 2096082.8630400002 37.7359222563084 -122.41319610842501 (37.7359222563084, -122.413196108425)
23835 182329 2 54 1501 34th Ave 1 2 1 1     0 Width 0ft   5985565.7361 2104954.3084 37.75896897093661 -122.493001657059 (37.7589689709366, -122.493001657059)
23876 218979 2 10 551 Junipero Serra Blvd 18 2 1 1     8 Width 3ft   5991462.95986 2093729.88952 37.7284927194476 -122.47178846497101 (37.7284927194476, -122.471788464971)
23886 134083 2 15 2500 Vallejo St 3 2 1 1     16 Width 4ft   6001536.65742 2117684.63588 37.7948443142773 -122.43867901012399 (37.7948443142773, -122.438679010124)
23888 209236 2 22 32 Malta Dr 9 2 1 1     13 Width 3ft   5999655.9462 2095979.13545 37.735139265160704 -122.443626491896 (37.7351392651607, -122.443626491896)
23898 246421 2 97 400 Duncan St 3 2 1 1     7 Width 4ft   6003840.654080001 2099855.1968900003 37.7460198226686 -122.429434772709 (37.7460198226686, -122.429434772709)
23904 122926 2 146 2 11th Ave 3 2 1 1     7 Width 6ft   5992433.415569999 2114874.23335 37.7866056586788 -122.46997249221701 (37.7866056586788, -122.469972492217)
23910 118018 2 141 492 37th Ave 2 2 1 1     5 Width 1ft   5984413.88926 2112528.9426700003 37.779699331346 -122.49754445899099 (37.779699331346, -122.497544458991)
23912 118028 2 237 51 Shore View Ave 1 2 1 1     7 Width 4ft   5984316.15967 2112798.24876 37.780433038793 -122.49790243493 (37.780433038793, -122.49790243493)
23915 201200 2 15 700 Folsom St 8 2 1 1     4 Width 0ft   6012679.9726 2113219.2905 37.7832111428923 -122.399807626404 (37.7832111428923, -122.399807626404)
23922 208951 2 103 440 Saint Francis Blvd 2 2 1 1     40 Width 10ft   5993021.57409 2096009.5815299999 37.734842246953896 -122.46656593187099 (37.7348422469539, -122.466565931871)
23926 181820 2 54 2299 Santiago St 1 2 1 1     0 Width 0ft   5985846.0311 2099546.7997 37.7441378151504 -122.491634223287 (37.7441378151504, -122.491634223287)
23936 211142 2 3 100 Terrace Dr 1 2 1 1     31     5993344.399119999 2096880.05499 37.7372509740365 -122.465513038912 (37.7372509740365, -122.465513038912)
23941 250276 2 15 43 United Nations Plz 17 2 1 1     12 Width 0ft   6008392.62375 2112125.224 37.7799671560941 -122.414562734397 (37.7799671560941, -122.414562734397)
23950 184234 2 2 1560 43rd Ave 2 2 1 1     4 Width 0ft   5982828.9188 2104533.9152 37.7576542549583 -122.502435587448 (37.7576542549583, -122.502435587448)
23953 211938 2 15 49 Marcela Ave 2 2 1 1     12 Width 4ft   5994751.80445 2100714.33163 37.747860014539704 -122.46092484170201 (37.7478600145397, -122.460924841702)
23989 206572 2 66 51 Cortes Ave 4 2 1 1     7 Width 3ft   5993215.16949 2099646.04946 37.7448382439064 -122.466160788211 (37.7448382439064, -122.466160788211)
24024 206902 2 47 901 Monterey Blvd 4 2 1 1     6 Width 3ft   5996057.83075 2094626.65779 37.7312198182223 -122.45596865725 (37.7312198182223, -122.45596865725)
24030 136773 2 37 3700 Clay St 1 2 1 1     1 Width 5ft   5997087.63405 2115382.9814299997 37.7882704886466 -122.453906871501 (37.7882704886466, -122.453906871501)
24031 206557 2 66 517 Laguna Honda Blvd 2 2 1 1     4 Width 4ft   5995503.23656 2100160.4413400004 37.7463823798599 -122.458286357642 (37.7463823798599, -122.458286357642)
24035 178607 2 15 0 Gonzalez Dr 1 2 1 1     2     5990327.66617 2089955.55198 37.7180635775375 -122.47543773036101 (37.7180635775375, -122.475437730361)
24044 219480 2 119 40 Santa Ana Ave 2 2 1 1     6 Width 8ft   5992573.35664 2096580.23843 37.736383252376704 -122.468157060102 (37.7363832523767, -122.468157060102)
24050 209682 2 22 1849 15th Ave 1 2 1 1     6 Width 3ft   5991553.31162 2102854.2151599997 37.7535510143851 -122.472140928188 (37.7535510143851, -122.472140928188)
24053 181971 2 54 2467 34th Ave 1 2 1 1     0 Width 0ft   5985787.1457 2098434.4072 37.7410800425161 -122.49175595946801 (37.7410800425161, -122.491755959468)
24061 190934 2 135 1101 25th St 1 2 1 1     2 Width 9ft   6015168.60212 2102024.17667 37.752610233591206 -122.390415424833 (37.7526102335912, -122.390415424833)
24069 204989 2 12 491 Ulloa St 1 2 1 1     7 Width 4ft   5995151.4003 2098200.0926599996 37.7409795263895 -122.459361016022 (37.7409795263895, -122.459361016022)
24081 183742 2 54 2278 25th Ave 1 2 1 1     0 Width 0ft   5988578.8889999995 2099828.4885 37.745070593746796 -122.482205348546 (37.7450705937468, -122.482205348546)
24085 212387 2 16 95 San Rafael Way 1 2 1 1     5 Width 6ft   5991919.26492 2095494.2164099999 37.7333635115101 -122.47033944313499 (37.7333635115101, -122.470339443135)
24094 118130 2 141 3329 Balboa St 2 2 1 1     4 Width 3ft   5985237.75106 2111079.5821 37.775768059624504 -122.494587526681 (37.7757680596245, -122.494587526681)
24097 177096 2 55 0 Serrano Dr 3 2 1 1     32     5989524.60255 2090740.4518099998 37.720172132521206 -122.47827090148199 (37.7201721325212, -122.478270901482)
24099 250414 2 2 39 Seacliff Ave 3 2 1 1     13 Width 4ft   5987974.43162 2115795.37764 37.788876091197096 -122.485466919461 (37.7888760911971, -122.485466919461)
24101 141230 2 39 16 COMMONWEALTH AVE 1 2 1 1     17 Width 0ft   5996536.7759 2114447.1732 37.7856694107907 -122.45574506618999 (37.7856694107907, -122.45574506619)
24106 246790 2 75 175 Brewster St 10 2 1 1     8     6010136.6415 2098750.10917 37.74333994367979 -122.40758608083901 (37.7433399436798, -122.407586080839)
24126 138818 2 15 723 Grove St 3 2 1 1     5 Width 0ft   6004379.6433 2111160.4787 37.7770919345009 -122.428376650964 (37.7770919345009, -122.428376650964)
24131 230898 2 22 11 Clarendon Ave 3 2 1 1     5 Width 2ft   5998114.42055 2104641.61422 37.758836276097796 -122.44958007486 (37.7588362760978, -122.44958007486)
24148 182529 2 54 1583 32nd Ave 1 2 1 1     0 Width 0ft   5986203.973999999 2104470.5925 37.7576781250927 -122.490758769583 (37.7576781250927, -122.490758769583)
24162 215566 2 46 250 Santa Paula Ave 3 2 1 1     3 Width 4ft   5993936.1007 2096327.5375 37.735768007292705 -122.463427186434 (37.7357680072927, -122.463427186434)
24170 206058 2 278 95 Marston Ave 3 2 1 1     7     5998836.80822 2093173.9716299998 37.727390192897 -122.44625681279899 (37.727390192897, -122.446256812799)
24183 175768 2 20 0 Gonzalez Dr 2 2 1 1     13     5989578.68884 2089185.3656400002 37.7159053925979 -122.47797031747801 (37.7159053925979, -122.477970317478)
24193 127237 2 32 1600 Broadway 3 2 1 1     17 Width 3ft   6001081.5481199995 2117269.05753 37.7936773440867 -122.440223932108 (37.7936773440867, -122.440223932108)
24206 181982 2 54 2479 31st Ave 1 2 1 1     0 Width 0ft   5986720.0054 2098392.2737 37.7410188327151 -122.488527415956 (37.7410188327151, -122.488527415956)
24210 243997 2 224 483 Valley St 13 2 1 1     15     6002856.13849 2099166.37305 37.7440726834043 -122.432789895044 (37.7440726834043, -122.432789895044)
24218 208954 2 103 600 Saint Francis Blvd 3 2 1 1     30 Width 8ft   5993495.97502 2095994.9515900002 37.7348294415148 -122.464924714122 (37.7348294415148, -122.464924714122)
24221 124585 2 108 3979 Washington St 1 2 1 1     7 Width 6ft   5995656.4760300005 2115464.7980400003 37.788412975773504 -122.458864334168 (37.7884129757735, -122.458864334168)
24227 203475 2 70 2357 16th Ave 1 2 1 1     8 Width 3ft   5991280.398630001 2099387.14513 37.7440155431828 -122.472831922275 (37.7440155431828, -122.472831922275)
24235 217813 2 51 198 Lee Ave 4 2 1 1     2 Width 3ft   5996579.91933 2091952.01212 37.7239058307663 -122.453970623549 (37.7239058307663, -122.453970623549)
24238 223314 2 197 737 Sanchez St 10 2 1 1     4 Width 3ft   6003692.0750400005 2104158.0805900004 37.7578261171073 -122.43025546792101 (37.7578261171073, -122.430255467921)
24251 201271 2 16 200 Kalmanovitz St 5 2 1 1     6 Width 2ft   6013058.71274 2092794.8909900002 37.7271512843849 -122.39706476744301 (37.7271512843849, -122.397064767443)
24275 184454 2 54 2153 48th Ave 1 2 1 1     0 Width 0ft   5981374.6331 2100381.1786 37.7461664541179 -122.507156946857 (37.7461664541179, -122.507156946857)
24278 183048 2 5 2600 20th Ave 4 2 1 1     8 Width 0ft   5990217.9332 2097368.8862 37.7384123615974 -122.47635825040301 (37.7384123615974, -122.476358250403)
24286 249978 2 137 13 Napier Ln 1 2 1 1     13 Width 0ft   6011650.66928 2120187.96882 37.8022880343123 -122.403859153579 (37.8022880343123, -122.403859153579)
24308 190929 2 135 1101 25th St 6 2 1 1     2 Width 9ft   6015301.73602 2102030.54675 37.752635108841 -122.389955465678 (37.752635108841, -122.389955465678)
24330 205383 2 141 64 Ventura Ave 1 2 1 1     6 Width 3ft   5994182.66644 2101796.2621 37.750797955763396 -122.46297136414101 (37.7507979557634, -122.462971364141)
24337 198558 2 46 1709 Newcomb Ave 1 2 1 1     7 Width 4ft   6014602.581680001 2096122.3818299999 37.73637372225429 -122.391960171423 (37.7363737222543, -122.391960171423)
24365 177331 2 21 230 Mansell St 1 2 1 1     3 Width 3ft   6011147.98766 2090617.26897 37.7210654327147 -122.403517019111 (37.7210654327147, -122.403517019111)
24378 124854 2 5 55 Casa Way 2 2 1 1     10 Width 3ft   6001534.02589 2121572.74926 37.8055198982766 -122.438966893034 (37.8055198982766, -122.438966893034)
24379 241475 2 37 939 Elizabeth St 1 2 1 1     5 Width 4ft   6000376.8686 2101955.8656599997 37.751591035515496 -122.441562769933 (37.7515910355155, -122.441562769933)
24381 205069 2 12 851 Junipero Serra Blvd 17 2 1 1     3 Width 3ft   5991341.17231 2091818.7337900002 37.723238113832004 -122.472070242354 (37.723238113832, -122.472070242354)
24385 221202 2 95 612 Douglass St 5 2 1 1     2 Width 3ft   6001183.09453 2102793.98455 37.75393820848979 -122.438834798788 (37.7539382084898, -122.438834798788)
Powered by Datasette · Query took 39.036ms · Data source: data.sfgov.org