sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
25716 135893 2 35 323 Marina Blvd 2 2 1 1     8     6001843.597519999 2121830.48703 37.806245186226505 -122.437914052191 (37.8062451862265, -122.437914052191)
74939 135892 2 35 323 Marina Blvd 1 2 1 1     7 Width 7ft   6001823.0897 2121828.5954400003 37.8062388262166 -122.437984887306 (37.8062388262166, -122.437984887306)
159197 44057 1 35 708 North Point St 1 1 1 1   10/19/2000 12:00:00 AM 7   Permit Number 43584 6007279.94096 2121616.88851 37.8059663388498 -122.419085450154 (37.8059663388498, -122.419085450154)
154849 135905 2 35 2843 Larkin St 13 9 1 1     3 Width 5ft   6006460.32075 2121020.9303099997 37.804283800830795 -122.42187952052099 (37.8042838008308, -122.421879520521)
137794 142584 2 35 2232 Mason St 3 1 1 1     12 Width 0ft   6008967.5673 2120856.1596 37.803972458794796 -122.41319130359699 (37.8039724587948, -122.413191303597)
49365 142583 2 35 2234 Mason St 2 1 1 1     13 Width 0ft   6008971.4462 2120841.4199 37.80393220502779 -122.41317683745301 (37.8039322050278, -122.413176837453)
136311 142582 2 35 2236 Mason St 1 1 1 1     15 Width 0ft   6008972.9977 2120827.456 37.8038939507527 -122.413170480356 (37.8038939507527, -122.413170480356)
179436 135891 2 35 2398 North Point St 3 9 1 1     2 Width 7ft   5999308.28669 2120504.72693 37.802460509893606 -122.44659245147301 (37.8024605098936, -122.446592451473)
52914 143052 2 35 700 LOMBARD ST 1 1 1 1     8 Width 0ft   6008958.7736 2120458.7538 37.8028807881226 -122.413193616152 (37.8028807881226, -122.413193616152)
171407 143053 2 35 700 LOMBARD ST 2 1 1 1     3 Width 0ft   6008940.2059 2120454.0688 37.8028668818708 -122.413257538683 (37.8028668818708, -122.413257538683)
3528 13088 1 35 722 Lombard St 1 1 1 1     45 3X3   6008925.6016 2120449.3844 37.802853199751794 -122.413307745784 (37.8028531997518, -122.413307745784)
7927 13089 1 35 722 Lombard St 2 1 1 1     60 3X3   6008909.0684 2120447.731 37.8028477316821 -122.41336484235 (37.8028477316821, -122.41336484235)
6874 13090 1 35 724 Lombard St 1 1 1 1   02/26/2004 12:00:00 AM 12 3X3   6008885.9219 2120447.4555 37.8028456756355 -122.413444921903 (37.8028456756355, -122.413444921903)
123299 143089 2 35 616 Greenwich St 2 1 1 1     7 Width 0ft   6009932.6738 2120241.3728 37.8023385404989 -122.409808052185 (37.8023385404989, -122.409808052185)
25980 143091 2 35 620 Greenwich St 4 1 1 1     11 Width 0ft   6009899.7854 2120236.6745 37.802323796980296 -122.409921530777 (37.8023237969803, -122.409921530777)
80847 51045 1 35 600X Greenwich St 2 1 1 1   07/08/2004 12:00:00 AM 8 3x3 Permit Number 47518 6009984.0 2120227.0 37.802301952574894 -122.4096294226 (37.8023019525749, -122.4096294226)
147146 142758 2 35 400 FILBERT ST 1 1 1 1     3 Width 0ft   6010864.8123 2120023.3634 37.80179213390711 -122.406567008949 (37.8017921339071, -122.406567008949)
184779 142759 2 35 400 FILBERT ST 2 1 1 1     2 Width 0ft   6010846.8046 2120020.1312 37.801782251607 -122.406629096352 (37.801782251607, -122.406629096352)
149261 142760 2 35 400 FILBERT ST 3 1 1 1     1 Width 0ft   6010826.0266 2120017.8226 37.8017747502564 -122.406700835434 (37.8017747502564, -122.406700835434)
170230 142761 2 35 400 FILBERT ST 4 1 1 1     2 Width 0ft   6010807.5572 2120014.5904 37.8017648420531 -122.406764520508 (37.8017648420531, -122.406764520508)
185222 142763 2 35 400 FILBERT ST 6 1 1 1     2 Width 0ft   6010767.3863 2120009.5113 37.8017486483835 -122.406903172911 (37.8017486483835, -122.406903172911)
23661 142764 2 35 400 FILBERT ST 7 1 1 1     2 Width 0ft   6010752.149 2120007.2027 37.801741456909596 -122.40695573845899 (37.8017414569096, -122.406955738459)
176542 135906 2 35 1178 Greenwich St 1 9 1 1     6 Width 10ft   6007265.472680001 2119876.0558700003 37.8011856390751 -122.41901196834 (37.8011856390751, -122.41901196834)
84774 31652 1 35 2066 Chestnut St 1 1 1 1   05/31/1995 12:00:00 AM     Permit Number 35162 6001931.34452098 2119821.7914856 37.8007348293225 -122.437466455186 (37.8007348293225, -122.437466455186)
41612 143115 3 35 1635 LOMBARD ST 1 1 1 2     8 Width 0ft   6004533.1119 2119761.6458 37.8007172577851 -122.42845896974801 (37.8007172577851, -122.428458969748)
143081 13118 3 35 1633 Lombard St 1 1 1 2     24 3X3   6004565.4050748 2119750.0667864 37.800687292153896 -122.428346396238 (37.8006872921539, -122.428346396238)
25373 60884 1 35 811 Filbert St 1 1 1 1 1 10/31/2013 12:00:00 AM 4   Permit Number 769979 6009011.35018 2119721.10568 37.8008583416072 -122.412959487805 (37.8008583416072, -122.412959487805)
114531 45712 1 35 2276 Chestnut St 1 1 1 1   09/28/2001 12:00:00 AM     Permit Number 44382 6000967.59952761 2119687.6743116 37.8003117407877 -122.440791778151 (37.8003117407877, -122.440791778151)
74159 135907 2 35 1034 Filbert St 2 1 1 1     14 Width 3ft   6007940.29606 2119623.01107 37.80052881831 -122.416658842755 (37.80052881831, -122.416658842755)
53803 250309 2 35 12 Redfield Aly 1 17 1 1     5 Width 0ft   6008474.46022 2119519.71704 37.800275226579 -122.414803097987 (37.800275226579, -122.414803097987)
183681 250308 2 35 10 Redfield Aly 1 13 1 1     4 Width 0ft   6008483.77451 2119506.40025 37.8002391853351 -122.41476992380801 (37.8002391853351, -122.414769923808)
74598 135903 2 35 8 Marion Pl 4 9 1 1     1     6008339.85894 2119440.03353 37.8000488717233 -122.41526322892 (37.8000488717233, -122.41526322892)
118168 135902 2 35 8 Marion Pl 3 9 1 1     2     6008341.98532 2119430.34352 37.8000223848775 -122.415255184482 (37.8000223848775, -122.415255184482)
105465 33331 1 35 1771 Greenwich St 1 1 1 1 1 10/01/2005 12:00:00 AM     Permit Number 37471 6004431.94596599 2119422.40230613 37.7997800572789 -122.428784847863 (37.7997800572789, -122.428784847863)
37561 135901 2 35 8 Marion Pl 2 9 1 1     3     6008342.534990001 2119419.33537 37.7999921901354 -122.415252502723 (37.7999921901354, -122.415252502723)
73827 142480 2 35 1656 POWELL ST 1 1 1 1     12 Width 0ft   6009655.9931 2119387.8477 37.799979462358706 -122.410705194848 (37.7999794623587, -122.410705194848)
145500 52532 1 35 1636@ UNION Powell St 1 1 1 1 1 12/28/2005 12:00:00 AM   5x5 Permit Number 48631 6009676.39438666 2119273.10665206 37.7996655555567 -122.410626491106 (37.7996655555567, -122.410626491106)
6496 23490 3 35 2500X Van Ness Ave 6 11 1 2     30 9   6005777.87956 2119177.1307599996 37.799182688783496 -122.424109961515 (37.7991826887835, -122.424109961515)
76848 135910 2 35 400 Vallejo St 3 2 1 1     8     6011521.095380001 2119068.1217 37.799205966851 -122.404228682307 (37.799205966851, -122.404228682307)
35260 135914 2 35 414 Vallejo St 2 2 1 1     8 Width 10ft   6011471.49553 2119063.8107 37.7991913582649 -122.404400012157 (37.7991913582649, -122.404400012157)
131299 135912 2 35 400 Vallejo St 5 2 1 1     6     6011493.6768 2119059.8121 37.7991816185927 -122.40432297534402 (37.7991816185927, -122.404322975344)
47397 135909 2 35 400 Vallejo St 1 2 1 1     6     6011530.70294 2119058.88107 37.79918113116 -122.40419478595501 (37.79918113116, -122.404194785955)
65666 135911 2 35 400 Vallejo St 4 2 1 1     10     6011511.78534 2119057.5389799997 37.7991763890443 -122.404260153176 (37.7991763890443, -122.404260153176)
146957 135913 2 35 414 Vallejo St 1 2 1 1     7     6011476.8778099995 2119044.52353 37.7991387011458 -122.404380029217 (37.7991387011458, -122.404380029217)
176610 135908 2 35 405 Vallejo St 1 2 1 1     7 Width 7ft   6011535.18315 2119025.39151 37.7990894272815 -122.40417692455 (37.7990894272815, -122.40417692455)
182711 91520 1 35 520 Vallejo St 1 1 1 1   05/06/2009 12:00:00 AM 3 3x3 Permit Number 52125 6011001.0511 2118999.3767 37.7989881374692 -122.406023377789 (37.7989881374692, -122.406023377789)
124420 52535 1 35 3148GREENWICH Steiner St 1 1 1 1   01/03/2006 12:00:00 AM     Permit Number 48634 6001945.28510554 2118977.8518821 37.79841838533729 -122.437357750068 (37.7984183853373, -122.437357750068)
54410 34473 1 35 1725 Taylor St 6 1 1 1   07/15/1997 12:00:00 AM 3   Permit Number 38203 6008692.20922 2118946.49843 37.7987135430497 -122.414009024508 (37.7987135430497, -122.414009024508)
70764 143340 2 35 1796 UNION ST 1 1 1 1     2 Width 0ft   6004433.9519 2118779.1956 37.798014090515 -122.42873202906 (37.798014090515, -122.42873202906)
92816 48417 1 35 2483 Filbert St 2 1 1 1 1 07/25/2002 12:00:00 AM     Permit Number 45795 6001088.95867007 2118610.64400879 37.7973614105806 -122.440294547032 (37.7973614105806, -122.440294547032)
98196 48416 1 35 2483 Filbert St 1 1 1 1 1 07/25/2002 12:00:00 AM     Permit Number 45795 6001088.95867007 2118610.64400879 37.7973614105806 -122.440294547032 (37.7973614105806, -122.440294547032)
75849 135904 2 35 1488 Vallejo St 1 1 1 1     2 Width 3ft   6006436.02999 2118364.9643599996 37.7969898223834 -122.421774812465 (37.7969898223834, -122.421774812465)
102102 108939 1 35 1801 Green St 1 1 1 14 3 01/13/2015 12:00:00 AM 3 3x3 Permit Number 774694 6004341.9 2118349.2 37.7968282226561 -122.42901988134199 (37.7968282226561, -122.429019881342)
123029 116779 2 35 1031 BROADWAY 1 1 1 1   07/28/2016 12:00:00 AM 3 3x3   6008650.0 2118281.0 37.796883878440795 -122.41410797545099 (37.7968838784408, -122.414107975451)
105175 106857 1 35 2800 PIERCE ST 1 1 1 1   11/20/2014 12:00:00 AM 3   Permit Number 774210 6001545.0 2118180.0 37.7962049292866 -122.43868565610902 (37.7962049292866, -122.438685656109)
78260 108099 1 35 2390X Green St 1 5 1 1   11/20/2014 12:00:00 AM 3   Permit Number 774210 6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269)
105603 44525 1 35 1125 Pacific Ave 1 1 1 1 1 03/29/2001 12:00:00 AM     Permit Number 43825 6008743.61210523 2117943.22188109 37.7959616805463 -122.41376014990601 (37.7959616805463, -122.413760149906)
4145 113403 2 35 2052 Polk St 1 1 1 1     4 3x3   6006463.2485 2117908.2188 37.7957372487994 -122.42164817262501 (37.7957372487994, -122.421648172625)
4166 143128 2 35 2052 POLK ST 2 1 1 1     4 Width 0ft   6006467.2287 2117887.8753 37.795681615093 -122.421632954779 (37.795681615093, -122.421632954779)
103110 48786 1 35 1405 Taylor St 7 1 1 1   10/30/2002 12:00:00 AM     Permit Number 46040 6008874.44924411 2117680.29283989 37.7952470886304 -122.413288823995 (37.7952470886304, -122.413288823995)
113658 48787 1 35 1405 Taylor St 6 1 1 1   10/30/2002 12:00:00 AM     Permit Number 46040 6008874.44924411 2117680.29283989 37.7952470886304 -122.413288823995 (37.7952470886304, -122.413288823995)
176061 52828 1 35 750WASHINGTON Kearny St 2 1 1 1   06/06/2006 12:00:00 AM 2   Permit Number 48852 6011319.3348 2117592.1734 37.79514209381671 -122.404822878731 (37.7951420938167, -122.404822878731)
57208 52827 1 35 750WASHINGTON Kearny St 1 1 1 1   06/06/2006 12:00:00 AM 2 3x3 Permit Number 48852 6011323.0636 2117546.9613 37.7950181606921 -122.40480679182501 (37.7950181606921, -122.404806791825)
52553 249684 2 35 2400 Baker St 16 7 1 1     5     5999742.6330699995 2117264.679 37.793589001891796 -122.44485636243 (37.7935890018918, -122.44485636243)
54903 249683 2 35 2400 Baker St 15 7 1 1     5     5999743.16478 2117253.42108 37.7935581209611 -122.44485371304701 (37.7935581209611, -122.444853713047)
188711 249682 2 35 2400 Baker St 14 7 1 1     5     5999744.1267099995 2117244.44172 37.7935335209065 -122.444849738942 (37.7935335209065, -122.444849738942)
47858 142823 2 35 1742 POLK ST 2 10 1 1     1 Width 0ft   6006601.0091 2116911.6099 37.79300857718 -122.421100695716 (37.79300857718, -122.421100695716)
49057 142822 2 35 1742 POLK ST 1 10 1 1     1 Width 0ft   6006604.1049 2116897.4579 37.7929698938345 -122.421088978741 (37.7929698938345, -122.421088978741)
104672 64402 1 35 777 Stockton St 1 10 1 1 1 05/14/1988 12:00:00 AM     Permit Number 25247 6010475.1 2116722.1 37.792705858273294 -122.407682697096 (37.7927058582733, -122.407682697096)
127063 101446 1 35 777 Stockton St 5 10 1 1         Permit Number 25247 6010475.1 2116722.1 37.792705858273294 -122.407682697096 (37.7927058582733, -122.407682697096)
143083 101447 1 35 777 Stockton St 6 10 1 1         Permit Number 25247 6010475.1 2116722.1 37.792705858273294 -122.407682697096 (37.7927058582733, -122.407682697096)
118507 73592 1 35 600X Greenwich St 1 1 1 1   06/30/2009 12:00:00 AM 6 3x3 Permit Number 52275 6010586.0 2116213.0 37.7913141995862 -122.407263072094 (37.7913141995862, -122.407263072094)
128608 73572 1 35 600X Greenwich St 2 1 1 1   06/30/2009 12:00:00 AM 8 3x3 Permit Number 52275 6010586.0 2116213.0 37.7913141995862 -122.407263072094 (37.7913141995862, -122.407263072094)
142619 82029 1 35 600X Greenwich St 4 1 1 1   06/30/2009 12:00:00 AM 6 3x3 Permit Number 52275 6010586.0 2116213.0 37.7913141995862 -122.407263072094 (37.7913141995862, -122.407263072094)
4409 114730 1 35 2536 Clay St 1 1 1 1   10/11/2017 12:00:00 AM 3 3x3 Permit Number 780830 6002593.47602 2116148.5251 37.790686613557504 -122.43491236523899 (37.7906866135575, -122.434912365239)
99011 115564 6 35 3524 Jackson St 2 8 1 1       5x10   5997387.02929021 2116081.37513577 37.790205252620794 -122.452921449726 (37.7902052526208, -122.452921449726)
1998 135937 1 35 98 Spruce St 6 1 1 1   06/14/2017 12:00:00 AM 3 3x3 Permit Number 780098 5997052.02369 2116054.59656 37.7901125223289 -122.45407860247299 (37.7901125223289, -122.454078602473)
141940 66596 1 35 1166 Pine St 1 1 1 1 1 04/22/1991 12:00:00 AM 2   Permit Number 29789 6008318.17747093 2115921.39203862 37.79038633277379 -122.415089057915 (37.7903863327738, -122.415089057915)
4753 98088 3 35 2X Frank Norris St 1 1 1 4 2   3 3x3   6007178.15894 2115574.08384 37.7893685797349 -122.41900880992901 (37.7893685797349, -122.419008809929)
7387 98089 3 35 2X Frank Norris St 2 1 1 4 2   3 3x3   6007160.90241 2115572.1732 37.789362361841505 -122.41906838009899 (37.7893623618415, -122.419068380099)
2613 98090 3 35 2X Frank Norris St 3 1 1 4 2   3 3x3   6007144.43128 2115568.9527 37.7893525915946 -122.419125139911 (37.7893525915946, -122.419125139911)
92 98091 3 35 2X Frank Norris St 4 1 1 4 2   3 3x3   6007129.633230001 2115568.12393 37.789349482642606 -122.41917628075599 (37.7893494826426, -122.419176280756)
147223 135894 2 35 4 Frank Norris St 1 1 1 1     2 Width 2ft   6007011.71695 2115552.58868 37.7893001854156 -122.419583155654 (37.7893001854156, -122.419583155654)
188263 135895 2 35 4 Frank Norris St 2 1 1 1     2 Width 2ft   6007001.276269999 2115550.37651 37.7892935232365 -122.419619122234 (37.7892935232365, -122.419619122234)
172215 135896 2 35 4 Frank Norris St 3 1 1 1     2 Width 2ft   6006986.1238400005 2115548.09953 37.7892864176805 -122.419671386337 (37.7892864176805, -122.419671386337)
169565 135897 2 35 4 Frank Norris St 4 1 1 1     1 Width 2ft   6006972.61492 2115546.75932 37.7892819768225 -122.419718030565 (37.7892819768225, -122.419718030565)
56608 135898 2 35 12 Frank Norris St 1 1 1 1     3 Width 3ft   6006854.3438099995 2115529.77615 37.7892286821026 -122.420126029605 (37.7892286821026, -122.420126029605)
68414 135899 2 35 12 Frank Norris St 2 1 1 1     3 Width 3ft   6006839.2179 2115528.7927900003 37.7892251297772 -122.420178293706 (37.7892251297772, -122.420178293706)
52829 135900 2 35 12 Frank Norris St 3 1 1 1     3 Width 3ft   6006826.338330001 2115526.46894 37.7892180233479 -122.420222690545 (37.7892180233479, -122.420222690545)
5979 98098 2 35 81 Frank Norris St 4 1 1 1     3 3x3   6006897.32558 2115510.94052 37.789179385771604 -122.41997598040399 (37.7891793857716, -122.419975980404)
8560 98097 2 35 81 Frank Norris St 3 1 1 1     3 3x3   6006875.6654 2115508.14993 37.789170503156704 -122.420050723983 (37.7891705031567, -122.420050723983)
6354 98096 2 35 81 Frank Norris St 2 1 1 1     3 3x3   6006843.26628 2115504.44745 37.789158511592 -122.420162558272 (37.789158511592, -122.420162558272)
8638 98095 2 35 81 Frank Norris St 1 1 1 1     3 3x3   6006820.270769999 2115499.9051599996 37.789144743881295 -122.420241797518 (37.7891447438813, -122.420241797518)
164894 137853 2 35 1955 WEBSTER ST 1 1 1 1     5 Width 0ft   6003344.2833 2115489.023 37.788918389075704 -122.432267493573 (37.7889183890757, -122.432267493573)
18883 65715 1 35 735 Taylor St 1 1 1 1 1 05/11/1996 12:00:00 AM     Permit Number 28647 6009189.05467178 2115445.35577198 37.789128153830106 -122.41204221421499 (37.7891281538301, -122.412042214215)
174807 44212 1 35 2009 Buchanan St 1 1 1 1 1 06/01/2002 12:00:00 AM 2   Permit Number 43659 6003842.4279 2115438.8041 37.788808732867395 -122.43054039659799 (37.7888087328674, -122.430540396598)
114316 49798 1 35 314AY REVISED Locust St 1 1 1 1   03/10/2006 12:00:00 AM     Permit Number 46590 5997636.49453559 2115383.50122102 37.7883033693994 -122.452007952375 (37.7883033693994, -122.452007952375)
143324 49799 1 35 314AY REVISED Locust St 2 1 1 1   03/10/2006 12:00:00 AM     Permit Number 46590 5997636.49453559 2115383.50122102 37.7883033693994 -122.452007952375 (37.7883033693994, -122.452007952375)
44762 48666 1 35 1715REVISED Octavia St 1 1 1 1 1 09/13/2003 12:00:00 AM 1   Permit Number 45950 6004823.677 2115363.4456 37.7886573555281 -122.42714004151699 (37.7886573555281, -122.427140041517)
154550 137933 2 35 29 ORBEN PL 1 1 1 1     7 Width 0ft   6003140.6181 2115311.4461 37.7884192581755 -122.432959455149 (37.7884192581755, -122.432959455149)
163418 48665 1 35 1715REVISED Octavia St 3 1 1 1 1 09/13/2003 12:00:00 AM 2   Permit Number 45950 6004834.5382 2115307.6761 37.7885048406598 -122.42709848948799 (37.7885048406598, -122.427098489488)
Powered by Datasette · Query took 15.116ms · Data source: data.sfgov.org