sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
89 251189 1 17 1493 Hudson Ave 1 1 1 1   03/22/2017 12:00:00 AM 3 3x3   6016267.45517 2096986.6643299998 37.7388391569445 -122.38626419104999 (37.7388391569445, -122.38626419105)
245 251255 2 17 4089x Alemany Blvd 1 1 1 1       3x3   5991686.0 2086822.0 37.7095382490701 -122.47051450746099 (37.7095382490701, -122.470514507461)
252 182864 3 17 1674 27th Ave 1 1 1 2   02/02/2016 10:49:00 AM 1 Width 0ft   5987818.6474 2103915.1987 37.7562473553988 -122.485133888104 (37.7562473553988, -122.485133888104)
427 251307 2 17 200 Cashmere St 1 13 1 1       3x3   6016315.0 2096328.0 37.7370332293639 -122.38605389871 (37.7370332293639, -122.38605389871)
1039 186954 3 17 2800 Sunset Blvd 28 3 1 2     2 Width 0ft   5985211.8854 2096092.27 37.734615522028896 -122.493572437422 (37.7346155220289, -122.493572437422)
1305 251497 2 17 329x Warren Dr 1 13 1 1       3x3   5994610.0 2103362.0 37.7551216790189 -122.461607123764 (37.7551216790189, -122.461607123764)
1483 251556 1 17 299 Clinton Park 3 1 1 1       3x3   6004847.0 2108161.0 37.7688825293039 -122.42654628279399 (37.7688825293039, -122.426546282794)
1486 251555 1 17 299 Clinton Park 4 1 1 1       3x3   6004847.0 2108161.0 37.7688825293039 -122.42654628279399 (37.7688825293039, -122.426546282794)
1501 251554 1 17 299 Clinton Park 2 1 1 1       3x3   6004847.0 2108161.0 37.7688825293039 -122.42654628279399 (37.7688825293039, -122.426546282794)
1510 251552 1 17 299 Clinton Park 1 1 1 1       3x3   6004847.0 2108161.0 37.7688825293039 -122.42654628279399 (37.7688825293039, -122.426546282794)
1659 251643 2 17 2701 Leavenworth St 1 1 1 1 1     3x3   6007328.0 2121670.0 37.8061148757045 -122.418922903139 (37.8061148757045, -122.418922903139)
1691 251656 2 17 31x Malta Dr 1 19 1 1       3x3   5999423.0 2096089.0 37.7354276387403 -122.44443976141001 (37.7354276387403, -122.44443976141)
1934 252840 4 17 80 Blake St 1 1 1 1       3x3   5997842.0 2113206.0 37.782336294689 -122.45113984781099 (37.782336294689, -122.451139847811)
1967 138282 3 17 1202 Golden Gate Ave 1 1 1 2     4 Width 0ft   6003789.8642 2112168.8213 37.7798272025121 -122.430488845982 (37.7798272025121, -122.430488845982)
1972 252849 2 17 200 Woodside Ave 1 5 1 1       3x3   5996376.0 2100052.0 37.7461347404292 -122.455260624993 (37.7461347404292, -122.455260624993)
2006 252850 2 17 2 Hernandez Ave 1 5 1 1       3x3   5996271.0 2100083.0 37.7462138338134 -122.45562593978599 (37.7462138338134, -122.455625939786)
2046 131756 2 17 1818 Broadway 3 1 1 1     11 Width 4ft   6004733.3748 2117781.6991 37.795292161346104 -122.427624834041 (37.7952921613461, -122.427624834041)
2482 245639 2 17 910 Shotwell St 1 1 1 1     19 Width 3ft   6007964.74692 2102552.0898 37.7536575156842 -122.415365052856 (37.7536575156842, -122.415365052856)
2644 124734 1 17 999 Brannan St 3 1 1 1           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328)
2687 253164 4 17 146 Cambridge St 1 8 1 1   07/27/2017 12:00:00 AM 3 4x4   6006598.94029 2094006.4119099998 37.7301161400075 -122.419482094225 (37.7301161400075, -122.419482094225)
2816 253217 1 17 301 Winding Way 1 1 1 1   08/08/2017 12:00:00 AM 3 3x3   6001651.75029 2086494.56012 37.7092103839364 -122.436047813177 (37.7092103839364, -122.436047813177)
2977 10292 3 17 488 Haight St 1 1 1 2     26 3x4   6003826.4075 2109393.9739 37.7722102257422 -122.43016441338301 (37.7722102257422, -122.430164413383)
3070 116407 1 17 600 Vallejo St 1 1 1 1     13     6010620.1417 2118945.4017 37.798818623722 -122.40733765055599 (37.798818623722, -122.407337650556)
3191 21648 3 17 1660 Sutter St 3 1 1 2     12 3X2   6004632.9541 2114713.0403 37.7868607185832 -122.427753554263 (37.7868607185832, -122.427753554263)
4002 253607 2 17 499x Natoma St 2 1 1 1       3x3   6010464.0 2112150.0 37.7801513385768 -122.407398630227 (37.7801513385768, -122.407398630227)
4085 101532 2 17 11323 Palou Ave 1 1 1 1       3x3            
4089 253606 2 17 499x Natoma St 1 1 1 1       3x3   6010464.0 2112150.0 37.7801513385768 -122.407398630227 (37.7801513385768, -122.407398630227)
4552 97357 1 17   7 14 1 1                    
4719 253672 3 17 390 06th St 4 1 1 2 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
4740 124733 1 17 999 Brannan St 2 1 1 1           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328)
4863 253702 2 17 293 Capp St 3 1 1 1       3x3   6007203.0 2105623.0 37.76204668432629 -122.41821705685899 (37.7620466843263, -122.418217056859)
4865 253699 2 17 3076 Market St 1 1 1 1       3x3   6000057.0 2105400.0 37.761029556529294 -122.44291621566002 (37.7610295565293, -122.44291621566)
4870 253696 2 17 235 Laussat St 1 1 1 1       Width 3ft   6003605.0 2109124.0 37.77145640087421 -122.430911009882 (37.7714564008742, -122.430911009882)
4871 253700 2 17 293 Capp St 1 1 1 1       3x3   6007203.0 2105623.0 37.76204668432629 -122.41821705685899 (37.7620466843263, -122.418217056859)
4913 97358 1 17   8 14 1 1                    
5210 83637 1 17 840 Ellis St 1 1 1 1 4 11/19/2005 12:00:00 AM   3x3   6006834.966315799 2113631.30048912 37.784014842491395 -122.420058290383 (37.7840148424914, -122.420058290383)
6372 124739 1 17 999 Brannan St 8 1 1 1           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328)
6769 124735 1 17 999 Brannan St 4 1 1 1           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328)
7004 124738 1 17 999 Brannan St 7 1 1 1           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328)
7011 97356 1 17   6 14 1 1                    
7040 97351 1 17   1 14 1 1                    
7186 124737 1 17 999 Brannan St 6 1 1 1           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328)
7602 124740 1 17 999 Brannan St 9 1 1 1           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328)
8467 56665 1 17 4549 Callan Blvd 1 1 1 1                    
8470 19243 1 17 709 Scott St 1 1 1 1   12/04/2007 12:00:00 AM 3 3x3   6002038.0023 2110993.4691 37.776500585825204 -122.436465151941 (37.7765005858252, -122.436465151941)
8657 97354 1 17   4 14 1 1                    
8812 124736 1 17 999 Brannan St 5 1 1 1           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328)
9037 169234 2 17 695 Minna St 1 1 1 1     1 3x3   6009012.0 2111041.0 37.7770249114115 -122.41234337077199 (37.7770249114115, -122.412343370772)
9920 173743 2 17 530 Molimo Dr 1 1 1 1       3x3   5997387.0 2097791.0 37.7399845403322 -122.45160167056801 (37.7399845403322, -122.451601670568)
9923 173740 2 17 2500X Lyon St 7 3 1 1       3x3   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9924 173738 2 17 2500X Lyon St 5 3 1 1       3x3   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
10010 173778 6 17 99X Cleveland St 1 18 1 1       3x3   6010549.0 2110746.0 37.7763010397716 -122.40700558704799 (37.7763010397716, -122.407005587048)
10133 173865 2 17 325 Berry St 1 1 1 1       3x3   6013725.0 2109678.0 37.77354576620421 -122.395943986686 (37.7735457662042, -122.395943986686)
10135 173864 2 17 300 Berry St 1 1 1 1       3x3   6013804.0 2109844.0 37.7740059597011 -122.39568234515801 (37.7740059597011, -122.395682345158)
10222 173923 3 17 2160X 09th Ave 11 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10224 173918 3 17 2160X 09th Ave 6 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10225 173920 3 17 2160X 09th Ave 8 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10227 173914 3 17 2160X 09th Ave 1 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10228 173922 3 17 2160X 09th Ave 10 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10230 173919 3 17 2160X 09th Ave 7 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10232 173916 3 17 2160X 09th Ave 4 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10233 173917 3 17 2160X 09th Ave 5 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10237 173915 3 17 2160X 09th Ave 3 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10238 173921 3 17 2160X 09th Ave 9 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10254 173937 1 17 4695 18th St 2 1 1 1           5999956.94577188 2105141.0371168 37.7603128035628 -122.44324365859501 (37.7603128035628, -122.443243658595)
10631 97353 1 17   3 14 1 1                    
10892 112910 2 17 1899X Beach St 3 1 1 1                    
11641 96232 1 17     1 2 1                    
12744 56667 1 17 495 Callan Blvd 1 1 1 1                    
13253 187616 2 17 55 Hawthorne St 1 1 1 1       3x3   6013035.0 2114021.0 37.785432237020004 -122.398635644163 (37.78543223702, -122.398635644163)
13257 187617 2 17 55 Hawthorne St 3 1 1 1       3x3   6013035.0 2114021.0 37.785432237020004 -122.398635644163 (37.78543223702, -122.398635644163)
14893 97355 1 17   5 14 1 1                    
16044 96231 1 17     1 2 1                    
16481 112908 2 17 1899X Beach St 1 1 1 1                    
16895 97352 1 17   2 14 1 1                    
16902 203214 2 17 603 Natoma St 1 1 1 1       3x3   6009653.0 2111431.0 37.778131708870504 -122.410153484475 (37.7781317088705, -122.410153484475)
16904 203215 2 17 603 Natoma St 2 1 1 1       3x3   6009653.0 2111431.0 37.778131708870504 -122.410153484475 (37.7781317088705, -122.410153484475)
17030 110785 1 17 2 Edna St 2 7 1 1   05/06/2015 12:00:00 AM 3     5998788.4 2092979.9 37.7268545527586 -122.446410203741 (37.7268545527586, -122.446410203741)
17039 97769 2 17 362 Capp St 1 1 1 1     15 3x3   6007113.7 2105238.5 37.7609859097905 -122.418498646119 (37.7609859097905, -122.418498646119)
17073 112909 2 17 1899X Beach St 2 1 1 1                    
17858 121173 6 17 950 Duncan St 2 7 1 1       3x3   6000333.0 2099683.0 37.7453477932295 -122.44155138616101 (37.7453477932295, -122.441551386161)
17986 56452 1 17 1471 43rd Ave 1 1 1 1           5982761.8650167 2105117.76871339 37.759253411371205 -122.50271069963001 (37.7592534113712, -122.50271069963)
17989 105356 2 17 207-211 San Jose Ave 1 1 1 1     3 3x3   6006236.0 2101921.0 37.7518273734539 -122.421298642673 (37.7518273734539, -122.421298642673)
18076 107933 3 17 3098X Market St 1 3 1 2           5999920.0 2105144.0 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916)
18486 106393 3 17 182x Lower Ter 20 11 1 2       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737)
18642 106966 2 17 2391 47TH AVE   1 1 1           5981720.8 2098834.4 37.7419398125124 -122.505845312535 (37.7419398125124, -122.505845312535)
18842 56690 1 17 55 Hallam St 1 1 1 1           6010204.858571201 2110471.70826771 37.775528634854496 -122.408176723323 (37.7755286348545, -122.408176723323)
18845 56735 1 17 4601 03rd St 1 1 1 1           6015154.58866017 2096112.48595754 37.736377180995206 -122.39005094503901 (37.7363771809952, -122.390050945039)
18922 100994 2 17 1675 Bryant St 6 1 1 1       3x3   6009464.0 2106858.0 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247)
19065 99574 2 17 650X Brunswick St 16 1 1 1     4 3x6   5998578.4 2086902.6 37.710155688278 -122.44669908653499 (37.710155688278, -122.446699086535)
19419 109892 1 17 205 Miramar Ave 1 1 1 1   03/09/2015 12:00:00 AM 3 3x6   5995308.1 2091295.6 37.722030475149495 -122.458319579925 (37.7220304751495, -122.458319579925)
19505 56567 1 17 309 San Fernando Way 1 1 1 1           5992136.3013071995 2094883.62123857 37.731699516032904 -122.46954466154499 (37.7316995160329, -122.469544661545)
19599 106501 2 17 1266 09TH AVE   1 1 1       3x6   5993358.0 2106830.8 37.764573953722 -122.46618893715001 (37.764573953722, -122.46618893715)
19603 56564 1 17 250 San Fernando Way 1 1 1 1           5992102.77849477 2095182.39763056 37.7325179438205 -122.46968229865699 (37.7325179438205, -122.469682298657)
20862 116132 2 17 1601X Armstrong Ave 4 1 1 3           6014258.08027 2092570.23406 37.726601114752604 -122.392902822978 (37.7266011147526, -122.392902822978)
20908 100993 2 17 1675 Bryant St 5 1 1 1       3x3   6009464.0 2106858.0 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247)
21195 116310 2 17 1599X Scott St 2 1 1 1           6001671.10835 2113777.6056 37.7841242646501 -122.43793380735399 (37.7841242646501, -122.437933807354)
22306 203218 3 17 865x Ocean Ave 1 1 1 2       3x3   5997430.0 2091537.0 37.722815009603295 -122.451002133856 (37.7228150096033, -122.451002133856)
22827 251129 2 17 32 Cross St 1 1 1 1   03/09/2017 12:00:00 AM 3 12x2   6000049.0 2088229.0 37.7138815826944 -122.441711543213 (37.7138815826944, -122.441711543213)
23155 543 3 17 2871 24th St 1 1 1 2     2 3X3   6009625.4825 2102172.3236 37.7527079631855 -122.409595033175 (37.7527079631855, -122.409595033175)
23938 248425 2 17 731 Clayton St 1 1 1 1     1 Width 0ft   5998544.0431 2108064.7106 37.7682598065536 -122.448340749888 (37.7682598065536, -122.448340749888)
Powered by Datasette · Query took 24.836ms · Data source: data.sfgov.org