sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
116973 108643 2 17 315X PACIFIC AVE 1 1 1 1 15     3x3   6012408.6 2118423.0 37.7974841688946 -122.40111223755501 (37.7974841688946, -122.401112237555)
111940 105173 2 2 1601X NEWCOMB AVE 2 1 1 16 14   13 4x4 Permit Number 770204 6015135.0 2095759.0 37.735405494081505 -122.390093985074 (37.7354054940815, -122.390093985074)
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)
62495 118286 2 12 199X JULES AVE 2 1 1 1 12     3x3   5994418.0 2091201.0 37.7217195365393 -122.461389557582 (37.7217195365393, -122.461389557582)
112977 118285 2 12 199X JULES AVE 1 1 1 1 12     3x3   5994418.0 2091201.0 37.7217195365393 -122.461389557582 (37.7217195365393, -122.461389557582)
50491 107717 2 17 2400X 25th Ave 3 1 2 1 11 10/16/2014 12:00:00 AM 3 3x3 Permit Number 773973 5985789.0 2098909.0 37.7423832554664 -122.49178447783899 (37.7423832554664, -122.491784477839)
80890 108255 2 19 1798X Washington St 2 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
92163 108259 2 19 1798X Washington St 6 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
97433 107716 2 17 2400X 25th Ave 2 1 2 1 11 10/16/2014 12:00:00 AM 3 3x3 Permit Number 773973 5985789.0 2098909.0 37.7423832554664 -122.49178447783899 (37.7423832554664, -122.491784477839)
98097 108256 2 19 1798X Washington St 3 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
105668 108258 2 19 1798X Washington St 5 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
112717 108257 2 19 1798X Washington St 4 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
120202 108107 2 43 1990X Laguna St 2 1 1 1 11         6004838.0 2115780.0 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027)
121707 108254 2 19 1798X Washington St 1 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
136121 106963 2 44 2728 Union St 2 1 1 1 11   14     5999920.02374 2118149.14648 37.7960276377095 -122.444306168018 (37.7960276377095, -122.444306168018)
143269 108106 2 43 1990X Laguna St 1 1 1 1 11         6004838.0 2115780.0 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027)
43480 111380 2 3 301x OCEAN AVE 2 5 1 10 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
44757 104618 2 21 800 Folsom St 1 1 1 1 10   8 4x4 Permit Number 770959 6012200.3 2112763.2826 37.7819322989016 -122.401435053146 (37.7819322989016, -122.401435053146)
51360 110401 2 36 419X 18th Ave 2 1 1 10 10   27 3x3   5990271.90904 2112469.3758 37.779877404965504 -122.4772748837 (37.7798774049655, -122.4772748837)
90733 104623 2 21 250 04th St 1 1 1 1 10     3x3 Permit Number 770961 6012050.5 2112960.1 37.7824643544146 -122.40196713530099 (37.7824643544146, -122.401967135301)
95314 104621 2 21 266-286X 04th St 1 1 1 1 10     4x4 Permit Number 770959 6012142.0 2112916.0 37.7823483723512 -122.401647482717 (37.7823483723512, -122.401647482717)
101265 110403 2 256 419X 18TH AVE 4 1 1 10 10   22 3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
107894 111381 2 3 301x OCEAN AVE 3 5 1 10 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
108530 110402 2 19 419X 18TH AVE 3 1 1 10 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
113498 104624 2 21 250 04th St 2 1 1 1 10     3x3 Permit Number 770961 6012050.5 2112960.1 37.7824643544146 -122.40196713530099 (37.7824643544146, -122.401967135301)
115819 110406 2 19 419X 18TH AVE 7 1 1 10 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
121695 111379 2 3 301x OCEAN AVE 1 5 1 10 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
125272 110420 2 20 419X 18TH AVE 18 1 1 10 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
132930 110400 2 60 419X 18th Ave 1 1 1 10 10   28 3x3   5990269.5497 2112500.03817 37.77996145844129 -122.477285287094 (37.7799614584413, -122.477285287094)
140020 104622 2 21 266-286X 04th St 2 1 1 1 10     4x4 Permit Number 770959 6012142.0 2112916.0 37.7823483723512 -122.401647482717 (37.7823483723512, -122.401647482717)
144668 110414 2 19 419X 18TH AVE 15 1 1 10 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
145040 104625 2 21 250 04th St 3 1 1 1 10     3x3 Permit Number 770961 6012050.5 2112960.1 37.7824643544146 -122.40196713530099 (37.7824643544146, -122.401967135301)
151790 104620 2 21 800 Folsom St 3 1 1 1 10   10 4x4 Permit Number 770959 6012183.3573 2112747.2558 37.7818873476901 -122.401492540712 (37.7818873476901, -122.401492540712)
164897 104619 2 21 800 Folsom St 2 1 1 1 10   7 4x4 Permit Number 770959 6012190.226 2112753.6665 37.781905333235294 -122.401469228728 (37.7819053332353, -122.401469228728)
27975 107435 2 340 418 19th Ave 2 1 1 1 9   32 3x3   5990007.15475 2112492.97382 37.779926833827794 -122.478192501966 (37.7799268338278, -122.478192501966)
1905 251810 2 11 2 Hangah St 3 20 1 10 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
1912 251809 2 11 2 Hangah St 2 20 1 10 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
1919 251807 2 160 2 Hangah St 1 20 1 10 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
1921 251811 2 11 2 Hangah St 4 20 1 10 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
1923 251813 2 160 2 Hangah St 6 20 1 10 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
4715 103364 2 15 1171X Sacramento St 3 1 1 1 7   3 3x3   6009173.30525 2116699.27717 37.79257023366971 -122.412185363057 (37.7925702336697, -122.412185363057)
5817 103362 2 15 1171X Sacramento St 1 1 1 1 7   12 3x3   6009111.87446 2116690.2667799997 37.7925420462198 -122.41239727931601 (37.7925420462198, -122.412397279316)
6038 103363 2 15 1171X Sacramento St 2 1 1 1 7   12 3x3   6009142.2805 2116694.47646 37.79255531122121 -122.412292370693 (37.7925553112212, -122.412292370693)
6622 103365 2 15 1171X Sacramento St 4 1 1 1 7   12 3x3   6009208.54849 2116702.7837799997 37.7925818394263 -122.412063667702 (37.7925818394263, -122.412063667702)
43364 115743 2 43 1X POND ST 1 1 1 14 7   28 3x3   6003250.0 2106477.0 37.764168263011996 -122.43194992880301 (37.764168263012, -122.431949928803)
79827 103361 2 15 1000X Taylor St 10 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
83849 103357 2 15 1000X Taylor St 6 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
88405 103359 2 15 1000X Taylor St 8 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
89814 103355 2 15 1000X Taylor St 4 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
91178 103360 2 15 1000X Taylor St 9 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
97748 115748 2 43 1X POND ST 6 1 1 14 7   24 3x3   6003250.0 2106477.0 37.764168263011996 -122.43194992880301 (37.764168263012, -122.431949928803)
98818 115746 2 43 1X POND ST 4 1 1 14 7   28 3x3   6003250.0 2106477.0 37.764168263011996 -122.43194992880301 (37.764168263012, -122.431949928803)
100121 115744 2 43 1X POND ST 2 1 1 14 7   24 3x3   6003250.0 2106477.0 37.764168263011996 -122.43194992880301 (37.764168263012, -122.431949928803)
100271 115747 2 43 1X POND ST 5 1 1 14 7   16 3x3   6003250.0 2106477.0 37.764168263011996 -122.43194992880301 (37.764168263012, -122.431949928803)
103230 115745 2 43 1X POND ST 3 1 1 14 7   20 3x3   6003250.0 2106477.0 37.764168263011996 -122.43194992880301 (37.764168263012, -122.431949928803)
120938 103358 2 15 1000X Taylor St 7 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
139014 103352 2 15 1000X Taylor St 1 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
140230 103354 2 15 1000X Taylor St 3 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
140679 103356 2 15 1000X Taylor St 5 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
145238 103353 2 15 1000X Taylor St 2 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
172264 116139 2 15 1171X Sacramento St 5 1 1 1 7   11     6009237.30915 2116708.0838099997 37.7925980056535 -122.411964529145 (37.7925980056535, -122.411964529145)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
891 251304 2 1 1 Cashmere St 3 13 1 1 5     3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
1493 103663 2 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
4475 253631 2 49 39 Mason St 1 1 1 1 4         6009957.290080001 2113442.89538 37.783672949399204 -122.409242840109 (37.7836729493992, -122.409242840109)
5598 103666 2 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7764 103662 2 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8408 103664 2 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
10665 103665 2 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
Powered by Datasette · Query took 63.894ms · Data source: data.sfgov.org