sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
99848 110538 2 17 100X ASHBURY ST 6 1 1 10 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
121101 110540 2 22 100X ASHBURY ST 8 1 1 10 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
125707 110537 2 17 100X ASHBURY ST 5 1 1 10 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
126853 110533 2 11 100X ASHBURY ST 1 1 1 10 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
144922 110534 2 22 100X ASHBURY ST 2 1 1 10 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
81617 81843 3 12 1299X Larkin St 1 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
97025 81841 3 12 1299X Larkin St 3 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
100401 81842 3 12 1299X Larkin St 2 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
111252 81840 3 12 1299X Larkin St 4 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
141753 81839 3 12 1299X Larkin St 5 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
89824 110738 6 333 1299x PERSIA AVE 5 1 1 10       3x3   6004594.0 2089787.0 37.71841743015371 -122.42611316787901 (37.7184174301537, -122.426113167879)
104170 110739 6 333 1299x PERSIA AVE 6 1 1 10       3x3   6004594.0 2089787.0 37.71841743015371 -122.42611316787901 (37.7184174301537, -122.426113167879)
125443 110737 6 333 1299x PERSIA AVE 4 1 1 10       3x3   6004594.0 2089787.0 37.71841743015371 -122.42611316787901 (37.7184174301537, -122.426113167879)
1043 81845 3 12 1421 Pine St 2 1 1 10 6 04/28/2017 08:33:00 AM 3 3x3 Permit Number 50020 6007103.87391 2115697.8037 37.789704100621705 -122.419274608151 (37.7897041006217, -122.419274608151)
2825 81846 3 12 1421 Pine St 1 1 1 10 6 12/20/2007 12:00:00 AM 3 3x3 Permit Number 50020 6007049.49584 2115692.06976 37.7896852939829 -122.419462344328 (37.7896852939829, -122.419462344328)
88938 82383 3 12 1421 Pine St 4 1 1 10 6 09/11/2012 12:00:00 AM 3 3x3   6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
113315 13091 3 11 1439X Lombard St 1 1 1 10   08/02/2016 06:38:00 AM 3 4x5   6005488.541730001 2119878.23932 37.8010914133698 -122.425161084884 (37.8010914133698, -122.425161084884)
12506 98216 3 39 1501X 42nd Ave 9 1 1 10 6   30 3x12   5983098.741 2104521.6922 37.7576365448231 -122.50150154301201 (37.7576365448231, -122.501501543012)
78503 98221 3 2 1501X 42nd Ave 16 1 1 10 6   6 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
84926 98219 3 2 1501X 42nd Ave 13 1 1 10 6   4 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
92792 98222 3 503 1501X 42nd Ave 17 1 1 10 6   30 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
93890 98217 3 42 1501X 42nd Ave 11 1 1 10 6   5 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
119065 98218 3 8 1501X 42nd Ave 12 1 1 10 6   3 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
120505 98220 3 8 1501X 42nd Ave 14 1 1 10 6   5 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
145968 98223 3 503 1501X 42nd Ave 18 1 1 10 6   30 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
89194 99308 3 50 1902X 41st Ave 20 1 1 10 6   6 3X3   5983703.9 2101544.3 37.7494969779561 -122.49918869137501 (37.7494969779561, -122.499188691375)
106760 99309 3 41 1902X 41st Ave 23 1 1 10 6   6 3X3   5983703.9 2101544.3 37.7494969779561 -122.49918869137501 (37.7494969779561, -122.499188691375)
78909 111135 2 62 2030x HAYES ST 8 1 1 10 6   2 5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
84535 111128 2 62 2030x HAYES ST 1 1 1 10 6   7 5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
86889 111133 2 62 2030x HAYES ST 6 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
109505 111134 2 62 2030x HAYES ST 7 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
118334 111131 2 62 2030x HAYES ST 4 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
126528 111776 2 62 2030x HAYES ST 9 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
140201 111132 2 62 2030x HAYES ST 5 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
142174 111129 2 62 2030x HAYES ST 2 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
2906 140272 2 62 2040 Hayes St 4 1 1 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998087.0735 2109979.7192 37.7734917934815 -122.450059397698 (37.7734917934815, -122.450059397698)
2911 140276 2 62 2040 Hayes St 8 1 1 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998008.2541 2109969.0086 37.773457874403704 -122.450331271992 (37.7734578744037, -122.450331271992)
2912 140274 2 62 2040 Hayes St 6 1 1 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998046.1533 2109973.9519 37.7734736163349 -122.45020053018699 (37.7734736163349, -122.450200530187)
2913 140273 2 62 2040 Hayes St 5 1 1 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998068.9478 2109976.9729 37.773483215641 -122.450121898862 (37.773483215641, -122.450121898862)
2922 140275 2 62 2040 Hayes St 7 1 1 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998028.0276 2109971.4803 37.773465792675 -122.450263051124 (37.773465792675, -122.450263051124)
2924 140269 2 62 2040 Hayes St 1 1 1 10 6 08/11/2017 12:00:00 AM 3 Width 0ft   5998144.7463 2109987.1343 37.7735154534297 -122.449860434482 (37.7735154534297, -122.449860434482)
2926 140270 2 62 2040 Hayes St 2 1 1 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998125.7967 2109984.6626 37.773507582533604 -122.44992580546001 (37.7735075825336, -122.44992580546)
4610 129875 3 11 2051 Beach St 8 1 1 10   01/20/2015 12:00:00 AM 3 Width 4ft Permit Number 771149 6000472.54237 2120960.44245 37.8037782163629 -122.44259630138399 (37.8037782163629, -122.442596301384)
4623 129872 3 11 2051 Beach St 5 1 1 10     7 Width 4ft Permit Number 771149 6000353.54628 2120943.15919 37.803723977330996 -122.44300685090401 (37.803723977331, -122.443006850904)
19689 99005 3 11 2099X Beach St 4 1 1 10         Permit Number 46510 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
82710 99003 3 11 2099X Beach St 2 1 1 10         Permit Number 46510 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
94016 99008 3 11 2099X Beach St 7 1 1 10         Permit Number 46510 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
94914 99004 3 11 2099X Beach St 3 1 1 10         Permit Number 46510 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
110121 49668 3 11 2099X Beach St 1 1 1 10 3 04/18/2011 12:00:00 AM     Permit Number 46510 6000239.54014865 2120711.44405841 37.8030812490195 -122.44338472026199 (37.8030812490195, -122.443384720262)
120466 99006 3 11 2099X Beach St 5 1 1 10         Permit Number 46510 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
121378 99007 3 79 2099X Beach St 6 1 1 10   01/20/2015 12:00:00 AM 3   Permit Number 771149 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
126814 99009 3 79 2099X Beach St 8 1 1 10   01/20/2015 12:00:00 AM 3   Permit Number 771149 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
115219 98995 3 12 2190X Divisadero St 1 1 1 10       3x3   6000922.9 2115860.7 37.7898013277865 -122.44067180053001 (37.7898013277865, -122.44067180053)
79502 98996 3 12 2190X North Point St 2 1 1 10   04/18/2011 12:00:00 AM   3x3   6000702.0 2120685.0 37.803035002067396 -122.441782472194 (37.8030350020674, -122.441782472194)
94965 99002 3 11 2190X North Point St 8 1 1 10   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641)
96054 99000 3 11 2190X North Point St 6 1 1 10   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641)
102667 98999 3 79 2190X North Point St 5 1 1 10   01/20/2015 12:00:00 AM 3 3x3 Permit Number 771149 6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641)
114359 98998 3 11 2190X North Point St 4 1 1 10   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641)
120277 99001 3 11 2190X North Point St 7 1 1 10   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641)
123900 98997 3 11 2190X North Point St 3 1 1 10       3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641)
81348 113709 2 39 2801x CLEMENT ST 5 1 1 10 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
84481 113708 2 39 2801x CLEMENT ST 4 1 1 10 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
110169 113705 2 39 2801x CLEMENT ST 1 1 1 10 6   10 4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
111553 113706 2 39 2801x CLEMENT ST 2 1 1 10 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
115629 113707 2 39 2801x CLEMENT ST 3 1 1 10 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
81659 113874 2 11 301x BRODERICK ST 11 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
88973 113868 2 11 301x BRODERICK ST 5 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
90304 113871 2 11 301x BRODERICK ST 8 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
95919 113866 2 11 301x BRODERICK ST 3 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
101830 113867 2 11 301x BRODERICK ST 4 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
108397 113873 2 11 301x BRODERICK ST 10 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
116544 113872 2 11 301x BRODERICK ST 9 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
117615 113869 2 11 301x BRODERICK ST 6 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
144577 113865 2 11 301x BRODERICK ST 2 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
79317 95366 3 5 3101X Van Ness Ave 1 1 1 10 6   14 3x3   6005504.90819 2120981.97244 37.8041229057048 -122.42518303152201 (37.8041229057048, -122.425183031522)
83640 101808 3 11 3149 26th St 1 1 1 10   02/03/2015 12:00:00 AM 3 3x3   6008718.2 2100791.7 37.7488661984732 -122.41263499808599 (37.7488661984732, -122.412634998086)
37389 95036 3 43 3224 Pierce St 7 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
82784 95034 3 43 3224 Pierce St 3 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
83793 95035 3 43 3224 Pierce St 5 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
84126 95033 3 43 3224 Pierce St 1 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
94908 95038 3 43 3224 Pierce St 9 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
104986 95041 3 43 3224 Pierce St 12 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
108162 95039 3 43 3224 Pierce St 11 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
1586 98725 3 15 360 Grove St 1 1 1 10     14 3x3   6006216.75471 2111460.37935 37.7780191723707 -122.42204280683501 (37.7780191723707, -122.422042806835)
2933 98726 3 15 360 Grove St 2 1 1 10     12 3x3   6006198.51355 2111464.4034 37.7780291926159 -122.422106195562 (37.7780291926159, -122.422106195562)
3428 98728 3 15 360 Grove St 4 1 1 10     14 3x3   6006156.19882 2111456.14926 37.778004142027 -122.42225199096 (37.778004142027, -122.42225199096)
6003 98729 3 15 360 Grove St 5 1 1 10     13 3x3   6006140.89781 2111454.63858 37.7779991309825 -122.42230481531901 (37.7779991309825, -122.422304815319)
6064 98727 3 15 360 Grove St 3 1 1 10     12 3x3   6006176.94483 2111455.11485 37.7780024719703 -122.422180149508 (37.7780024719703, -122.422180149508)
9030 98730 3 15 360 Grove St 6 1 1 10     13 3x3   6006126.244940001 2111454.93961 37.777999130991205 -122.42235552627899 (37.7779991309912, -122.422355526279)
83093 98734 3 15 360 Grove St 10 1 1 10     14 3x3   6006078.7 2111522.5 37.778181953323 -122.422524803295 (37.778181953323, -122.422524803295)
89481 98733 3 15 360 Grove St 9 1 1 10     13 3x3   6006078.7 2111522.5 37.778181953323 -122.422524803295 (37.778181953323, -122.422524803295)
107050 98735 3 15 360 Grove St 11 1 1 10     12 3x3   6006078.7 2111522.5 37.778181953323 -122.422524803295 (37.778181953323, -122.422524803295)
113650 98731 3 15 360 Grove St 7 1 1 10     13 3x3   6006078.7 2111522.5 37.778181953323 -122.422524803295 (37.778181953323, -122.422524803295)
145660 98732 3 15 360 Grove St 8 1 1 10     12 3x3   6006078.7 2111522.5 37.778181953323 -122.422524803295 (37.778181953323, -122.422524803295)
23495 49666 3 11 3630 Divisadero St 1 1 1 10   04/18/2011 12:00:00 AM 6   Permit Number 46510 6000245.17413 2120665.11682 37.8029543681198 -122.443361894237 (37.8029543681198, -122.443361894237)
44297 49663 3 11 3630 Divisadero St 7 1 1 10   04/18/2011 12:00:00 AM 7   Permit Number 46510 6000228.83335 2120782.17575 37.8032748487093 -122.44342685496599 (37.8032748487093, -122.443426854966)
46479 49665 3 11 3630 Divisadero St 3 1 1 10   04/18/2011 12:00:00 AM 6   Permit Number 46510 6000243.34961 2120687.49551 37.8030157099616 -122.443369816371 (37.8030157099616, -122.443369816371)
61973 47415 3 11 3630 Divisadero St 4 1 1 10   05/14/2002 12:00:00 AM 9   Permit Number 45326 6000240.55787 2120707.38669 37.8030701666099 -122.443380906816 (37.8030701666099, -122.443380906816)
74165 49662 3 11 3630 Divisadero St 8 1 1 10   04/18/2011 12:00:00 AM 6   Permit Number 46510 6000225.92137 2120807.31261 37.803343701723 -122.44343873861 (37.803343701723, -122.44343873861)
133148 49664 3 5 3630 Divisadero St 5 1 1 10   04/18/2011 12:00:00 AM 26   Permit Number 46510 6000238.4271 2120737.0669299997 37.80315153908379 -122.44339041353399 (37.8031515390838, -122.443390413534)
158201 49667 3 11 3630 Divisadero St 6 1 1 10   04/18/2011 12:00:00 AM 8   Permit Number 46510 6000232.6794300005 2120757.93136 37.8032084994456 -122.443411803017 (37.8032084994456, -122.443411803017)
Powered by Datasette · Query took 114.208ms · Data source: data.sfgov.org