sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
35908 192005 2 39 1241 Ingalls St 2 1 1 1     19 Width 3ft   6017726.88625 2093915.31646 37.7304865155426 -122.38100463475901 (37.7304865155426, -122.381004634759)
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)
36064 73981 2 39 1020 Post St 2 1 1 1 1 08/20/1988 12:00:00 AM 22     6007232.56543 2114727.7662400003 37.7870478630276 -122.418760525075 (37.7870478630276, -122.418760525075)
36237 141232 2 39 16 COMMONWEALTH AVE 3 2 1 1     19 Width 0ft   5996537.7911 2114467.1401 37.785724292831205 -122.45574299774201 (37.7857242928312, -122.455742997742)
36246 224308 2 39 321 Fair Oaks St 3 1 1 1     17 Width 5ft   6005492.11509 2101727.90157 37.7512552025777 -122.42385737251499 (37.7512552025777, -122.423857372515)
36449 176377 2 39 0 Crespi Dr 1 2 1 1     18     5989839.20092 2090334.4554299999 37.7190756251255 -122.47715379871201 (37.7190756251255, -122.477153798712)
36637 192000 2 39 1301 Ingalls St 4 1 1 1     27 Width 3ft   6017496.52836 2093947.2221900001 37.7305614047807 -122.381803241742 (37.7305614047807, -122.381803241742)
36881 223951 2 39 340 Hill St 2 2 1 1     29 Width 3ft   6004063.3586099995 2103367.27048 37.7556757625498 -122.42891503560101 (37.7556757625498, -122.428915035601)
37328 191887 2 39 1189 La Salle Ave 6 1 1 1     22 Width 3ft   6017601.124969999 2094139.4908099999 37.731095111950395 -122.381454997274 (37.7310951119504, -122.381454997274)
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)
37794 191977 2 39 1322 Hudson Ave 43 1 1 1     26 Width 3ft   6017367.63238 2095116.6683200002 37.7337653546743 -122.382330188681 (37.7337653546743, -122.382330188681)
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)
37941 201685 2 39 401 08th St 21 7 1 1     30     6010307.98401 2109858.68813 37.773851197808206 -122.407776750616 (37.7738511978082, -122.407776750616)
38065 191955 2 39 1322 Hudson Ave 13 1 1 1     21 Width 3ft   6017686.38672 2094766.769 37.732822201480104 -122.38120382830499 (37.7328222014801, -122.381203828305)
38175 183909 2 39 1100 Santiago St 4 1 1 1     15 Width 0ft   5988935.0449 2099710.5313 37.7447674238538 -122.480965203869 (37.7447674238538, -122.480965203869)
38233 191806 2 39 347 San Bruno Ave 4 7 1 1     25     6010921.55784 2106905.85989 37.7657777364646 -122.405446288816 (37.7657777364646, -122.405446288816)
38245 206256 2 39 52 Burnside Ave 9 9 1 1     14     6001149.03132 2095735.7759900002 37.7345560997669 -122.438446938292 (37.7345560997669, -122.438446938292)
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)
39210 183101 2 39 2247 44th Ave 2 2 1 1     19 Width 0ft   5982633.8386 2099812.9726 37.7446804014496 -122.502760792038 (37.7446804014496, -122.502760792038)
40028 223932 2 39 540 28th St 2 9 1 1     6 Width 10ft   6002411.2824 2099479.33596 37.74490676593071 -122.434350476903 (37.7449067659307, -122.434350476903)
40072 37951 1 39 609 Connecticut St 2 1 1 1 1 07/08/1998 12:00:00 AM 12   Permit Number 40190 6013298.65055 2104257.08873 37.7586374180095 -122.397038636728 (37.7586374180095, -122.397038636728)
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)
40175 191956 2 39 1322 Hudson Ave 14 1 1 1     6 Width 3ft   6017678.2748300005 2094778.00279 37.7328525994565 -122.381232654284 (37.7328525994565, -122.381232654284)
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)
40457 224327 2 39 147 Parnassus Ave 2 1 1 1     12 Width 3ft   5997757.791 2106766.0657599997 37.764649075606705 -122.450966650497 (37.7646490756067, -122.450966650497)
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)
40533 192001 2 39 1395 Ingalls St 5 1 1 1     23 Width 3ft   6017559.96669 2093940.58979 37.73054669636571 -122.38158346271001 (37.7305466963657, -122.38158346271)
40673 191970 2 39 1322 Hudson Ave 34 1 1 1     10 Width 3ft   6017432.113390001 2095036.9566 37.7335500434817 -122.382101713228 (37.7335500434817, -122.382101713228)
40833 191885 2 39 1190 La Salle Ave 6 1 1 1     27 Width 3ft   6017587.790709999 2094017.9071400003 37.7307605308653 -122.381492644674 (37.7307605308653, -122.381492644674)
40917 191834 2 39 1900 Jerrold Ave 2 4 1 1     21 Width 3ft   6013729.18514 2098211.77968 37.7420622462796 -122.395126198725 (37.7420622462796, -122.395126198725)
40959 191886 2 39 1189 La Salle Ave 2 1 1 1     20 Width 3ft   6017618.3449 2094055.2465 37.7308647442976 -122.38138960844 (37.7308647442976, -122.38138960844)
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)
41491 176355 2 39 450 Italy Ave 3 1 1 1     16 Width 2ft   6001789.17934 2089190.90398 37.7166217556775 -122.435765623984 (37.7166217556775, -122.435765623984)
41796 126583 2 39 2626 Baker St 2 1 1 1     10 Width 3ft   5999651.95245 2117866.72111 37.7952368746476 -122.44521342838101 (37.7952368746476, -122.445213428381)
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)
41911 191934 2 39 1333 Hudson Ave 4 1 1 1     19 Width 3ft   6017770.61427 2094662.9626799999 37.732541818939204 -122.38090541525699 (37.7325418189392, -122.380905415257)
42099 191937 2 39 1333 Hudson Ave 19 1 1 1     13 Width 3ft   6018063.70689 2094592.47846 37.732364455550204 -122.379887217221 (37.7323644555502, -122.379887217221)
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)
42493 191967 2 39 1322 Hudson Ave 30 1 1 1     18 Width 3ft   6017483.19802 2094966.73925 37.733360061719395 -122.381920214743 (37.7333600617194, -122.381920214743)
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)
43418 191923 2 39 1197 La Salle Ave 15 1 1 1     22 Width 4ft   6016764.83743 2094770.2108200002 37.7327807373215 -122.384390128099 (37.7327807373215, -122.384390128099)
43460 126603 2 39 1326 Greenwich St 2 1 1 1     16 Width 3ft   6006505.50255 2119760.20456 37.800824716844794 -122.421633567635 (37.8008247168448, -122.421633567635)
43516 201395 2 39 1051 Ingalls St 7 1 1 1     15 Width 3ft   6018074.69503 2094783.0062 37.732888213509604 -122.37986246160101 (37.7328882135096, -122.379862461601)
43726 247881 2 39 387 Mayflower St 2 17 1 1     15     6009928.32781 2098399.30466 37.742365048010896 -122.4082816417 (37.7423650480109, -122.4082816417)
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)
43975 43992 1 39 141 Hampshire St 3 1 1 1   09/08/2000 12:00:00 AM 13   Permit Number 43551 6010011.61771 2107517.81839 37.7674071146631 -122.408636765987 (37.7674071146631, -122.408636765987)
44468 176364 2 39 0 Font Blvd 1 2 1 1     13     5988874.21496 2090711.48965 37.720054833031504 -122.480516928613 (37.7200548330315, -122.480516928613)
44548 209097 2 39 75 Terrace Dr 4 2 1 1     18 Width 10ft   5993169.259380001 2097009.2167200001 37.73759551693 -122.46612795573401 (37.73759551693, -122.466127955734)
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)
45038 224302 2 39 3750 26th St 2 1 1 1     17 Width 5ft   6005441.62305 2100815.29043 37.748746532027795 -122.423967089833 (37.7487465320278, -122.423967089833)
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)
45899 191819 2 39 929 Rhode Island St 3 4 1 1     13 Width 6ft   6011909.67827 2104067.75313 37.7580401269696 -122.401829053673 (37.7580401269696, -122.401829053673)
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)
46740 223965 2 39 90 Douglass St 2 1 1 1     13 Width 3ft   6001036.08116 2105860.9947200003 37.762351106343296 -122.439563055407 (37.7623511063433, -122.439563055407)
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)
46826 191949 2 39 1322 Hudson Ave 7 1 1 1     15 Width 3ft   6017794.296519999 2094699.1469700001 37.7326424809641 -122.38082605369101 (37.7326424809641, -122.380826053691)
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)
47235 191945 2 39 1322 Hudson Ave 3 1 1 1     21 Width 3ft   6017875.529519999 2094666.5378599998 37.732557425767496 -122.38054294262899 (37.7325574257675, -122.380542942629)
47483 223974 2 39 2 Miguel St 1 7 1 1     41     6003823.8109 2097275.5293400004 37.7389356956285 -122.429309094259 (37.7389356956285, -122.429309094259)
47972 191928 2 39 1335 Hudson Ave 3 1 1 1     18 Width 3ft   6017495.9605 2094884.0455599998 37.7331337059592 -122.38187034104601 (37.7331337059592, -122.381870341046)
48070 209184 2 39 140 Kensington Way 4 13 1 1     16 Width 3ft   5994856.4919300005 2098484.57238 37.7417436767315 -122.460401301401 (37.7417436767315, -122.460401301401)
48281 209182 2 39 140 Kensington Way 2 13 1 1     17 Width 3ft   5994867.86795 2098472.15279 37.7417102300345 -122.46036106750799 (37.7417102300345, -122.460361067508)
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)
48769 191924 2 39 1197 La Salle Ave 16 1 1 1     17 Width 4ft   6016750.43932 2094781.42247 37.7328107261178 -122.384440687085 (37.7328107261178, -122.384440687085)
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)
49532 191815 2 39 1101 18th St 3 9 1 1     34 Width 4ft   6014219.19015 2105700.54735 37.762652041984296 -122.39395601257 (37.7626520419843, -122.39395601257)
49666 191898 2 39 1195 La Salle Ave 9 1 1 1     1 Width 3ft   6017470.90731 2094331.1004299999 37.7316140441423 -122.381918509648 (37.7316140441423, -122.381918509648)
49761 191965 2 39 1322 Hudson Ave 28 1 1 1     25 Width 3ft   6017513.97895 2094931.0641 37.733263804581 -122.38181131495001 (37.733263804581, -122.38181131495)
49945 209129 2 39 1301 Monterey Blvd 1 2 1 1     14 Width 2ft   5993935.3367099995 2094440.81242 37.7305874815164 -122.463292961705 (37.7305874815164, -122.463292961705)
50024 107109 2 39 468 07th Ave 1 1 1 1     11     5993767.08799 2112314.81311 37.779655189730605 -122.46517237775801 (37.7796551897306, -122.465172377758)
50242 224318 2 39 1664 Alabama St 1 1 1 1     15 Width 3ft   6009276.46755 2099693.85922 37.7458830870421 -122.410626984552 (37.7458830870421, -122.410626984552)
50262 126602 2 39 1326 Greenwich St 1 1 1 1     16 Width 3ft   6006516.79051 2119762.46986 37.8008315732811 -122.421594667478 (37.8008315732811, -122.421594667478)
50446 191912 2 39 1195 La Salle Ave 31 1 1 1     21 Width 3ft   6017156.08475 2094552.98118 37.7322058942787 -122.383022360886 (37.7322058942787, -122.383022360886)
50470 206261 2 39 57 Staples Ave 1 1 1 1     13 Width 3ft   5999614.39843 2093757.95077 37.729038042256 -122.44361062515699 (37.729038042256, -122.443610625157)
50478 223939 2 39 232 Precita Ave 1 1 1 1     15 Width 3ft   6007936.68798 2100253.80144 37.7473453568154 -122.41529940146201 (37.7473453568154, -122.415299401462)
50789 30773 1 39 548 03rd St 1 1 1 1 1 01/31/1995 12:00:00 AM 34   Permit Number 34652 6014000.72465 2112264.48181 37.7806629966488 -122.395171417543 (37.7806629966488, -122.395171417543)
50831 191939 2 39 1320 Hudson Ave 1 1 1 1     22 Width 3ft   6018082.22777 2094639.81643 37.732495458002205 -122.379826473412 (37.7324954580022, -122.379826473412)
51031 206258 2 39 470 Joost Ave 2 9 1 1     2     5998976.70694 2094998.91633 37.732409052024295 -122.44590438200198 (37.7324090520243, -122.445904382002)
51663 224312 2 39 1300 San Jose Ave 42 9 1 1     14     6003373.67876 2095579.3072 37.7342527629625 -122.43074443020599 (37.7342527629625, -122.430744430206)
51818 223945 2 39 3354 20th St 1 1 1 1     20 Width 3ft   6007844.47095 2104456.83305 37.758880744855496 -122.415915866934 (37.7588807448555, -122.415915866934)
51940 74090 2 39 2301 Ortega St 1 1 1 1 1 12/16/1995 12:00:00 AM 5     5986841.7666 2102304.3098 37.751767339194394 -122.488393849306 (37.7517673391944, -122.488393849306)
52133 223967 2 39 4200 17th St 2 1 1 1     17 Width 3ft   6001001.07931 2105834.184 37.7622754985255 -122.43968219128 (37.7622754985255, -122.43968219128)
52463 126594 2 39 2517 Gough St 1 1 1 1     15 Width 4ft   6004898.44681 2118324.72059 37.7967924958195 -122.427092354431 (37.7967924958195, -122.427092354431)
52465 224321 2 39 4078 Cesar Chavez St 1 1 1 1     11 Width 3ft   6003404.59391 2100412.31265 37.747524834522096 -122.430982364755 (37.7475248345221, -122.430982364755)
52638 191988 2 39 9 Navy Rd 10 1 1 1     23 Width 3ft   6018026.281719999 2093609.8087099998 37.729664171855504 -122.37994835046001 (37.7296641718555, -122.37994835046)
52793 191948 2 39 1322 Hudson Ave 6 1 1 1     8 Width 3ft   6017805.35755 2094693.89417 37.7326286682735 -122.380787447581 (37.7326286682735, -122.380787447581)
53072 191824 2 39 295 San Bruno Ave 2 7 1 1     35     6010910.67908 2107126.67361 37.7663834325752 -122.405499469327 (37.7663834325752, -122.405499469327)
53137 191990 2 39 1000 Oakdale Ave 8 9 1 1     22     6018074.25782 2093264.02641 37.7287173674097 -122.379758475681 (37.7287173674097, -122.379758475681)
53277 209085 2 39 59 San Benito Way 1 2 1 1     8 Width 8ft   5992858.20265 2096383.97186 37.7358608002304 -122.467157970863 (37.7358608002304, -122.467157970863)
53417 176367 2 39 0 Font Blvd 1 2 1 1     18     5989068.70923 2090618.6052 37.7198110969962 -122.479837842465 (37.7198110969962, -122.479837842465)
53581 209118 2 39 76 Terrace Dr 2 2 1 1     25 Width 8ft   5993106.35008 2096996.92574 37.737558139292496 -122.466344568258 (37.7375581392925, -122.466344568258)
Powered by Datasette · Query took 7.139ms · Data source: data.sfgov.org