sf-trees

Data source: data.sfgov.org

Custom SQL query returning 48 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
88711 113813 2 2 4101x 25TH ST 6 1 1 10 6   5 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
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)
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)
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)
94059 113817 2 49 4101x 25TH ST 10 1 1 10 6 02/16/2016 06:00:00 AM 3 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
95213 113810 2 51 4101x 25TH ST 3 1 1 10 6     3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
96370 113818 2 49 4101x 25TH ST 11 1 1 10 6 02/16/2016 05:57:00 AM 3 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
96735 113809 2 49 4101x 25TH ST 2 1 1 10 6 06/15/2016 07:36:00 AM 3 5x5   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
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)
98563 113820 2 184 4101x 25TH ST 13 1 1 10 6   10 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
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)
101061 113808 2 18 4101x 25TH ST 1 1 1 10 6   5 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
105585 113819 2 18 4101x 25TH ST 12 1 1 10 6   7 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
106701 113812 2 51 4101x 25TH ST 5 1 1 10 6   1 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
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)
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)
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)
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)
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)
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)
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)
122616 113811 2 2 4101x 25TH ST 4 1 1 10 6   5 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
124026 113821 2 50 4101x 25TH ST 14 1 1 10 6   10 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
124753 113814 2 49 4101x 25TH ST 7 1 1 10 6 02/16/2016 06:05:00 AM 3 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
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)
140997 113815 2 15 4101x 25TH ST 8 1 1 10 6   8 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
141271 113816 2 2 4101x 25TH ST 9 1 1 10 6   10 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
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)
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)
143896 113822 2 130 4101x 25TH ST 15 1 1 10 6   7 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
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)
Powered by Datasette · Query took 4.191ms · Data source: data.sfgov.org