sf-trees

Data source: data.sfgov.org

Custom SQL query returning 23 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
76 241180 1 31 300 Duboce Ave 3 7 1 1   02/20/2001 12:00:00 AM 7 Width 3ft Permit Number 43693 6004770.13014 2108408.30025 37.7695572102182 -122.426829784767 (37.7695572102182, -122.426829784767)
90 241179 1 31 300 Duboce Ave 2 7 1 1   02/20/2001 12:00:00 AM 7 Width 3ft Permit Number 43693 6004783.47466 2108409.88584 37.769562318364 -122.426783739481 (37.769562318364, -122.426783739481)
29943 83166 1 31 1089 Gilman Ave 1 1 1 1   07/02/2009 12:00:00 AM 7 3x3 Permit Number 52361 6015096.6014 2089812.1317 37.719074451264 -122.389811494874 (37.719074451264, -122.389811494874)
59569 115612 1 31 1400 16th St 2 1 1 1     7 4x4   6012209.3182 2107055.3618 37.7662601539356 -122.401002678345 (37.7662601539356, -122.401002678345)
172140 115615 1 31 1400 16th St 5 1 1 1     7 4x4   6012069.0366 2107045.8512 37.766226213653 -122.40148722008699 (37.766226213653, -122.401487220087)
24481 117708 2 31 4001 Clement St 2 9 1 1     7 Width 7ft   5983029.04687 2113077.7485700003 37.7811249212832 -122.50237578006501 (37.7811249212832, -122.502375780065)
27219 215426 2 31 15 Fairfield Way 2 1 1 1     7 Width 3ft   5993822.27885 2092914.3969599998 37.7263898041365 -122.463573079846 (37.7263898041365, -122.463573079846)
31251 241193 2 31 699 Hampshire St 1 1 1 1     7 Width 3ft   6010149.76354 2105082.07302 37.7607268479899 -122.40798714698299 (37.7607268479899, -122.407987146983)
33234 215420 2 31 2085 09th Ave 2 2 1 1     7 Width 3ft   5993528.81827 2101394.66819 37.7496575974161 -122.46520324492799 (37.7496575974161, -122.465203244928)
47759 241195 2 31 699 Hampshire St 3 1 1 1     7 Width 3ft   6010149.3192300005 2105113.8429400004 37.7608140561404 -122.407990924146 (37.7608140561404, -122.407990924146)
59497 215415 2 31 484 Faxon Ave 8 9 1 1     7 Width 3ft   5994798.18805 2091784.9127099998 37.7233446951982 -122.460117638125 (37.7233446951982, -122.460117638125)
60023 241192 2 31 3630 20th St 3 10 1 1     7 Width 3ft   6006049.00576 2104357.91631 37.7585080370469 -122.42211840383499 (37.7585080370469, -122.422118403835)
71330 179970 2 31 307 Athens St 2 1 1 1     7 Width 4ft   6004288.05392 2091472.8528 37.7230291158735 -122.42729072060101 (37.7230291158735, -122.427290720601)
72724 247212 2 31 800 Duboce Ave 11 2 1 1     7 Width 3ft   6001824.5154099995 2108284.91798 37.7690514458872 -122.437009703838 (37.7690514458872, -122.437009703838)
130541 199802 2 31 1350 Donner Ave 8 1 1 1     7 Width 0ft   6015069.8022 2090954.144 37.7222087062567 -122.389983862743 (37.7222087062567, -122.389983862743)
135321 215425 2 31 15 Fairfield Way 1 1 1 1     7 Width 3ft   5993828.92178 2092931.25645 37.7264364789445 -122.463551338741 (37.7264364789445, -122.463551338741)
148653 215421 2 31 2085 09th Ave 1 2 1 1     7 Width 3ft   5993516.19097 2101401.9668400004 37.74967690946279 -122.46524744032101 (37.7496769094628, -122.465247440321)
149959 197978 2 31 1100 Mariposa St 1 1 1 1     7 Width 4ft   6013947.00765 2106209.45605 37.764034263084504 -122.394933045925 (37.7640342630845, -122.394933045925)
152480 241225 2 31 4049 17th St 1 1 1 1     7 Width 2ft   6001920.58101 2105839.72544 37.7623430070574 -122.43650238277901 (37.7623430070574, -122.436502382779)
157670 241194 2 31 699 Hampshire St 2 1 1 1     7 Width 3ft   6010150.13435 2105098.1288099997 37.7607709543248 -122.4079869968 (37.7607709543248, -122.4079869968)
178635 182656 2 31 2618 Ortega St 3 2 1 1     7 Width 0ft   5985872.0635 2102330.847 37.7517835760889 -122.491749119446 (37.7517835760889, -122.491749119446)
181600 241204 2 31 2399 Folsom St 2 1 1 1     7 Width 4ft   6008220.32471 2104519.20022 37.759073114347295 -122.414620398932 (37.7590731143473, -122.414620398932)
188676 241203 2 31 2399 Folsom St 1 1 1 1     7 Width 4ft   6008221.76709 2104500.66986 37.759022315257894 -122.414614099173 (37.7590223152579, -122.414614099173)
Powered by Datasette · Query took 3.17ms · Data source: data.sfgov.org