sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1981 35702 1 85   15 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
5612 35700 1 85   14 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
7342 35697 1 85   8 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
8272 35698 1 85   10 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
10284 35699 1 85   11 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
11246 35705 1 85   7 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
11435 35694 1 85   4 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
11560 35695 1 85   5 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
11610 35704 1 85   17 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
12226 35696 1 85   6 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
14850 35701 1 85   13 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
15690 35690 1 85   9 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
15799 35703 1 85   16 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
15958 35692 1 85   2 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
16152 35693 1 85   3 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
83384 17658 1 85 1000X Phelps St 3 1 1 13     6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
87807 17661 1 85 1000X Phelps St 6 1 1 13     12 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
104025 17656 1 85 1000X Phelps St 1 1 1 13   11/15/1992 12:00:00 AM 6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
104908 17662 1 85 1000X Phelps St 7 1 1 13     6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
117411 17659 1 85 1000X Phelps St 4 1 1 13     12 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
125491 17660 1 85 1000X Phelps St 5 1 1 13     12 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
41186 228842 2 85 1010 Ashbury St 1 1 1 1     9 Width 3ft   5999127.094409999 2106474.67422 37.7639272833421 -122.446209649681 (37.7639272833421, -122.446209649681)
31897 129849 2 85 103 Broadway 3 1 1 1     9 Width 4ft   6012584.80341 2118810.70115 37.798558531416795 -122.400529771657 (37.7985585314168, -122.400529771657)
71586 129848 2 85 103 Broadway 2 1 1 1     8 Width 4ft   6012543.75409 2118806.63113 37.7985450667665 -122.400671529986 (37.7985450667665, -122.400671529986)
179760 129847 2 85 103 Broadway 1 1 1 1     8 Width 4ft   6012509.67235 2118803.01279 37.798533230779 -122.40078920986099 (37.798533230779, -122.400789209861)
129842 228840 2 85 104 Chattanooga St 1 1 1 1     8 Width 4ft   6004701.59069 2103023.11733 37.754766903184 -122.426683319388 (37.754766903184, -122.426683319388)
32103 38388 1 85 1150 Phelps St 2 1 1 1   08/17/1998 12:00:00 AM 5   Permit Number 40446 6014255.1081300005 2096652.83017 37.737810927032704 -122.39319864851801 (37.7378109270327, -122.393198648518)
45529 200360 2 85 1150 Phelps St 5 4 1 1     6 Width 5ft   6014196.6239 2096573.2462900002 37.737589156904995 -122.393395290662 (37.737589156905, -122.393395290662)
46141 200359 2 85 1150 Phelps St 4 4 1 1     9 Width 5ft   6014213.143619999 2096595.32013 37.737650684936796 -122.393339717964 (37.7376506849368, -122.393339717964)
74895 200358 2 85 1150 Phelps St 3 4 1 1     12 Width 5ft   6014239.8641 2096632.70057 37.7377548084229 -122.393249946754 (37.7377548084229, -122.393249946754)
34338 129793 2 85 1160 Sansome St 9 1 1 1     12 Width 4ft   6011934.29934 2120106.56325 37.8020803556973 -122.402871921008 (37.8020803556973, -122.402871921008)
54619 129787 2 85 1160 Sansome St 3 1 1 1     7 Width 4ft   6011959.4647699995 2119924.96913 37.801583147494604 -122.402772057584 (37.8015831474946, -122.402772057584)
131059 129790 2 85 1160 Sansome St 6 1 1 1     6 Width 4ft   6011945.5166 2120015.1346299998 37.8018299412604 -122.40282666982401 (37.8018299412604, -122.402826669824)
131138 129792 2 85 1160 Sansome St 8 1 1 1     8 Width 4ft   6011937.51445 2120075.46294 37.8019951413282 -122.402858606545 (37.8019951413282, -122.402858606545)
151057 129786 2 85 1160 Sansome St 2 1 1 1     7 Width 4ft   6011965.83445 2119897.8199 37.8015089579449 -122.402748105054 (37.8015089579449, -122.402748105054)
161111 129785 2 85 1160 Sansome St 1 1 1 1     7 Width 4ft   6011966.59622 2119867.2001900002 37.8014249261853 -122.402743314356 (37.8014249261853, -122.402743314356)
167735 129788 2 85 1160 Sansome St 4 1 1 1     7 Width 4ft   6011956.16596 2119957.68161 37.8016727838339 -122.402785774963 (37.8016727838339, -122.402785774963)
169005 129791 2 85 1160 Sansome St 7 1 1 1     7 Width 4ft   6011942.54079 2120045.79904 37.801913972121895 -122.402839125451 (37.8019139721219, -122.402839125451)
186385 129789 2 85 1160 Sansome St 5 1 1 1     7 Width 4ft   6011950.175319999 2119985.5388 37.80174893842371 -122.402808465741 (37.8017489384237, -122.402808465741)
36000 129798 2 85 1180 Sansome St 5 1 1 1     9 Width 4ft   6011911.92184 2120288.0073599997 37.8025773075571 -122.40296212752399 (37.8025773075571, -122.402962127524)
39753 129794 2 85 1180 Sansome St 1 1 1 1     8 Width 4ft   6011926.85553 2120176.70877 37.802272542593 -122.40290261667101 (37.802272542593, -122.402902616671)
44261 129795 2 85 1180 Sansome St 2 1 1 1     7 Width 4ft   6011922.61764 2120202.56088 37.8023432895615 -122.40291910123699 (37.8023432895615, -122.402919101237)
46251 129796 2 85 1180 Sansome St 3 1 1 1     10 Width 4ft   6011917.98876 2120230.87285 37.8024207688713 -122.402937111974 (37.8024207688713, -122.402937111974)
47233 129800 2 85 1180 Sansome St 7 1 1 1     5 Width 4ft   6011900.25036 2120353.89385 37.802757564074604 -122.40300715386101 (37.8027575640746, -122.403007153861)
165053 129799 2 85 1180 Sansome St 6 1 1 1     3 Width 4ft   6011905.71705 2120324.1253400003 37.8026761322601 -122.4029861412 (37.8026761322601, -122.4029861412)
171591 129797 2 85 1180 Sansome St 4 1 1 1     6 Width 4ft   6011917.15823 2120261.12287 37.802503781689204 -122.402942114884 (37.8025037816892, -122.402942114884)
181981 129801 2 85 1180 Sansome St 9 1 1 1     7 Width 4ft   6011895.86595 2120414.05559 37.8029225087266 -122.40302656033701 (37.8029225087266, -122.403026560337)
139630 108490 1 85 1198 Folsom St 2 1 1 1 1 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773696 6009647.20295 2110306.76017 37.7750444852375 -122.410094148747 (37.7750444852375, -122.410094148747)
90896 115305 2 85 1199x KEARNY ST 1 1 1 1       6x5   6011077.0 2118941.0 37.7988320967672 -122.405756453764 (37.7988320967672, -122.405756453764)
93478 115306 2 85 1199x KEARNY ST 2 1 1 1       5x5   6011157.0 2118940.0 37.7988338244478 -122.405479555764 (37.7988338244478, -122.405479555764)
85211 108652 2 85 1200x SANSOME ST 4 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
89013 108651 2 85 1200x SANSOME ST 3 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
89939 108657 2 85 1200x SANSOME ST 9 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
91345 108649 2 85 1200x SANSOME ST 1 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
105044 108650 2 85 1200x SANSOME ST 2 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
114000 108654 2 85 1200x SANSOME ST 6 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
116186 108655 2 85 1200x SANSOME ST 7 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
120360 108653 2 85 1200x SANSOME ST 5 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
124448 108656 2 85 1200x SANSOME ST 8 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
154064 208170 2 85 1225 Willard St 1 1 1 1     22 Width 3ft   5996717.7598 2107182.54151 37.7657330159006 -122.454593911282 (37.7657330159006, -122.454593911282)
25127 200366 2 85 1300 Phelps St 8 4 1 1     12 Width 5ft   6014047.106269999 2096372.4575200002 37.7370295240776 -122.393898196954 (37.7370295240776, -122.393898196954)
63351 200365 2 85 1300 Phelps St 7 4 1 1     6 Width 5ft   6014060.81183 2096393.5404700001 37.7370881751809 -122.39385228564801 (37.7370881751809, -122.393852285648)
112760 200367 2 85 1300 Phelps St 9 4 1 1     17 Width 5ft   6014030.85339 2096351.6806400002 37.7369715717905 -122.393952936896 (37.7369715717905, -122.393952936896)
157215 200364 2 85 1300 Phelps St 6 4 1 1     13 Width 5ft   6014077.799769999 2096412.7772 37.7371419393345 -122.393794896313 (37.7371419393345, -122.393794896313)
167176 200363 2 85 1300 Phelps St 5 4 1 1     8 Width 5ft   6014137.38405 2096492.6896799998 37.7373646735385 -122.393594476122 (37.7373646735385, -122.393594476122)
169282 200361 2 85 1300 Phelps St 1 4 1 1     7 Width 5ft   6014182.02229 2096553.32448 37.7375336444497 -122.39344438196699 (37.7375336444497, -122.393444381967)
186583 200362 2 85 1300 Phelps St 3 4 1 1     7 Width 5ft   6014166.7855 2096532.27247 37.7374749933851 -122.39349559025801 (37.7374749933851, -122.393495590258)
19672 96325 1 85 1300X Sansome St 8 1 1 1   06/06/2011 12:00:00 AM 5 4x4 Permit Number 768012 6011919.0 2120150.9 37.8022012393453 -122.40292798450399 (37.8022012393453, -122.402927984504)
84349 96323 1 85 1300X Sansome St 6 1 1 1     5 4x4   6011919.0 2120150.9 37.8022012393453 -122.40292798450399 (37.8022012393453, -122.402927984504)
85027 96326 1 85 1300X Sansome St 9 1 1 1     5 4x4   6011919.0 2120150.9 37.8022012393453 -122.40292798450399 (37.8022012393453, -122.402927984504)
88337 96318 1 85 1300X Sansome St 1 1 1 1     5 4x4   6011857.0 2120322.0 37.802667576079 -122.403154578184 (37.802667576079, -122.403154578184)
91499 96324 1 85 1300X Sansome St 7 1 1 1     5 4x4   6011919.0 2120150.9 37.8022012393453 -122.40292798450399 (37.8022012393453, -122.402927984504)
107979 96322 1 85 1300X Sansome St 5 1 1 1     5 4x4   6011919.0 2120150.9 37.8022012393453 -122.40292798450399 (37.8022012393453, -122.402927984504)
119723 96319 1 85 1300X Sansome St 2 1 1 1     5 4x4   6011919.0 2120150.9 37.8022012393453 -122.40292798450399 (37.8022012393453, -122.402927984504)
128349 96320 1 85 1300X Sansome St 3 1 1 1     5 4x4   6011919.0 2120150.9 37.8022012393453 -122.40292798450399 (37.8022012393453, -122.402927984504)
139177 96321 1 85 1300X Sansome St 4 1 1 1     5 4x4   6011919.0 2120150.9 37.8022012393453 -122.40292798450399 (37.8022012393453, -122.402927984504)
5413 14844 3 85 1327 McAllister St 1 1 1 2   07/16/1987 12:00:00 AM 6 3x3   6002796.5861 2111629.8173 37.7782909152526 -122.43388649174999 (37.7782909152526, -122.43388649175)
133858 38495 1 85 1353 Green St 1 1 1 1 1 12/05/1998 12:00:00 AM 9 3x3 Permit Number 40489 6006548.48859 2118678.2473299997 37.7978563596483 -122.421407937635 (37.7978563596483, -122.421407937635)
61384 63581 1 85 1360 Green St 1 1 1 1 1 04/30/1987 12:00:00 AM 13   Permit Number 24204 6006506.63769 2118721.20057 37.7979719387185 -122.421555805959 (37.7979719387185, -122.421555805959)
55664 129767 2 85 1375 Green St 2 1 1 1     5 Width 5ft   6006477.1660400005 2118669.59087 37.7978285696796 -122.421654118939 (37.7978285696796, -122.421654118939)
157370 129766 2 85 1375 Green St 1 1 1 1     10 Width 5ft   6006461.42741 2118668.07402 37.797823517302206 -122.42170847129199 (37.7978235173022, -122.421708471292)
36798 129763 2 85 1379 Green St 1 1 1 1     11 Width 4ft   6006382.65003 2118656.3506099996 37.7977868852004 -122.421980230217 (37.7977868852004, -122.421980230217)
50680 129764 2 85 1379 Green St 2 1 1 1     7 Width 3ft   6006404.89602 2118659.8041 37.7977976222176 -122.42190349824101 (37.7977976222176, -122.421903498241)
176983 129765 2 85 1379 Green St 3 1 1 1     7 Width 3ft   6006424.31939 2118660.7850599997 37.797801411063396 -122.421836357588 (37.7978014110634, -122.421836357588)
171038 142486 2 85 1501 STOCKTON ST 2 1 1 1     14 Width 0ft   6010093.7913 2119417.8989 37.800086511961396 -122.409192361945 (37.8000865119614, -122.409192361945)
63604 142487 2 85 1527 STOCKTON ST 1 1 1 1     9 Width 0ft   6010095.4595 2119399.2703 37.800035455862606 -122.409185274056 (37.8000354558626, -122.409185274056)
112988 108036 1 85 1527 Stockton St 2 1 1 1           6010078.267999999 2119414.52002 37.800076364716396 -122.4092458402 (37.8000763647164, -122.4092458402)
113579 108037 1 85 1527 Stockton St 3 1 1 1           6010078.267999999 2119414.52002 37.800076364716396 -122.4092458402 (37.8000763647164, -122.4092458402)
53935 208172 2 85 154 Merced Ave 1 1 1 1     4 Width 4ft   5994418.094740001 2099364.4172099996 37.7441342815725 -122.46198091018499 (37.7441342815725, -122.461980910185)
24184 208171 2 85 158 Merced Ave 1 1 1 1     3 Width 4ft   5994395.10908 2099344.18308 37.744077400365 -122.46205892188401 (37.744077400365, -122.462058921884)
47917 129784 2 85 1600 Montgomery St 1 9 1 1     9 Width 3ft   6011334.32807 2120989.68408 37.8044716700829 -122.405010336152 (37.8044716700829, -122.405010336152)
460 142327 2 85 1652 Hayes St 2 1 1 1     12 Width 0ft   5999940.0 2110256.0 37.774356244626205 -122.44366972691601 (37.7743562446262, -122.443669726916)
46833 227936 2 85 167 Valley St 1 1 1 1     26 Width 5ft   6004844.7517 2099277.52267 37.7444904598682 -122.42592162061001 (37.7444904598682, -122.42592162061)
43828 208173 2 85 170 Vasquez Ave 1 2 1 1     9 Width 3ft   5994847.17518 2099430.14012 37.744339434016794 -122.460502016448 (37.7443394340168, -122.460502016448)
78762 85037 1 85 170 Vasquez Ave 1 1 1 1           5994836.8 2099436.6 37.7443565743554 -122.460538359387 (37.7443565743554, -122.460538359387)
90885 85038 1 85 170 Vasquez Ave 2 1 1 1           5994836.8 2099436.6 37.7443565743554 -122.460538359387 (37.7443565743554, -122.460538359387)
136849 208174 2 85 170 Vasquez Ave 2 2 1 1     6 Width 3ft   5994830.69157 2099413.59203 37.7442930488025 -122.460557814002 (37.7442930488025, -122.460557814002)
62252 227934 2 85 1731 15th St 1 1 1 1     1 Width 3ft   6005814.854180001 2107243.32997 37.7664174935056 -122.423133300469 (37.7664174935056, -122.423133300469)
55932 143040 2 85 1760 Grant Ave 1 1 1 1     16 Width 0ft   6010444.0727 2120551.0606 37.8032175128046 -122.408060206321 (37.8032175128046, -122.408060206321)
91941 52992 1 85 1800 Oakdale Ave 3 1 1 1       3x3 Permit Number 48973 6013995.42685531 2096291.44248921 37.7368042013217 -122.394071207374 (37.7368042013217, -122.394071207374)
113875 129759 2 85 1827 Jones St 2 1 1 1     10 Width 3ft   6008241.72856 2118745.4751 37.7981362718366 -122.415553596641 (37.7981362718366, -122.415553596641)
Powered by Datasette · Query took 5.095ms · Data source: data.sfgov.org