sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
245 251255 2 17 4089x Alemany Blvd 1 1 1 1       3x3   5991686.0 2086822.0 37.7095382490701 -122.47051450746099 (37.7095382490701, -122.470514507461)
318 142205 1 17 1683 HAYES ST 1 1 1 1     3 Width 0ft Permit Number 779644 5999834.1012 2110180.6204 37.774143230926 -122.44403063203698 (37.774143230926, -122.444030632037)
427 251307 2 17 200 Cashmere St 1 13 1 1       3x3   6016315.0 2096328.0 37.7370332293639 -122.38605389871 (37.7370332293639, -122.38605389871)
588 251328 2 17 95x Tompkins Ave 2 1 1 1       3x3 Permit Number 779511 6007651.0 2096616.0 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695)
921 30278 1 17   1 1 1 1         Permit Number 128          
933 203966 2 17 200 Wawona St 1 1 1 1     3 Width 3ft Permit Number 779992 5992562.812059999 2097843.65033 37.739851654243296 -122.46828540055901 (37.7398516542433, -122.468285400559)
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)
2059 173596 6 17 200 Howard St 1 9 1 1       3x3 Permit Number 779179 6014439.0 2115766.0 37.790301726009204 -122.393900378517 (37.7903017260092, -122.393900378517)
2228 167815 2 17 282 Waller St 1 1 1 1     0 Width 3ft Permit Number 780344 6004374.21371 2109126.69451 37.771507353225395 -122.42825045191799 (37.7715073532254, -122.428250451918)
2470 211684 2 17 95 Miramar Ave 1 1 1 1     10 3x3 Permit Number 780277 5995309.61761 2090529.04665 37.719925789337296 -122.458258879737 (37.7199257893373, -122.458258879737)
2476 212596 2 17 310 Faxon Ave 1 1 1 1     6 Width 3ft Permit Number 780017 5994766.80041 2090657.2902900001 37.7202467087903 -122.46014448379299 (37.7202467087903, -122.460144483793)
2478 211685 2 17 95 Miramar Ave 2 1 1 1     10 3x3 Permit Number 780277 5995307.7579 2090507.37878 37.7198661876486 -122.458263740606 (37.7198661876486, -122.458263740606)
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)
2497 252857 2 17 124 Persia Ave 2 7 1 1       3x3 Permit Number 780172 6002102.0 2091308.0 37.7224525933916 -122.43483567372 (37.7224525933916, -122.43483567372)
2644 124734 1 17 999 Brannan St 3 1 1 1           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328)
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                    
5789 48478 1 17   6 1 1 1         Permit Number 45832          
6372 124739 1 17 999 Brannan St 8 1 1 1           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328)
6539 48476 1 17   8 1 1 1         Permit Number 45832          
6689 34917 1 17   7 1 1 1         Permit Number 38517          
6769 124735 1 17 999 Brannan St 4 1 1 1           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328)
6922 48488 1 17   5 1 1 1         Permit Number 45832          
6984 34915 1 17   9 1 1 1         Permit Number 38517          
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)
7310 48473 1 17   11 1 1 1         Permit Number 45832          
7352 48471 1 17   15 1 1 1         Permit Number 45832          
7602 124740 1 17 999 Brannan St 9 1 1 1           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328)
7891 48474 1 17   10 1 1 1         Permit Number 45832          
8467 56665 1 17 4549 Callan Blvd 1 1 1 1                    
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)
9042 27384 3 17 2200 Hyde St 1 1 1 2     3 3X3 Permit Number 779236 6007162.48532 2119880.42159 37.801191826388504 -122.41936866015101 (37.8011918263885, -122.419368660151)
9613 34916 1 17   8 1 1 1         Permit Number 38517          
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)
10027 122385 2 17 1642 17th Ave 1 1 1 1 1     3x3 Permit Number 778904 5990935.0 2104213.0 37.7572460781285 -122.474378311379 (37.7572460781285, -122.474378311379)
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)
10150 105688 2 17 635 08TH ST 2 1 1 1     14 4x4 Permit Number 771004 6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597)
10152 105682 2 17 899X BRANNAN ST 2 1 1 1     14 4x4 Permit Number 771004 6011295.0 2109227.0 37.7721719324444 -122.40431801309799 (37.7721719324444, -122.404318013098)
10169 105680 2 17 620 07TH ST 2 1 1 1     12 4x3 Permit Number 771004 6011709.5 2109428.5 37.7727483590072 -122.402898388879 (37.7727483590072, -122.402898388879)
10176 105681 2 17 899X BRANNAN ST 3 1 1 1     14 4x4 Permit Number 771004 6011295.0 2109227.0 37.7721719324444 -122.40431801309799 (37.7721719324444, -122.404318013098)
10188 105683 2 17 899X BRANNAN ST 1 1 1 1     14 4x4 Permit Number 771004 6011295.0 2109227.0 37.7721719324444 -122.40431801309799 (37.7721719324444, -122.404318013098)
10189 105689 2 17 635 08TH ST 3 1 1 1     12 4x4 Permit Number 771004 6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597)
10198 105687 2 17 635 08TH ST 1 1 1 1     15 4x4 Permit Number 771004 6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597)
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)
10573 34914 1 17   6 1 1 1         Permit Number 38517          
10631 97353 1 17   3 14 1 1                    
10680 48485 1 17   14 1 1 1         Permit Number 45832          
10892 112910 2 17 1899X Beach St 3 1 1 1                    
10982 34919 1 17   5 1 1 1         Permit Number 38517          
11641 96232 1 17     1 2 1                    
12108 48475 1 17   9 1 1 1         Permit Number 45832          
12163 48472 1 17   13 1 1 1         Permit Number 45832          
12550 48469 1 17   2 1 1 1         Permit Number 45832          
12744 56667 1 17 495 Callan Blvd 1 1 1 1                    
12938 34921 1 17   1 1 1 1         Permit Number 38517          
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)
13300 114607 2 17 2399X 15TH AVE 1 5 1 1     10   Permit Number 779471 5991654.0 2099150.0 37.7433860243849 -122.471522828523 (37.7433860243849, -122.471522828523)
Powered by Datasette · Query took 35.555ms · Data source: data.sfgov.org