sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
133243 226583 2 27 65 Gladys St 1 1 1 1     5 Width 2ft   6005675.46056 2097328.12115 37.7391847556639 -122.422910674207 (37.7391847556639, -122.422910674207)
133267 99298 1 27 50 Norton St 1 1 1 1   05/01/2012 12:00:00 AM 4 3x3 Permit Number 768888 6001844.0532599995 2092273.6485400002 37.7250893979513 -122.435796391592 (37.7250893979513, -122.435796391592)
133337 177023 2 27 1628 Burrows St 2 1 1 1     3 Width 3ft   6006643.54009 2092125.7831400002 37.7249548539585 -122.419194556805 (37.7249548539585, -122.419194556805)
133371 207206 2 27 249 Gennessee St 1 1 1 1     7 Width 1ft   5997427.94217 2094345.17262 37.730525470566896 -122.451211668094 (37.7305254705669, -122.451211668094)
133379 207242 3 27 1x Minerva St 53 11 1 2     8 Width 0ft   5996583.3083 2088999.01444 37.7157977869175 -122.453745768776 (37.7157977869175, -122.453745768776)
133706 207160 2 27 384 Santa Ana Ave 1 1 1 1     5 Width 3ft   5992464.42361 2094258.2447 37.7300013456858 -122.46836480621799 (37.7300013456858, -122.468364806218)
133764 207351 2 27 662 Mangels Ave 1 9 1 1     3 Width 3ft   5997053.67683 2095305.7853299999 37.7331416469589 -122.45257485054701 (37.7331416469589, -122.452574850547)
133848 207319 2 27 20 Woodside Ave 3 9 1 1     4 Width 3ft   5995627.90301 2100275.99182 37.7467068156796 -122.45786363851299 (37.7467068156796, -122.457863638513)
133915 226620 2 27 688 Capp St 1 1 1 1     5 Width 3ft   6007284.68348 2103336.34747 37.7557726618001 -122.417772455244 (37.7557726618001, -122.417772455244)
133963 184221 2 27 3435 Kirkham St 5 1 1 1     4 Width 0ft   5984145.6537 2104934.9816 37.7588327531435 -122.49791146613899 (37.7588327531435, -122.497911466139)
134189 226586 2 27 195 Lexington St 1 1 1 1     1 Width 3ft   6006490.36158 2105010.39 37.760324461620705 -122.420638312212 (37.7603244616207, -122.420638312212)
134488 207256 2 27 545 Arch St 1 4 1 1     6 Width 3ft   5992721.58386 2090800.7544 37.720522776379596 -122.467224484746 (37.7205227763796, -122.467224484746)
134996 207348 2 27 359 Melrose Ave 2 9 1 1     4 Width 10ft   5997745.23089 2095505.757 37.733730320683605 -122.450198383048 (37.7337303206836, -122.450198383048)
135470 207277 2 27 236 Wawona St 1 1 1 1     7 Width 3ft   5992402.86272 2097663.9953099997 37.7393491274725 -122.46882536342 (37.7393491274725, -122.46882536342)
135933 176997 2 27 131 Farragut Ave 1 9 1 1     3 Width 6ft   5997268.75573 2087384.8014900002 37.7114048037631 -122.451260209013 (37.7114048037631, -122.451260209013)
136022 118580 2 27 7900 Geary Blvd 5 9 1 1     6 Width 10ft   5982502.32297 2112445.62468 37.7793583322752 -122.504151113367 (37.7793583322752, -122.504151113367)
136074 207276 2 27 350 Dorantes Ave 1 2 1 1     3 Width 3ft   5992917.36629 2099685.98724 37.7449307166945 -122.467193430259 (37.7449307166945, -122.467193430259)
136134 207263 2 27 582 Ramsell St 2 9 1 1     5 Width 10ft   5993025.1293 2091125.2182900002 37.7214311932731 -122.46619880075899 (37.7214311932731, -122.466198800759)
136966 207147 2 27 1341 12th Ave 1 1 1 1     1 Width 2ft   5992375.35662 2106303.37048 37.7630690288235 -122.469549207953 (37.7630690288235, -122.469549207953)
137025 185770 2 27 1325 Ortega St 1 2 1 1     2 Width 0ft   5989884.1917 2102410.6066 37.752236249076205 -122.477880618296 (37.7522362490762, -122.477880618296)
137140 207254 2 27 559 Arch St 1 4 1 1     6 Width 3ft   5992720.910730001 2090888.5643799999 37.720763842354 -122.467233192875 (37.720763842354, -122.467233192875)
137148 177027 2 27 127 Naples St 1 1 1 1     6 Width 4ft   6004458.22384 2092761.54245 37.726577195866206 -122.426794207588 (37.7265771958662, -122.426794207588)
137162 207228 2 27 1018 Capitol Ave 1 1 1 1     6 Width 2ft   5995061.38916 2090705.2918200002 37.720395449464796 -122.459129669002 (37.7203954494648, -122.459129669002)
137313 207334 2 27 27 Melrose Ave 1 1 1 1     5 Width 2ft   5999906.0481 2095478.3381 37.7337784541927 -122.44272585413799 (37.7337784541927, -122.442725854138)
137436 177005 2 27 362 Arleta Ave 1 1 1 1     1 Width 3ft   6009172.07817 2088408.58756 37.714890285531794 -122.410191328669 (37.7148902855318, -122.410191328669)
137737 207316 2 27 540 Vicente St 1 1 1 1     4 Width 3ft   5991234.77071 2097748.67502 37.739514082899795 -122.47287024148899 (37.7395140828998, -122.472870241489)
138075 227702 2 27 1201 San Jose Ave 44 7 1 1     1     6004467.63219 2096063.7098700001 37.7356447417011 -122.426996770882 (37.7356447417011, -122.426996770882)
138093 207251 2 27 567 Arch St 1 4 1 1     2 Width 3ft   5992723.294480001 2090942.0276900001 37.720910777190795 -122.46722883836 (37.7209107771908, -122.46722883836)
138152 226584 2 27 116 Franconia St 1 2 1 1     5     6010066.87681 2099747.40872 37.746074405213704 -122.40789762220301 (37.7460744052137, -122.407897622203)
138958 87365 1 27 3401 Taraval St 6 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)
140890 121607 2 27 99X Lamartine St 2 1 1 1       3x3   6002710.0 2094292.0 37.7306804869695 -122.432947039569 (37.7306804869695, -122.432947039569)
143370 5001 3 27 5300 Diamond Heights Blvd 18 11 1 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
145138 24745 3 27 128X Point Lobos Ave 2 1 1 2   02/02/1996 12:00:00 AM 3 3x3   5982364.706809999 2112649.87562 37.779911051225206 -122.50464231484501 (37.7799110512252, -122.504642314845)
146496 207181 2 27 451 Ulloa St 10 2 1 1     6 Width 4ft   5995335.301969999 2098244.58715 37.7411122690279 -122.458728376224 (37.7411122690279, -122.458728376224)
147662 207305 2 27 45 Hazelwood Ave 1 2 1 1     5 Width 3ft   5996586.90838 2093990.0061299999 37.7295020780524 -122.454093586973 (37.7295020780524, -122.454093586973)
147909 226624 2 27 366 Eureka St 2 9 1 1     6 Width 3ft   6001461.5255 2103604.00302 37.75617816071271 -122.437929936033 (37.7561781607127, -122.437929936033)
147919 226594 2 27 4301 26th St 5 9 1 1     7 Width 8ft   6001878.86211 2100572.13278 37.747877092657795 -122.43626967691799 (37.7478770926578, -122.436269676918)
Powered by Datasette · Query took 4.559ms · Data source: data.sfgov.org