sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1985 252841 1 39 1763 Golden Gate Ave   1 1 1   10/07/1998 12:00:00 AM   3x3 Permit Number 40601 6001163.0 2111730.0 37.7784731541065 -122.43954484007 (37.7784731541065, -122.43954484007)
19560 103375 2 39 22 VANDEWATER ST   1 1 1       2.5x2.5 Permit Number 770057 6009069.0 2121391.0 37.8054466905223 -122.41287812458401 (37.8054466905223, -122.412878124584)
340 191854 3 39 573 10th St 1 9 1 2     24 Width 6ft tree is in ROW therefore DPW maintained 6009977.72395 2108375.30106 37.7697596664942 -122.408814503513 (37.7697596664942, -122.408814503513)
669 251343 7 39 934 Brannan St 1 13 1 1       3x3   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
1583 251593 2 39 3698 19th St 1 1 1 1       4x4   6005038.0 2104916.0 37.7599833282319 -122.42565463806999 (37.7599833282319, -122.42565463807)
4251 246122 1 39 1518 Waller St 1 1 1 1     20 Width 0ft Permit Number 46036 5998379.9097 2108286.3815 37.768859073318 -122.448924438468 (37.768859073318, -122.448924438468)
4764 253679 2 39 94 Teresita Blvd 1 9 1 1       4x8   5997405.0 2099153.0 37.7437252916895 -122.45163765514201 (37.7437252916895, -122.451637655142)
5380 23543 3 39 2800X Van Ness Ave 1 11 1 2     35 9   6005659.04127 2120027.6333 37.8015112413055 -122.424581715282 (37.8015112413055, -122.424581715282)
6534 23551 3 39 2900X Van Ness Ave 1 11 1 2     30     6005612.78895 2120375.11437 37.802462723129395 -122.424766503478 (37.8024627231294, -122.424766503478)
8259 23442 3 39 2100X Van Ness Ave 1 11 1 2     24 9   6005990.50725 2117651.28863 37.795005114851 -122.42326567258301 (37.795005114851, -122.423265672583)
8274 41820 1 39 848 Lyon St 1 1 1 1 1 05/26/2016 12:00:00 AM 3   Permit Number 42207 6000005.683999999 2111868.9913 37.7787888536845 -122.44355840768 (37.7787888536845, -122.44355840768)
9470 105079 2 39 3770 24TH ST 1 1 1 1     24 3x3   6004633.1 2101955.7 37.7518321521274 -122.426844164794 (37.7518321521274, -122.426844164794)
9974 173765 2 39 1100x Bacon St 1 7 1 1       3x3   6008195.0 2092351.0 37.725660503016 -122.413847240833 (37.725660503016, -122.413847240833)
11387 104350 2 39 349 Guttenberg St 1 1 1 1     24 3x3   5999840.77458 2086361.4281900001 37.708741782568104 -122.44229725703 (37.7087417825681, -122.44229725703)
11531 43168 1 39 285 Madison St 1 1 1 1 1 07/11/2000 12:00:00 AM 14 3x3 Permit Number 42977 6005738.99154 2092366.96158 37.7255660943895 -122.422338611837 (37.7255660943895, -122.422338611837)
12964 44723 1 39 1946 22nd Ave 1 1 1 1 1 04/03/2001 12:00:00 AM 13   Permit Number 43842 5989432.8015 2102080.7043 37.751304216428 -122.47941744514699 (37.751304216428, -122.479417445147)
13250 187606 2 39 101 Northridge Rd 1 1 1 2       3x3   6018884.0 2094052.0 37.730925622785 -122.37701375897899 (37.730925622785, -122.377013758979)
13296 187658 7 39 600X Clarendon Ave 1 7 1 1       3x3   5995637.0 2102382.0 37.7524899085688 -122.457984564932 (37.7524899085688, -122.457984564932)
14018 99640 3 39 1000X Gilman Ave 1 1 1 2     30 3x3 City Owned Lot 6015553.4063 2089548.4030000002 37.7183756251523 -122.38821408703001 (37.7183756251523, -122.38821408703)
14426 4895 3 39 10 Rosie Lee Ln 1 1 1 2   04/19/1993 12:00:00 AM 12 3X4   6018140.882180001 2094365.07214 37.7317442992597 -122.379604608867 (37.7317442992597, -122.379604608867)
15438 104819 4 39 468 Clementina St 1 1 1 1   06/07/2016 12:00:00 AM 3 3X3 Permit Number 770905 6011018.41682 2111922.08536 37.7795565535331 -122.405464583724 (37.7795565535331, -122.405464583724)
16356 11215 3 39 1050X Ingalls St 1 1 1 2     80 3X4   6018142.31163 2094695.6186 37.732651993985705 -122.37962262229799 (37.7326519939857, -122.379622622298)
16971 4468 3 39 1497 Church St 1 1 1 2     18 3X3   6004583.98516 2100211.8834700002 37.7470412591526 -122.426889829809 (37.7470412591526, -122.426889829809)
17255 32525 1 39 864 Moultrie St 1 1 1 1   10/15/1996 12:00:00 AM 14 3x3 Permit Number 37027 6007539.30835 2095267.7389900002 37.7336323917164 -122.41632041617399 (37.7336323917164, -122.416320416174)
17421 4245 3 39 4038 Cesar Chavez St 1 1 1 2     12 3X3   6003639.78589 2100421.5344700003 37.7475634792894 -122.430169743652 (37.7475634792894, -122.430169743652)
17771 16032 1 39 155 Monterey Blvd 1 1 1 1     18 3X3   5993339.50797 2095294.7939400002 37.7328979594755 -122.465414825734 (37.7328979594755, -122.465414825734)
18999 4466 1 39 1484 Church St 1 1 1 1     18 4X4   6004525.42539 2100206.65772 37.747023599154204 -122.427091952431 (37.7470235991542, -122.427091952431)
19052 22819 1 39 61 Turquoise Way 1 1 1 1     35 2X2 10/31/08 5999145.766480001 2099274.26515 37.7441577943622 -122.445627242426 (37.7441577943622, -122.445627242426)
19220 4482 1 39 1551 Church St 1 1 1 1     12 3X3   6004606.71516 2099825.83197 37.7459825358766 -122.426783743093 (37.7459825358766, -122.426783743093)
19342 26905 3 39 10 Caine Ave 1 11 1 2     12 10   5997683.40035 2089758.8108400002 37.7179470200262 -122.449998089654 (37.7179470200262, -122.449998089654)
19568 26708 3 39 88X Noe St 1 11 1 2     12 3   6002857.07874 2107723.1475299997 37.767567597789295 -122.43339798423 (37.7675675977893, -122.43339798423)
20209 4252 3 39 4072 Cesar Chavez St 1 1 1 2     12 3X3   6003430.396430001 2100411.11399 37.747523005287206 -122.430893055767 (37.7475230052872, -122.430893055767)
21257 4479 1 39 1542 Church St 1 1 1 1     18 4X4   6004543.28364 2099929.0819200003 37.7462624498637 -122.427010433384 (37.7462624498637, -122.427010433384)
21291 2046 3 39 701X Bosworth St 1 1 1 2     6 3X3   6001912.87216 2095420.3332200001 37.733733385587 -122.43578352768299 (37.733733385587, -122.435783527683)
22187 4461 3 39 1451 Church St 1 1 1 2     18 4X4   6004572.77209 2100404.42204 37.74756929159079 -122.42694231424299 (37.7475692915908, -122.426942314243)
22909 209066 2 39 140 San Aleso Ave 1 1 1 1     5 Width 3ft   5993360.06028 2094684.7320599998 37.7312240657298 -122.46529947329901 (37.7312240657298, -122.465299473299)
23224 4372 3 39 1007 Chenery St 1 1 1 2     17 3X3   6000961.422590001 2096155.46194 37.7356977864326 -122.439125632357 (37.7356977864326, -122.439125632357)
23439 209167 2 39 102 San Benito Way 1 1 1 1     21 Width 3ft   5992842.6234800005 2095968.7682299998 37.7347198555328 -122.46718165450599 (37.7347198555328, -122.467181654506)
23691 126591 2 39 2547 Washington St 1 1 1 1     18 Width 3ft   6002516.512 2116417.22855 37.7914200340546 -122.435197883791 (37.7914200340546, -122.435197883791)
23961 247944 2 39 21 Joy St 1 7 1 1     23     6010317.99645 2098902.9194900002 37.7437696775404 -122.40696976733999 (37.7437696775404, -122.40696976734)
24101 141230 2 39 16 COMMONWEALTH AVE 1 2 1 1     17 Width 0ft   5996536.7759 2114447.1732 37.7856694107907 -122.45574506618999 (37.7856694107907, -122.45574506619)
24217 206259 2 39 125 Congo St 1 1 1 1     10 Width 3ft   6000067.98121 2094222.9592799998 37.73034070664679 -122.442075923983 (37.7303407066468, -122.442075923983)
24482 223960 2 39 646 Castro St 1 1 1 1     5 Width 3ft   6002361.48335 2104431.90571 37.75850251878121 -122.434876784451 (37.7585025187812, -122.434876784451)
24685 32723 1 39 1082 Post St 1 1 1 1 1 10/29/1996 12:00:00 AM 12   Permit Number 37114 6007012.43686 2114697.78275 37.786953139214894 -122.419519994465 (37.7869531392149, -122.419519994465)
24829 126588 2 39 116 Alhambra St 1 1 1 1     22 Width 4ft   6001687.928040001 2120423.89073 37.8023741929754 -122.438351935704 (37.8023741929754, -122.438351935704)
25083 250988 2 39 401 45th Ave 1 9 1 1     6     5981857.67732 2112961.27677 37.780736228431394 -122.50641942431999 (37.7807362284314, -122.50641942432)
26017 82939 1 39 741 Tehama St 1 1 1 1   07/07/2009 12:00:00 AM 7 3x3 Permit Number 52449 6009171.80953 2110382.94472 37.775227013061 -122.411744028881 (37.775227013061, -122.411744028881)
26861 223941 2 39 2920 22nd St 1 1 1 1     21 Width 5ft   6008707.1886599995 2103338.13414 37.755857516419795 -122.412853084526 (37.7558575164198, -122.412853084526)
26878 182670 2 39 3130 Pacheco St 1 1 1 1     2 Width 0ft   5985221.0937 2101626.7981 37.749812382761604 -122.493948347017 (37.7498123827616, -122.493948347017)
27432 66268 1 39 2008 Wawona St 1 1 1 1   10/31/1990 12:00:00 AM 12   Permit Number 29375 5986711.6119 2096941.9622 37.7370361716902 -122.488449873835 (37.7370361716902, -122.488449873835)
28127 191847 2 39 2101 Newcomb Ave 1 17 1 1     23 Width 10ft   6012411.60288 2097770.43241 37.7407770404189 -122.39965102878901 (37.7407770404189, -122.399651028789)
29057 209157 2 39 521 Dewey Blvd 1 2 1 1     17 Width 4ft   5994454.52173 2099702.14157 37.7450636850368 -122.46187943880501 (37.7450636850368, -122.461879438805)
29272 206257 2 39 470 Joost Ave 1 9 1 1     6     5998979.032869999 2094999.63504 37.7324111582444 -122.44589639242099 (37.7324111582444, -122.445896392421)
29750 192007 2 39 1201 Ingalls St 1 1 1 1     23 Width 3ft   6017817.46724 2093902.85475 37.730457297459395 -122.38069061399099 (37.7304572974594, -122.380690613991)
29776 209070 2 39 10 San Benito Way 1 2 1 1     22 Width 8ft   5992811.17187 2096755.1283099998 37.7368771879369 -122.467347553363 (37.7368771879369, -122.467347553363)
30141 42966 1 39 160 Belgrave Ave 1 1 1 1   07/13/2000 12:00:00 AM     Permit Number 42854 5997814.60948514 2104925.35351079 37.75959819679839 -122.45063741216002 (37.7595981967984, -122.45063741216)
30876 37950 1 39 609 Connecticut St 1 1 1 1 1 07/08/1998 12:00:00 AM 17   Permit Number 40190 6013298.71774 2104246.1656 37.7586074292188 -122.397037638472 (37.7586074292188, -122.397037638472)
30956 191848 2 39 1951 Revere Ave 1 7 1 1     12     6013055.009930001 2095902.15156 37.735682976376204 -122.397295372485 (37.7356829763762, -122.397295372485)
31651 209143 2 39 338 Grafton Ave 1 1 1 1     7 Width 3ft   5995743.47227 2090580.0284400003 37.7200906944019 -122.456762889002 (37.7200906944019, -122.456762889002)
31782 223948 2 39 469 Hill St 1 1 1 1     16 Width 3ft   6003275.133640001 2103282.37568 37.755398015022 -122.43163490472601 (37.755398015022, -122.431634904726)
31873 209098 2 39 65 Terrace Dr 1 2 1 1     20 Width 10ft   5993139.75731 2097020.83026 37.7376257026686 -122.46623080131201 (37.7376257026686, -122.466230801312)
32610 176356 2 39 450 Italy Ave 1 1 1 1     20 Width 2ft   6001754.19818 2089213.77814 37.716682575925 -122.43588817192101 (37.716682575925, -122.435888171921)
33569 209056 2 39 1364 12th Ave 1 1 1 1     19 Width 2ft   5992426.38178 2106168.37832 37.7627013248255 -122.469362904392 (37.7627013248255, -122.469362904392)
34621 142349 2 39 101 Jean Way 1 9 1 1     13 Width 0ft   5998390.8197 2112613.6039 37.780741136182996 -122.44919849112499 (37.780741136183, -122.449198491125)
34903 209050 2 39 1957 11th Ave 1 9 1 1     2 Width 8ft   5992832.0563900005 2102279.47717 37.752046850582104 -122.46767699299299 (37.7520468505821, -122.467676992993)
35579 191894 2 39 1195 La Salle Ave 1 1 1 1     4 Width 3ft   6017504.55596 2094293.80074 37.731513484662706 -122.381799585104 (37.7315134846627, -122.381799585104)
35740 223964 2 39 90 Douglass St 1 1 1 1     14 Width 3ft   6001033.19206 2105884.60415 37.7624157676075 -122.439574740289 (37.7624157676075, -122.439574740289)
35963 140902 2 39 2301 Geary Blvd 1 1 1 1     13 Width 0ft   6000347.067000001 2113317.3521 37.782785144864 -122.442481446452 (37.782785144864, -122.442481446452)
36449 176377 2 39 0 Crespi Dr 1 2 1 1     18     5989839.20092 2090334.4554299999 37.7190756251255 -122.47715379871201 (37.7190756251255, -122.477153798712)
37159 249463 3 39 900x Van Ness Ave 1 3 1 2     27     6006539.42856 2113694.50869 37.7841717411666 -122.421085234814 (37.7841717411666, -122.421085234814)
37535 223924 2 39 1013 Shotwell St 1 1 1 1     9 Width 3ft   6008041.687530001 2101929.49372 37.751952331841295 -122.41505490906601 (37.7519523318413, -122.415054909066)
37598 223959 2 39 642 Castro St 1 1 1 1     2 Width 3ft   6002363.563630001 2104457.3204 37.7585724195079 -122.434871407414 (37.7585724195079, -122.434871407414)
37807 32670 1 39 450 Clementina St 1 1 1 1 1 10/23/1996 12:00:00 AM 25   Permit Number 37094 6011135.7894 2112024.86418 37.7798453222359 -122.405065778479 (37.7798453222359, -122.405065778479)
38827 191997 2 39 1301 Ingalls St 1 1 1 1     30 Width 3ft   6017389.868919999 2093956.67155 37.7305814605653 -122.382172640078 (37.7305814605653, -122.382172640078)
40152 223947 2 39 4261 24th St 1 1 1 1     12 Width 3ft   6001509.65338 2101728.3731 37.7510308684778 -122.437629173946 (37.7510308684778, -122.437629173946)
40220 223962 2 39 393 Cumberland St 1 1 1 1     24 Width 3ft   6003123.78162 2104447.14367 37.7585876099598 -122.432241505563 (37.7585876099598, -122.432241505563)
40488 32598 1 39 1488 34th Ave 1 1 1 1   10/23/1996 12:00:00 AM 10   Permit Number 770751 5985603.1005 2105094.5695 37.759356274150704 -122.492882766578 (37.7593562741507, -122.492882766578)
41202 191993 2 39 1395 Ingalls St 1 1 1 1     28 Width 3ft   6017281.31768 2093927.6967 37.7304959053633 -122.382545906371 (37.7304959053633, -122.382545906371)
41375 45055 1 39 2311 26th Ave 1 1 1 1   05/23/2011 12:00:00 AM 1   Permit Number 767715 5988234.443 2099548.661 37.7442822204704 -122.483375858058 (37.7442822204704, -122.483375858058)
41800 137854 2 39 411 Austin St 1 1 1 1     15 Width 0ft   6005199.1009 2115273.8946 37.788432693763795 -122.425834752578 (37.7884326937638, -122.425834752578)
42119 209145 2 39 28 Majestic Ave 1 4 1 1     14 Width 3ft   5997357.5739 2089785.01334 37.7180003165514 -122.451126211806 (37.7180003165514, -122.451126211806)
42307 191856 2 39 456 Clementina St 1 1 1 1     24 Width 3ft   6011076.636030001 2111968.79366 37.7796880587057 -122.405266467595 (37.7796880587057, -122.405266467595)
43047 223922 2 39 515 Prentiss St 1 1 1 1     24 Width 2ft   6008751.14377 2096401.61685 37.7368138450695 -122.41221084445299 (37.7368138450695, -122.412210844453)
43280 202107 2 39 1833 Egbert Ave 1 9 1 1     23 Width 5ft   6011947.78492 2092850.2983099998 37.727241516067 -122.40090914794399 (37.727241516067, -122.400909147944)
43783 191833 2 39 1900 Jerrold Ave 1 4 1 1     27 Width 5ft   6013734.98018 2098203.9555900004 37.74204108523121 -122.395105613257 (37.7420410852312, -122.395105613257)
43785 209158 2 39 290 San Benito Way 1 1 1 1     5 Width 3ft   5992876.2231 2094948.79884 37.731921212982606 -122.46699136156799 (37.7319212129826, -122.466991361568)
43900 31372 1 39 608 Taraval St 1 1 1 1 1 12/13/1997 12:00:00 AM 16   Permit Number 34974 5991288.7498699995 2099114.74799 37.7432680941565 -122.472783188016 (37.7432680941565, -122.472783188016)
44468 176364 2 39 0 Font Blvd 1 2 1 1     13     5988874.21496 2090711.48965 37.720054833031504 -122.480516928613 (37.7200548330315, -122.480516928613)
44668 209162 2 39 170 San Benito Way 1 1 1 1     27 Width 3ft   5992852.82391 2095595.8351099999 37.733696463012706 -122.467119282923 (37.7336964630127, -122.467119282923)
45086 209100 2 39 45 Terrace Dr 1 2 1 1     28 Width 10ft   5993050.40784 2097059.35291 37.737726320615295 -122.466542521627 (37.7377263206153, -122.466542521627)
45093 176361 2 39 33 Burr Ave 1 9 1 1     15 Width 3ft   6007913.680380001 2086634.77605 37.70994915030529 -122.414415456032 (37.7099491503053, -122.414415456032)
46240 103374 2 39 22 Vandewater St 1 1 1 1     18 2.5x2.5   6009121.9449 2121331.1603 37.805285357407996 -122.41269066800301 (37.805285357408, -122.412690668003)
46492 209168 2 39 380 Santa Clara Ave 1 2 1 1     17 Width 3ft   5993162.82145 2095507.94879 37.7334730381415 -122.466041155002 (37.7334730381415, -122.466041155002)
46808 209073 2 39 44 San Benito Way 1 2 1 1     26 Width 8ft   5992818.00248 2096487.9953 37.736144101953705 -122.467304518983 (37.7361441019537, -122.467304518983)
46907 68269 1 39 424 Somerset St 1 1 1 1 1 08/09/1993 12:00:00 AM 13   Permit Number 32076 6010049.762159999 2092483.07672 37.7261271472388 -122.40744475327499 (37.7261271472388, -122.407444753275)
47117 191814 2 39 1301 Iowa St 1 2 1 1     20 Width 9ft   6014800.46205 2101999.0803099996 37.752520895829704 -122.391686773025 (37.7525208958297, -122.391686773025)
47483 223974 2 39 2 Miguel St 1 7 1 1     41     6003823.8109 2097275.5293400004 37.7389356956285 -122.429309094259 (37.7389356956285, -122.429309094259)
48443 209142 2 39 436 Holloway Ave 1 1 1 1     11 Width 3ft   5995442.598040001 2091242.1505900002 37.7218914438109 -122.457850790783 (37.7218914438109, -122.457850790783)
48476 36977 1 39 181 07th Ave 1 1 1 1 1 05/29/1998 12:00:00 AM 16   Permit Number 39602 5993647.32145 2114324.1067 37.7851652576674 -122.46573272346599 (37.7851652576674, -122.465732723466)
49266 209178 2 39 2023 09th Ave 1 1 1 1     12 Width 3ft   5993462.72736 2101706.8649 37.750510998299106 -122.465454464278 (37.7505109982991, -122.465454464278)
49627 4480 3 39 1544 Church St 1 1 1 2     18 3X3   6004537.43405 2099923.54921 37.7462469275435 -122.427030266568 (37.7462469275435, -122.427030266568)
Powered by Datasette · Query took 10.25ms · Data source: data.sfgov.org