sf-trees

Data source: data.sfgov.org

Custom SQL query returning 16 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
23101 4130 3 8 3550 Cesar Chavez St 1 1 1 2   09/27/1995 12:00:00 AM 4 3x3   6006437.45796 2100604.55432 37.748224069995295 -122.42050853554501 (37.7482240699953, -122.420508535545)
37799 183676 2 8 3710 Irving St 1 1 1 1     4 Width 0ft   5984252.2399 2106352.1361 37.7627301098016 -122.497647481121 (37.7627301098016, -122.497647481121)
39608 119979 2 8 286 27th Ave 1 1 1 1     4 Width 3ft   5987467.13814 2114050.95667 37.7840568428401 -122.487093893766 (37.7840568428401, -122.487093893766)
41700 87109 1 8 1358 35th Ave 1 1 1 1   12/31/2007 12:00:00 AM 4 3x3 Permit Number 50058 5985264.3746 2105978.0640000002 37.761762290042704 -122.49411934585301 (37.7617622900427, -122.494119345853)
43517 208531 2 8 136 Garfield St 1 4 1 1     4 Width 3ft   5993591.87174 2090510.0333599998 37.7197747266151 -122.464195105813 (37.7197747266151, -122.464195105813)
61771 201441 2 8 50 Middle Point Rd 1 2 1 1     4 Width 5ft   6018208.2556 2096140.7000900002 37.7366235404482 -122.37949498601601 (37.7366235404482, -122.379494986016)
64712 69313 1 8 1599 30th Ave 1 1 1 1 1 03/16/1994 12:00:00 AM 4   Permit Number 33392 5986810.4893 2104771.5308 37.758539831018 -122.488683338527 (37.758539831018, -122.488683338527)
66245 30695 1 8 15 Hermann St 1 1 1 1 1 11/03/2001 12:00:00 AM 4   Permit Number 34611 6005182.95707 2108838.8706099996 37.7707627855907 -122.425432476641 (37.7707627855907, -122.425432476641)
147495 231151 2 8 3101 Cesar Chavez St 1 1 1 1     4 Width 3ft   6009109.901219999 2100538.836 37.7481938662608 -122.411262629885 (37.7481938662608, -122.411262629885)
148373 52563 1 8 1275 40th Ave 1 1 1 1 1 01/12/2006 12:00:00 AM 4   Permit Number 48660 5983651.2644 2106493.3098 37.7630824862581 -122.49973644381399 (37.7630824862581, -122.499736443814)
149559 229189 2 8 3281 Cesar Chavez St 1 1 1 1     4 Width 3ft   6007838.5569 2100529.3417599997 37.748096413035796 -122.415658239036 (37.7480964130358, -122.415658239036)
151833 229188 2 8 3287 Cesar Chavez St 1 2 1 1     4 Width 5ft   6007796.6026099995 2100528.4399 37.748091578262795 -122.415803252021 (37.7480915782628, -122.415803252021)
154617 231171 2 8 2950 Cesar Chavez St 1 1 1 1     4 Width 3ft   6009778.821959999 2100624.5586900003 37.7484667349686 -122.408955560378 (37.7484667349686, -122.408955560378)
166950 229198 2 8 3351 23rd St 1 1 1 1     4 Width 3ft   6006464.802019999 2102585.11894 37.7536637884725 -122.420554550246 (37.7536637884725, -122.420554550246)
180205 42599 1 8 2222 Clay St 1 1 1 1 1 06/26/2000 12:00:00 AM 4   Permit Number 42669 6003877.92614 2116329.40578 37.7912561101206 -122.43048114921301 (37.7912561101206, -122.430481149213)
181395 246447 2 8 449 Duncan St 1 4 1 1     4 Width 3ft   6003605.22415 2099791.4643200003 37.74583149562061 -122.43024431183399 (37.7458314956206, -122.430244311834)
Powered by Datasette · Query took 5.879ms · Data source: data.sfgov.org