sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
67505 50406 1 27 1361 46th Ave 1 1 1 1 1 10/06/2003 12:00:00 AM 4   Permit Number 47058 5981810.1658 2105846.3225 37.761197837443596 -122.50605609679701 (37.7611978374436, -122.506056096797)
67611 43211 1 27 353 Sweeny St 1 1 1 1 1 07/11/2000 12:00:00 AM 5   Permit Number 43002 6008758.60086 2094527.34935 37.73166792973 -122.412052645639 (37.73166792973, -122.412052645639)
67812 207165 2 27 501 Laguna Honda Blvd 1 1 1 1     3 Width 3ft   5995466.11989 2100230.17484 37.746571717707205 -122.458419748693 (37.7465717177072, -122.458419748693)
67877 207215 2 27 351 Judson Ave 17 1 1 1     6 Width 1ft   5997615.0933300005 2093521.35715 37.7282741823893 -122.450505294682 (37.7282741823893, -122.450505294682)
67927 41944 1 27 567 07th Ave 1 1 1 1 1 06/20/2000 12:00:00 AM 7   Permit Number 42302 5993743.34162 2111650.50193 37.7778298007164 -122.465206260397 (37.7778298007164, -122.465206260397)
67977 117858 2 27 600 39th Ave 1 1 1 1     6 Width 3ft   5983830.55841 2111665.32715 37.777293884605704 -122.499498581311 (37.7772938846057, -122.499498581311)
68141 207220 2 27 143 Judson Ave 2 9 1 1     7     5999153.87241 2093460.82982 37.7281959413875 -122.445181340549 (37.7281959413875, -122.445181340549)
68271 177021 2 27 1538 Burrows St 1 9 1 1     6 Width 4ft   6006775.37088 2092172.2563099999 37.72508988269 -122.41874212587 (37.72508988269, -122.41874212587)
68354 207353 2 27 678 Joost Ave 1 9 1 1     4 Width 10ft   5997598.43347 2095021.49363 37.7323922472992 -122.45067100017201 (37.7323922472992, -122.450671000172)
68812 207209 2 27 342 Edna St 2 9 1 1     5 Width 8ft   5998785.841580001 2094004.8345400002 37.7296686369961 -122.446492753553 (37.7296686369961, -122.446492753553)
68943 207150 2 27 830 Ortega St 2 1 1 1     5 Width 1ft   5991404.13851 2102515.6148 37.752612672541105 -122.47263211090099 (37.7526126725411, -122.472632110901)
68986 185609 2 27 2261 Quintara St 2 1 1 1     3 Width 0ft   5986412.841 2100929.3732 37.747967099583 -122.489776004492 (37.747967099583, -122.489776004492)
69001 176998 2 27 87 Seneca Ave 2 1 1 1     3 Width 1ft   6000227.51825 2089886.7347900001 37.7184435186304 -122.441213386902 (37.7184435186304, -122.441213386902)
69070 207341 2 27 538 Joost Ave 3 9 1 1     9     5998515.2216 2095011.0330299998 37.7324159597185 -122.447500710116 (37.7324159597185, -122.447500710116)
69145 207269 2 27 1477 06th Ave 2 1 1 1     5 Width 3ft   5994263.394830001 2105452.9722599997 37.760842992730105 -122.462957472303 (37.7608429927301, -122.462957472303)
69462 119126 2 27 601 46th Ave 1 9 1 1     7 Width 5ft   5981603.35382 2111608.79109 37.777007725640104 -122.507198870746 (37.7770077256401, -122.507198870746)
69603 207236 3 27 1x Minerva St 25 11 1 2     3 Width 0ft   5996258.071 2089000.15441 37.7157822655196 -122.45487001484301 (37.7157822655196, -122.454870014843)
70030 177026 2 27 501 Sweeny St 1 9 1 1     3 Width 6ft   6008206.81715 2094351.9900900002 37.7311554564421 -122.41394787781601 (37.7311554564421, -122.413947877816)
70085 207207 2 27 101 Foerster St 3 9 1 1     7 Width 10ft   5998074.45641 2093829.28565 37.7291459626917 -122.44893943651199 (37.7291459626917, -122.448939436512)
70124 207280 2 27 595 Darien Way 1 2 1 1     3 Width 3ft   5993435.14458 2094919.26873 37.731872375313294 -122.46505692344299 (37.7318723753133, -122.465056923443)
70286 42982 1 27 469 Princeton St 1 1 1 1 1 07/05/2000 12:00:00 AM 7   Permit Number 42866 6008125.46012 2091747.89633 37.724000603132 -122.414044988394 (37.724000603132, -122.414044988394)
70323 207350 2 27 618 Mangels Ave 3 1 1 1     4 Width 3ft   5997300.95019 2095282.96772 37.7330931600175 -122.451718319154 (37.7330931600175, -122.451718319154)
70570 207314 2 27 1570 07th Ave 4 1 1 1     5 Width 3ft   5994021.19813 2104903.51705 37.759320377550395 -122.46375523571999 (37.7593203775504, -122.46375523572)
70722 207218 2 27 147 Judson Ave 2 9 1 1     7     5999123.66307 2093458.3174700001 37.7281873186821 -122.445285594449 (37.7281873186821, -122.445285594449)
70729 177010 2 27 78 Lamartine St 1 1 1 1     6 Width 3ft   6002632.11132 2094355.1655700002 37.73084950708879 -122.433220824095 (37.7308495070888, -122.433220824095)
71088 207340 2 27 538 Joost Ave 2 9 1 1     5     5998514.78137 2095005.5292 37.732400822345205 -122.44750183606001 (37.7324008223452, -122.44750183606)
71287 207201 2 27 351 Flood Ave 1 1 1 1     7 Width 2ft   5998416.44412 2094074.8160299999 37.7298396835571 -122.447774830644 (37.7298396835571, -122.447774830644)
71533 117965 2 27 4545 Anza St 6 1 1 1     5 Width 3ft   5984581.6879 2111733.75019 37.7775257966351 -122.496905272636 (37.7775257966351, -122.496905272636)
72391 176996 2 27 763 Morse St 16 1 1 1     6 Width 3ft   5998705.41323 2087176.369 37.7109146507487 -122.44627978598999 (37.7109146507487, -122.44627978599)
72894 207221 2 27 125 Judson Ave 3 9 1 1     5     5999184.61823 2093461.48115 37.7281994846941 -122.44507509826401 (37.7281994846941, -122.445075098264)
73076 207146 2 27 1440 16th Ave 1 2 1 1     1 Width 4ft   5991174.2447 2105585.9909099997 37.7610298052998 -122.47365107156601 (37.7610298052998, -122.473651071566)
73346 226593 2 27 4301 26th St 4 9 1 1     4 Width 8ft   6001851.9880099995 2100572.11343 37.7478755125637 -122.43636260477301 (37.7478755125637, -122.436362604773)
73614 40348 1 27 501 38th Ave 1 1 1 1 1 05/17/1999 12:00:00 AM 6   Permit Number 41478 5984070.03891 2112340.8801599997 37.779162805435 -122.498720071631 (37.779162805435, -122.498720071631)
73643 207345 2 27 628 Edna St 1 9 1 1     3 Width 10ft   5998591.38299 2094890.7633 37.732090079596794 -122.44722875061399 (37.7320900795968, -122.447228750614)
73666 184518 2 27 4108 Pacheco St 1 1 1 1     1 Width 0ft   5982209.6889 2101522.5062 37.7493493689338 -122.504354014902 (37.7493493689338, -122.504354014902)
73802 207144 2 27 1617 16th Ave 2 1 1 1     1 Width 2ft   5991126.06401 2104353.71257 37.757643505256205 -122.473727808906 (37.7576435052562, -122.473727808906)
73920 207210 2 27 146 Staples Ave 1 9 1 1     12     5999095.98576 2093806.86087 37.7291427575169 -122.445406326639 (37.7291427575169, -122.445406326639)
73988 207312 2 27 101 Ridgewood Ave 1 1 1 1     7 Width 3ft   5996777.2193 2094487.3918299999 37.730878690977704 -122.45347156457399 (37.7308786909777, -122.453471564574)
74258 207354 2 27 236 Ridgewood Ave 1 1 1 1     5 Width 2ft   5996818.09015 2094943.97322 37.732134696764 -122.453363219655 (37.732134696764, -122.453363219655)
74277 67405 1 27 774 20th Ave 1 1 1 1 1 07/30/1992 12:00:00 AM 9   Permit Number 30904 5989782.793 2110097.20217 37.7733356814764 -122.478793391379 (37.7733356814764, -122.478793391379)
74649 207296 2 27 217 Colon Ave 2 2 1 1     5 Width 3ft   5996041.08515 2094289.8634799998 37.7302941010767 -122.456002210028 (37.7302941010767, -122.456002210028)
74830 207158 2 27 237 Wawona St 1 1 1 1     7 Width 3ft   5992472.8250400005 2097675.82148 37.739385640835295 -122.468584327098 (37.7393856408353, -122.468584327098)
75032 207204 2 27 655 Joost Ave 1 1 1 1     5 Width 1ft   5997746.28105 2094978.11771 37.7322816091084 -122.450156733641 (37.7322816091084, -122.450156733641)
75063 123520 2 27 2808 Fulton St 1 9 1 1     6 Width 5ft   5994672.01997 2110241.5879900004 37.774014807441795 -122.461891472498 (37.7740148074418, -122.461891472498)
75227 185264 2 27 2147 Vicente St 4 1 1 1     5 Width 0ft   5986264.4244 2097520.2042 37.7385977678327 -122.490038499473 (37.7385977678327, -122.490038499473)
75474 207342 2 27 538 Joost Ave 4 9 1 1     5     5998499.20735 2095008.2855900002 37.7324075007117 -122.447555877206 (37.7324075007117, -122.447555877206)
75859 207224 2 27 49 Edna St 1 1 1 1     5 Width 1ft   5998734.87043 2093158.9272 37.727343062112396 -122.446608128468 (37.7273430621124, -122.446608128468)
75893 70393 2 27 63 Madison St 1 1 1 1 1 05/21/1994 12:00:00 AM 6     6005472.78201 2093254.0606099998 37.7279868534853 -122.42332190988998 (37.7279868534853, -122.42332190989)
75923 226602 3 27 5200x Diamond Heights Blvd 35 3 1 2     11     6001604.7772 2098884.15576 37.7432267298424 -122.437096613431 (37.7432267298424, -122.437096613431)
76051 207298 2 27 111 Valdez Ave 1 1 1 1     6 Width 3ft   5996286.51947 2094316.70178 37.73038187671379 -122.45515565391099 (37.7303818767138, -122.455155653911)
76063 43217 1 27 45 Princeton St 1 1 1 1 1 07/11/2000 12:00:00 AM 4   Permit Number 43007 6007564.041619999 2093733.91416 37.7294222326375 -122.416126315492 (37.7294222326375, -122.416126315492)
76065 207186 2 27 50 Hearst Ave 1 1 1 1     7 Width 2ft   6000874.80167 2094365.21675 37.730777259156 -122.43929683358299 (37.730777259156, -122.439296833583)
76247 207177 2 27 451 Ulloa St 6 2 1 1     8 Width 4ft   5995331.55155 2098239.9871900002 37.7410994231129 -122.458741010797 (37.7410994231129, -122.458741010797)
76282 226604 2 27 495 Collingwood St 5 9 1 1     9 Width 2ft   6002163.6712 2103050.21539 37.7546974962127 -122.435462066843 (37.7546974962127, -122.435462066843)
76289 250091 2 27 1620 Gough St 1 9 1 1     4 Width 2ft   6005381.25743 2115289.65998 37.7884862737667 -122.425205641527 (37.7884862737667, -122.425205641527)
76312 207237 3 27 1x Minerva St 33 11 1 2     15 Width 0ft   5996320.92755 2088998.85833 37.715782312278 -122.454652661299 (37.715782312278, -122.454652661299)
76321 207202 2 27 436 Gennessee St 1 9 1 1     7     5997481.98173 2094926.0647599997 37.7321235559578 -122.45106671987301 (37.7321235559578, -122.451066719873)
76937 42890 1 27 2249 Ulloa St 3 1 1 1 1 07/03/2000 12:00:00 AM 3   Permit Number 42809 5988984.6022 2098295.481 37.7408849467502 -122.48069027409402 (37.7408849467502, -122.480690274094)
77335 207193 2 27 312 Hearst Ave 4 1 1 1     9 Width 2ft   5999342.629819999 2094390.1530400002 37.7307584183688 -122.444595567153 (37.7307584183688, -122.444595567153)
79917 1384 3 27 2550X Diamond St 2 1 1 2     20 3X2   6002245.07965 2096962.3294799998 37.737986217166096 -122.43474521929 (37.7379862171661, -122.43474521929)
80194 4999 3 27 5300 Diamond Heights Blvd 16 11 1 2     7 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
88236 4991 3 27 5300 Diamond Heights Blvd 8 11 1 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
89568 87364 1 27 3401 Taraval St 5 1 1 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
91369 177012 2 27 78 Lamartine St 3 1 1 1     6 Width 3ft   6002642.0398 2094328.25695 37.730776185352504 -122.433184577831 (37.7307761853525, -122.433184577831)
94015 4992 3 27 5300 Diamond Heights Blvd 9 11 1 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
94485 87363 1 27 3401 Taraval St 4 1 1 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
95563 4998 3 27 5300 Diamond Heights Blvd 15 11 1 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
97805 4994 3 27 5300 Diamond Heights Blvd 11 11 1 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
99734 4993 3 27 5300 Diamond Heights Blvd 10 11 1 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
100854 19333 3 27 325 Shields St 1 1 1 2     6 3X3   5993178.445205901 2089816.9668961002 37.7178478960527 -122.46557383978 (37.7178478960527, -122.46557383978)
102241 121608 2 27 99X Lamartine St 3 1 1 1       3x3   6002710.0 2094292.0 37.7306804869695 -122.432947039569 (37.7306804869695, -122.432947039569)
102463 87366 1 27 3401 Taraval St 7 1 1 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
103991 100461 2 27 236 Wawona St 1 1 1 1           5992450.0 2097712.0 37.7394836593705 -122.468665877071 (37.7394836593705, -122.468665877071)
108882 90815 3 27 3145 Cabrillo St 1 1 1 2   04/07/2008 12:00:00 AM 3 3x3   5985771.299330001 2110409.9607700002 37.7739606832472 -122.49269254584101 (37.7739606832472, -122.492692545841)
109500 116713 2 27 1400 Baker St 5 1 1 1     4 3x3   6000212.5605 2113848.1665 37.78423495653821 -122.44298491286699 (37.7842349565382, -122.442984912867)
110729 4995 3 27 5300 Diamond Heights Blvd 12 11 1 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
112212 207333 2 27 378 Mangels Ave 1 1 1 1     4 Width 2ft   5998914.45517 2095254.7812700002 37.7331080419878 -122.446137997991 (37.7331080419878, -122.446137997991)
116109 115788 1 27 3628 16th St 2 1 1 1 1 03/09/2016 12:00:00 AM 3   Permit Number 777599 6002731.19846 2106518.35077 37.764252377203 -122.433747267607 (37.764252377203, -122.433747267607)
116496 177009 2 27 425 Cayuga Ave 2 9 1 1     7 Width 6ft   6002141.25462 2093891.34658 37.729548108055 -122.434884635528 (37.729548108055, -122.434884635528)
117257 108497 1 27 1339 12th Ave 1 1 1 1 1 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773641 5992378.78756 2106335.85187 37.7631584124216 -122.46953970622101 (37.7631584124216, -122.469539706221)
117656 117966 2 27 4545 Anza St 5 1 1 1     4 Width 3ft   5984567.33243 2111733.70358 37.7775248274666 -122.496954928801 (37.7775248274666, -122.496954928801)
117773 121606 2 27 99X Lamartine St 1 1 1 1       3x3   6002710.0 2094292.0 37.7306804869695 -122.432947039569 (37.7306804869695, -122.432947039569)
123823 207323 2 27 734 Teresita Blvd 2 1 1 1     4 Width 3ft   5998893.471580001 2095962.39727 37.7350497898071 -122.446261428139 (37.7350497898071, -122.446261428139)
123975 57938 1 27 7 Byron Ct 1 1 1 1   08/18/2010 12:00:00 AM 4   Permit Number 53686 5999410.13624 2086691.6630000002 37.7096239797406 -122.443809305177 (37.7096239797406, -122.443809305177)
125304 177013 2 27 78 Lamartine St 4 1 1 1     6 Width 3ft   6002644.59595 2094315.3545 37.7307409031583 -122.433174819278 (37.7307409031583, -122.433174819278)
129591 185132 2 27 2675 34th Ave 1 9 1 1     6 Width 0ft   5985816.5603 2097133.8948 37.7375109017116 -122.491558549707 (37.7375109017116, -122.491558549707)
129805 226626 2 27 310 Liberty St 12 2 1 1     17 Width 3ft   6004198.11867 2103939.92108 37.757255752658295 -122.42848980825899 (37.7572557526583, -122.428489808259)
129828 226614 2 27 322 Elsie St 9 1 1 1     6 Width 3ft   6006361.987980001 2097015.1421299998 37.738364099132795 -122.42051475707399 (37.7383640991328, -122.420514757074)
130406 207187 2 27 50 Hearst Ave 2 1 1 1     7 Width 2ft   6000857.41139 2094366.50638 37.730779810542295 -122.439357046798 (37.7307798105423, -122.439357046798)
130433 207283 2 27 84 Manor Dr 3 1 1 1     4 Width 3ft   5993642.59329 2093470.80397 37.7279072068291 -122.464234616632 (37.7279072068291, -122.464234616632)
130565 207178 2 27 451 Ulloa St 7 2 1 1     3 Width 4ft   5995329.77436 2098242.36362 37.7411058460538 -122.45874732764 (37.7411058460538, -122.45874732764)
130678 116712 2 27 1400 Baker St 4 1 1 1     5 3x3   6000214.6483 2113835.6397 37.784200680215605 -122.44297678993999 (37.7842006802156, -122.44297678994)
130898 207284 2 27 84 Manor Dr 2 1 1 1     4 Width 3ft   5993637.22552 2093458.84875 37.727874071330106 -122.464252305417 (37.7278740713301, -122.464252305417)
130905 108372 1 27 575 Paris St 2 1 1 1 1   1 3x3   6001633.30512 2090300.73335 37.7196602437916 -122.436383787393 (37.7196602437916, -122.436383787393)
131253 185261 2 27 2177 Vicente St 1 1 1 1     4 Width 0ft   5986220.9115 2097517.551 37.7385879417998 -122.49018874910401 (37.7385879417998, -122.490188749104)
131369 207156 2 27 2426 16th Ave 1 1 1 1     2 Width 3ft   5991402.6198 2098893.19012 37.7426663442825 -122.472373311184 (37.7426663442825, -122.472373311184)
131611 207292 2 27 965 Darien Way 2 1 1 1     6 Width 3ft   5994659.45419 2093917.36528 37.729191913559205 -122.460751677241 (37.7291919135592, -122.460751677241)
131761 207244 2 27 246 Monticello St 1 4 1 1     4 Width 3ft   5991705.04474 2090167.4544799998 37.7187251566245 -122.47069219949199 (37.7187251566245, -122.470692199492)
131833 207161 2 27 509 Miramar Ave 1 1 1 1     4 Width 2ft   5995344.03835 2092755.21065 37.726040281721296 -122.45830094463498 (37.7260402817213, -122.458300944635)
131950 71605 2 27 178 Wilson St 1 1 1 1 1 09/30/1995 12:00:00 AM 7     5994512.31694 2086511.3564 37.7088483153534 -122.46072384594 (37.7088483153534, -122.46072384594)
132193 207162 2 27 509 Miramar Ave 2 1 1 1     5 Width 2ft   5995343.73993 2092740.9516 37.7260011126479 -122.45830094463699 (37.7260011126479, -122.458300944637)
Powered by Datasette · Query took 2.979ms · Data source: data.sfgov.org