sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
543 224593 1 94 3131 16th St 1 1 1 1   01/02/1981 12:00:00 AM 13 Width 3ft Permit Number 18870 6005970.19181 2106649.76485 37.7647964691065 -122.42255383310801 (37.7647964691065, -122.422553833108)
547 224594 1 94 3133 16th St 1 1 1 1   01/02/1981 12:00:00 AM 14 Width 3ft Permit Number 18871 6005947.45622 2106648.2222599997 37.7647909508601 -122.42263236011001 (37.7647909508601, -122.42263236011)
855 251398 2 94 299 Townsend St 3 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
859 251396 2 94 299 Townsend St 1 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
881 251399 3 94 841 Columbus Ave 1 1 1 2       3x3   6008927.4869099995 2120274.72498 37.802373734427796 -122.413288863041 (37.8023737344278, -122.413288863041)
1492 224530 3 94 3055 24th St 1 1 1 2     19 Width 3ft   6008605.155040001 2102119.10209 37.752504601916 -122.413119756879 (37.752504601916, -122.413119756879)
1507 590 3 94 3049 24th St 1 1 1 2     12 3X3   6008590.89573 2102118.12773 37.7525011260356 -122.413168999261 (37.7525011260356, -122.413168999261)
1508 224531 1 94 3077 24th St 1 1 1 1     15 Width 3ft   6008520.36157 2102113.23947 37.752483743936 -122.413412573453 (37.752483743936, -122.413412573453)
1622 15770 1 94 4770 Mission St 3 1 1 1   06/29/2007 12:00:00 AM 3 3X3   6001421.7162 2091049.3752 37.721703820816394 -122.43716874658399 (37.7217038208164, -122.437168746584)
1705 251397 2 94 311 Townsend St 5 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
1961 224699 3 94 3230 24th St 1 1 1 2     18 Width 3ft   6007526.74961 2102095.6735900003 37.7523796734842 -122.416847415286 (37.7523796734842, -122.416847415286)
1962 224700 3 94 3230 24th St 2 1 1 2     20 Width 3ft   6007513.40637 2102105.84325 37.7524068465217 -122.416894278962 (37.7524068465217, -122.416894278962)
1970 224702 3 94 3236 24th St 1 1 1 2     19 Width 3ft   6007468.557569999 2102099.5649099997 37.752387084812604 -122.417048929078 (37.7523870848126, -122.417048929078)
2011 224701 3 94 3230 24th St 3 1 1 2     17 Width 3ft   6007503.74003 2102097.0446900004 37.7523821439458 -122.416927083514 (37.7523821439458, -122.416927083514)
2012 224703 3 94 3236 24th St 2 1 1 2     20 Width 3ft   6007440.93162 2102096.08231 37.7523759682811 -122.417144217627 (37.7523759682811, -122.417144217627)
2123 128055 2 94 449 North Point St 3 1 1 1   06/23/2017 12:00:00 AM 3 Width 3ft Permit Number 780354 6008758.87824 2121765.85838 37.8064585449799 -122.413977880988 (37.8064585449799, -122.413977880988)
2216 122752 3 94 693 Vermont St 6 1 1 4 2   18     6011278.80569 2105286.3398 37.7613508668666 -122.404096651066 (37.7613508668666, -122.404096651066)
2223 43305 3 94 693 Vermont St 10 1 1 4 2 07/12/2000 12:00:00 AM 6   Permit Number 43072 6011285.67007 2105193.27319 37.7610957103087 -122.4040663601 (37.7610957103087, -122.4040663601)
2231 122750 3 94 693 Vermont St 8 1 1 4 2   9     6011285.1392 2105241.4016400003 37.761227830607204 -122.40407158333299 (37.7612278306072, -122.404071583333)
2233 122749 3 94 693 Vermont St 9 1 1 4 2   5     6011285.506709999 2105214.92948 37.761155164510605 -122.404068449214 (37.7611551645106, -122.404068449214)
3854 244051 2 94 401 Cole St 1 1 1 1     10 Width 0ft   5997898.1905 2109198.4158 37.7713357252186 -122.450656427551 (37.7713357252186, -122.450656427551)
4239 244052 2 94 401 Cole St 2 1 1 1     11 Width 0ft   5997900.6668 2109181.4943 37.771289404865 -122.450646641766 (37.771289404865, -122.450646641766)
4385 224618 4 94 165 Sussex St 1 1 1 2     13 Width 3ft Permit Number 780743 6001936.24436 2096476.10277 37.7366336128599 -122.435778235198 (37.7366336128599, -122.435778235198)
5520 37970 1 94 602 Peninsula Ave 1 1 1 1   07/08/1998 12:00:00 AM     Permit Number 40200          
5741 64939 1 94 1904 Filbert St 3 1 1 1   03/24/1989 12:00:00 AM 14 4x9 Permit Number 25968 6003770.598230001 2119034.75591 37.798678227572 -122.431045672521 (37.798678227572, -122.431045672521)
7271 23546 3 94 2805 Van Ness Ave 1 1 1 2     12 3X3   6005607.92942 2120044.70688 37.801555234346104 -122.424759800825 (37.8015552343461, -122.424759800825)
9698 173643 2 94 657 Howard St 4 1 1 1       3x3   6012793.0 2114089.0 37.78560546361629 -122.39947767317301 (37.7856054636163, -122.399477673173)
9737 173681 2 94 125 Rutledge St 1 1 1 1       3x3   6010317.0 2099454.0 37.7452827689443 -122.40701204748301 (37.7452827689443, -122.407012047483)
9802 173694 2 94 201X Stevenson St 1 1 1 1       3x3   6011772.0 2114653.0 37.7870971135768 -122.40304974212799 (37.7870971135768, -122.403049742128)
9838 68204 1 94 1110 York St 1 1 1 1 1 10/18/1993 12:00:00 AM 16 3x3 Permit Number 32363 6009978.53990017 2102725.22931804 37.754245896491604 -122.408413088762 (37.7542458964916, -122.408413088762)
9891 173730 2 94 387 Joost Ave 1 1 1 1       3x3   5999535.0 2094919.0 37.7322214835803 -122.443968498715 (37.7322214835803, -122.443968498715)
11311 25396 1 94 945 Geneva Ave 1 1 1 1     15 3X3   6000465.251630001 2089064.76788 37.7162001220051 -122.440332727576 (37.7162001220051, -122.440332727576)
11475 13369 1 94 900 Mansell St 2 1 1 1     9 3X50   6009189.31279 2090017.3428599997 37.71930856033371 -122.410245275395 (37.7193085603337, -122.410245275395)
11743 28251 3 94 3340 San Bruno Ave 1 1 1 2     12 2X3   6011988.71606 2089960.7357 37.7193096502899 -122.40056475438101 (37.7193096502899, -122.400564754381)
12464 111889 2 94 142 Wayland St 1 1 1 1     9 3x3   6011076.19973 2092521.5640200002 37.72629022399121 -122.40389910598302 (37.7262902239912, -122.403899105983)
12579 28252 3 94 3342 San Bruno Ave 1 1 1 2     12 2X3   6011993.05449 2089944.3685299999 37.7192649513087 -122.40054860885598 (37.7192649513087, -122.400548608856)
13606 6798 3 94 1375 Fairfax Ave 7 1 1 2     18 3x9   6016915.23611 2097187.56543 37.7394266247399 -122.38403843113701 (37.7394266247399, -122.384038431137)
13913 26001 1 94 1711 Oakdale Ave 1 1 1 1     6 3X3   6014400.39468 2095925.2599900002 37.735821239067796 -122.392645436853 (37.7358212390678, -122.392645436853)
14200 26002 1 94 1711 Oakdale Ave 2 1 1 1     6 3X3   6014429.78226 2095903.68978 37.7357636437757 -122.392542323281 (37.7357636437757, -122.392542323281)
16498 26003 1 94 1711 Oakdale Ave 3 1 1 1     6 3X3   6014451.27252 2095887.995 37.7357217425631 -122.39246692501999 (37.7357217425631, -122.39246692502)
16901 16914 3 94 483 Oak St 1 1 1 2     12 3X3   6004697.20239 2110157.0841200002 37.77435482265879 -122.427206624104 (37.7743548226588, -122.427206624104)
16905 26220 3 94 765X San Jose Ave 1 1 1 2     18 3x3   6005701.2867 2098677.11468 37.7428902448864 -122.422917229343 (37.7428902448864, -122.422917229343)
16957 5672 3 94 1422 Dolores St 1 1 1 2     14 3x3   6005185.06241 2100046.61651 37.7466214421279 -122.424799598532 (37.7466214421279, -122.424799598532)
16970 23100 3 94 1406 Valencia St 2 1 1 2     27 3X3   6006427.47457 2101357.7543900004 37.7502916230775 -122.42059651712098 (37.7502916230775, -122.420596517121)
17077 551 3 94 2900 24th St 1 1 1 2     18 3x3   6009445.64374 2102206.2231799997 37.752790964934704 -122.41021934346 (37.7527909649347, -122.41021934346)
17117 625 1 94 3160 24th St 1 1 1 1     20 4x6   6007920.1411 2102115.05717 37.7524550160009 -122.415488371495 (37.7524550160009, -122.415488371495)
17131 5742 3 94 1755 Dolores St 1 1 1 2     80 3X3   6005373.18109 2098196.81653 37.741552935912 -122.424017580443 (37.741552935912, -122.424017580443)
17222 3468 3 94 3231 24th St 1 1 1 2     15 4x4   6007477.096919999 2102052.55322 37.752258481762 -122.41701606785601 (37.752258481762, -122.417016067856)
17372 552 3 94 2904 24th St 1 1 1 2     18 3X3   6009418.497 2102204.07854 37.7527835545272 -122.41031307080699 (37.7527835545272, -122.410313070807)
17377 12244 3 94 401X Oak St 1 1 1 2     30 3X3   6005028.531359999 2110211.81183 37.7745238232573 -122.426064391571 (37.7745238232573, -122.426064391571)
17445 16902 3 94 427 Oak St 1 1 1 2     18 3X3   6004930.51635 2110189.46412 37.7744569217764 -122.42640185318899 (37.7744569217764, -122.426401853189)
17601 577 3 94 3024 24th St 1 1 1 2     18 3x3   6008801.63126 2102168.54838 37.752651398249604 -122.41244380126301 (37.7526513982496, -122.412443801263)
17610 24602 1 94 419 Cortland Ave 1 1 1 1     12 3X3   6007254.49022 2097303.30919 37.7392055992492 -122.41744932972401 (37.7392055992492, -122.417449329724)
17762 24449 3 94 1156 Valencia St 4 1 1 2     25 3X3   6006348.4307699995 2102831.95647 37.7543349884778 -122.420974512988 (37.7543349884778, -122.420974512988)
17807 640 1 94 3214 24th St 1 1 1 1     18 3X3   6007574.72227 2102100.08892 37.7523944952223 -122.41668183031601 (37.7523944952223, -122.416681830316)
17817 643 1 94 3224 24th St 1 1 1 1     18 3x3   6007548.56119 2102101.97423 37.752398200442 -122.41677243341199 (37.752398200442, -122.416772433412)
17857 66830 1 94 393 Douglass St 1 1 1 1 1 11/06/1991 12:00:00 AM     Permit Number 30127 6001175.80343985 2104102.01378806 37.7575293253254 -122.43895374638201 (37.7575293253254, -122.438953746382)
17916 587 3 94 3041 24th St 1 1 1 2     12 3x3   6008724.79045 2102125.26547 37.7525282406021 -122.41270647162202 (37.7525282406021, -122.412706471622)
17973 61740 1 94 219 Clipper St 1 1 1 1 1 12/15/1984 12:00:00 AM     Permit Number 21745 6003738.99947337 2100964.64707663 37.7490603587459 -122.42986540291099 (37.7490603587459, -122.429865402911)
17978 59647 1 94 100 Fillmore St 1 1 1 1 1 05/05/1987 12:00:00 AM   6x9 Permit Number 24228 6003848.70238053 2108788.55742661 37.770549162658895 -122.43004409806002 (37.7705491626589, -122.43004409806)
18006 26514 1 94 2880 Harrison St 1 1 1 1     18 3X3   6008952.92902 2101706.37447 37.7513908617048 -122.411887928494 (37.7513908617048, -122.411887928494)
18141 24446 3 94 1156 Valencia St 1 1 1 2     25 3X3   6006345.52984 2102866.64807 37.754430080088895 -122.420987008139 (37.7544300800889, -122.420987008139)
18228 633 3 94 3182 24th St 1 1 1 2     20 3x3   6007808.47554 2102110.59584 37.7524364890666 -122.415874214834 (37.7524364890666, -122.415874214834)
18232 630 1 94 3176 24th St 1 1 1 1     22 3x3   6007837.40103 2102111.35303 37.752440194268395 -122.41577423901501 (37.7524401942684, -122.415774239015)
18462 623 1 94 3158 24th St 1 1 1 1     20 3x3   6007941.8237 2102115.0630200002 37.7524562507759 -122.415413389641 (37.7524562507759, -122.415413389641)
18516 580 3 94 3013 24th St 2 1 1 2     18 3x3   6008848.9981 2102129.16474 37.7525459176681 -122.412277214445 (37.7525459176681, -122.412277214445)
18629 23094 1 94 1384 Valencia St 1 1 1 1   02/01/1992 12:00:00 AM 3 3x3   6006412.34173 2101544.72785 37.750804156590206 -122.42066211905701 (37.7508041565902, -122.420662119057)
18661 598 1 94 3070 24th St 1 1 1 1     23 3x3   6008489.074019999 2102147.94889 37.75257729142999 -122.41352322603399 (37.75257729143, -122.413523226034)
18722 576 3 94 3008 24th St 1 1 1 2     18 3x3   6008852.23919 2102169.31321 37.7526563382221 -122.412268843556 (37.7526563382221, -122.412268843556)
18768 622 3 94 3150 24th St 1 1 1 2     21 3x3   6007969.891890001 2102118.08704 37.7524661316063 -122.415316538925 (37.7524661316063, -122.415316538925)
19035 5708 3 94 1603 Dolores St 1 1 1 2     80 3X3   6005329.17263 2098980.1167599997 37.743701215741794 -122.424225442544 (37.7437012157418, -122.424225442544)
19276 108963 2 94 2395x 15TH ST 3 1 1 1 1         6001858.0 2107008.0 37.7655472468341 -122.436802461881 (37.7655472468341, -122.436802461881)
19320 5332 1 94 125 Dolores St 1 1 1 1     90 6x7   6004849.91389 2107615.9681599997 37.7673861676625 -122.42649738994601 (37.7673861676625, -122.426497389946)
19453 1923 1 94 78 Berkeley Way 1 1 1 1     6 3x3   6001189.660619999 2097346.8097900003 37.7389819342562 -122.43842185440901 (37.7389819342562, -122.438421854409)
19544 24603 3 94 407 Cortland Ave 1 1 1 2     12 2X2   6007220.87336 2097309.53692 37.739220807683296 -122.41756600326401 (37.7392208076833, -122.417566003264)
19625 571 3 94 2970 24th St 2 1 1 2   07/30/2015 12:00:00 AM 12 3x3   6009054.006130001 2102184.0831400002 37.752708212935794 -122.411572138748 (37.7527082129358, -122.411572138748)
19766 5379 3 94 299 Dolores St 2 1 1 2     60 4X4   6004899.9834 2106715.40982 37.764916280383 -122.426260083162 (37.764916280383, -122.426260083162)
19840 60045 1 94 235 Laussat St 1 1 1 1 1 04/24/1986 12:00:00 AM     Permit Number 22998 6003601.05151902 2109138.05302848 37.7714947633279 -122.43092567098101 (37.7714947633279, -122.430925670981)
19855 602 3 94 3085 24th St 2 1 1 2     18 5x5   6008423.83472 2102105.59165 37.7524573245683 -122.413745839724 (37.7524573245683, -122.413745839724)
19861 656 1 94 3255X 24th St 4 1 1 5     12 4x4   6007336.00672 2102041.77073 37.7522209377618 -122.41750321711099 (37.7522209377618, -122.417503217111)
19889 597 3 94 3067 24th St 1 1 1 2     18 3x3   6008545.44191 2102115.03145 37.7524900724667 -122.41332596783998 (37.7524900724667, -122.41332596784)
19935 613 3 94 3124 24th St 1 1 1 2     20 3X3   6008177.96308 2102131.82169 37.7525155358782 -122.41459796353998 (37.7525155358782, -122.41459796354)
19950 5335 3 94 149 Dolores St 1 1 1 2     90 6X8   6004854.459 2107562.68516 37.7672401222731 -122.42647787465 (37.7672401222731, -122.42647787465)
19961 600 1 94 3078 24th St 1 1 1 1     21 3x3   6008460.582 2102146.28241 37.7525711157729 -122.41362163882401 (37.7525711157729, -122.413621638824)
20011 644 3 94 3245 24th St 1 1 1 2     12 3x3   6007452.42683 2102052.29911 37.75225639624 -122.41710136313101 (37.75225639624, -122.417101363131)
20031 5670 1 94 1416 Dolores St 1 1 1 1     16 3x3   6005182.49595 2100071.1312 37.7466886088884 -122.424810216828 (37.7466886088884, -122.424810216828)
20042 24448 3 94 1156 Valencia St 3 1 1 2     18 3X3   6006348.61536 2102840.94797 37.7543596874688 -122.420974512988 (37.7543596874688, -122.420974512988)
20104 26548 3 94 3085 24th St 4 1 1 2     18 3X3   6008470.90767 2102107.16108 37.752464277228 -122.41358316405399 (37.752464277228, -122.413583164054)
20129 642 1 94 3225 24th St 1 1 1 1     18 4x4   6007512.22413 2102054.36572 37.7522654344184 -122.416894720512 (37.7522654344184, -122.416894720512)
20144 16900 3 94 409 Oak St 1 1 1 2     18 3X3   6005007.3916 2110203.70331 37.774500364432505 -122.426136940772 (37.7745003644325, -122.426136940772)
20158 605 1 94 3098 24th St 1 1 1 1     20 3x3   6008383.72095 2102142.9064 37.752557529712895 -122.41388719964701 (37.7525575297129, -122.413887199647)
20206 5338 3 94 158 Dolores St 1 1 1 2     18 5x5   6004769.98156 2107435.4149 37.766885892799 -122.426761005535 (37.766885892799, -122.426761005535)
20211 5689 3 94 1535 Dolores St 1 1 1 2     90 3X3   6005306.00348 2099419.02782 37.74490505722029 -122.424336766952 (37.7449050572203, -122.424336766952)
20213 5371 3 94 266 Dolores St 1 1 1 2     14 6x6   6004805.70542 2106808.5131599996 37.765166590486395 -122.42659279722 (37.7651665904864, -122.42659279722)
20215 24447 3 94 1156 Valencia St 2 1 1 2     25 3X3   6006347.0218400005 2102851.3253900004 37.754388091646 -122.420980760555 (37.754388091646, -122.420980760555)
20356 620 1 94 3145 24th St 1 1 1 1     18 3x3   6008061.58213 2102085.15012 37.752380847108604 -122.41499712672 (37.7523808471086, -122.41499712672)
20360 611 3 94 3108 24th St 1 1 1 2     18 3x3   6008224.09237 2102134.47643 37.752525416718 -122.41443862795799 (37.752525416718, -122.414438627958)
20372 65541 1 94 2146 Sutter St 1 1 1 1 1 03/20/1990 12:00:00 AM     Permit Number 28438 6002328.18536025 2114391.9672646 37.78584848917 -122.43570452929701 (37.78584848917, -122.435704529297)
20532 627 3 94 3168 24th St 1 1 1 2     21 3x3   6007870.94281 2102116.96374 37.752457485548796 -122.415658642859 (37.7524574855488, -122.415658642859)
20538 10222 3 94 1375-1377 Guerrero St 1 1 1 2     12 3x3   6005868.37697 2101019.32612 37.7493308512387 -122.422505871374 (37.7493308512387, -122.422505871374)
20570 554 3 94 2912X 24th St 1 1 1 2     12 3x3   6009391.31353 2102200.13523 37.7527712032402 -122.410406798162 (37.7527712032402, -122.410406798162)
Powered by Datasette · Query took 2.671ms · Data source: data.sfgov.org