sf-trees

Data source: data.sfgov.org

Custom SQL query returning 38 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
13285 187639 4 31 1671 34th Ave 1 1 1 1   02/22/2017 12:00:00 AM 3 3x6   5985585.0 2103854.0 37.7559489545124 -122.492853989295 (37.7559489545124, -122.492853989295)
17013 16027 1 31 160 Monterey Blvd 1 1 1 1   02/23/2005 12:00:00 AM 3 3X3   6001078.56062 2094701.12537 37.7317111799206 -122.43861646769899 (37.7317111799206, -122.438616467699)
19758 4166 3 31 3771 Cesar Chavez St 1 1 1 2   10/18/1999 12:00:00 AM 3 3X3   6005390.77926 2100476.4482400003 37.747813278574 -122.424118813557 (37.747813278574, -122.424118813557)
80434 30020 3 31 710X San Jose Ave 12 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005718.76576524 2099005.5772577 37.7437931149581 -122.42288013057501 (37.7437931149581, -122.422880130575)
82547 30021 3 31 710X San Jose Ave 13 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005718.76576524 2099005.5772577 37.7437931149581 -122.42288013057501 (37.7437931149581, -122.422880130575)
83323 30003 3 31 610X San Jose Ave 15 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6006030.83928578 2099887.5672939997 37.74623246341729 -122.42186369026399 (37.7462324634173, -122.421863690264)
138600 30004 3 31 610X San Jose Ave 16 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6006030.83928578 2099887.5672939997 37.74623246341729 -122.42186369026399 (37.7462324634173, -122.421863690264)
168702 241202 2 31 154 Highland Ave 1 1 1 1     3 Width 3ft   6005836.15299 2096624.2788099998 37.7372612281114 -122.42230507703 (37.7372612281114, -122.42230507703)
174334 241198 2 31 106 Chattanooga St 5 10 1 1     3 Width 4ft   6004702.81282 2102995.20065 37.754690319613296 -122.426677105059 (37.7546903196133, -122.426677105059)
180078 241183 2 31 1720 Dolores St 5 9 1 1     3 Width 3ft   6005264.11037 2098316.58265 37.7418756279601 -122.424403226839 (37.7418756279601, -122.424403226839)
184005 197977 2 31 1301 Minnesota St 73 7 1 1     3     6015364.560269999 2102275.50149 37.7533111867689 -122.389755314382 (37.7533111867689, -122.389755314382)
184272 241184 2 31 1720 Dolores St 8 9 1 1     3 Width 3ft   6005265.18206 2098303.13157 37.7418387548635 -122.424398564767 (37.7418387548635, -122.424398564767)
24952 34654 1 31 2000 Kirkham St 2 1 1 1 1 07/28/1997 12:00:00 AM 3   Permit Number 38332 5988619.0903 2105142.8889 37.7596648557466 -122.482455667505 (37.7596648557466, -122.482455667505)
128783 44007 1 31 2701X 17th St 3 1 1 1   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 3 on 17th St 6009464.30573862 2106385.10315991 37.7642662704227 -122.41044985886299 (37.7642662704227, -122.410449858863)
106791 44009 1 31 2701X 17th St 1 1 1 1   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 1 on 17th St 6009464.30573862 2106385.10315991 37.7642662704227 -122.41044985886299 (37.7642662704227, -122.410449858863)
108893 44008 1 31 2701X 17th St 2 1 1 1   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 2 on 17th St 6009464.30573862 2106385.10315991 37.7642662704227 -122.41044985886299 (37.7642662704227, -122.410449858863)
143287 44011 1 31 405X Florida St 2 1 1 1   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 2 on Florida 6009464.30573862 2106385.10315991 37.7642662704227 -122.41044985886299 (37.7642662704227, -122.410449858863)
81608 44006 1 31 2701X 17th St 4 1 1 1   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 4 on 17th St 6009464.30573862 2106385.10315991 37.7642662704227 -122.41044985886299 (37.7642662704227, -122.410449858863)
81701 52306 1 31 715 Buena Vista Ave West 3 1 1 1   07/29/2016 12:00:00 AM 3   Permit Number 48465 5999876.8 2107852.1 37.7677521370965 -122.443715612896 (37.7677521370965, -122.443715612896)
128411 52305 1 31 715 Buena Vista Ave West 2 1 1 1   07/29/2016 12:00:00 AM 3   Permit Number 48465 5999876.8 2107852.1 37.7677521370965 -122.443715612896 (37.7677521370965, -122.443715612896)
3525 253489 4 31 1x Gordon St 7 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3532 253483 4 31 1x Gordon St 1 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3533 253491 4 31 1x Gordon St 9 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3538 253485 4 31 1x Gordon St 3 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3546 253495 4 31 1x Gordon St 13 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3553 253492 4 31 1x Gordon St 10 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3554 253490 4 31 1x Gordon St 8 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3555 253487 4 31 1x Gordon St 5 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3562 253488 4 31 1x Gordon St 6 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3563 253493 4 31 1x Gordon St 11 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3573 253496 4 31 1x Gordon St 14 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3581 253486 4 31 1x Gordon St 4 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3582 253484 4 31 1x Gordon St 2 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3587 253494 4 31 1x Gordon St 12 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
87190 106452 1 31 56 Lucy St 1 1 1 1   04/28/2014 12:00:00 AM 3   Permit Number 772906 6014092.7 2093830.3 37.7300518134974 -122.393562691323 (37.7300518134974, -122.393562691323)
6292 87392 1 31 3322 Fillmore St 2 1 1 1   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773384 6002333.63287 2119648.2941900003 37.800281314083705 -122.43606195061199 (37.8002813140837, -122.436061950612)
6671 87391 1 31 3322 Fillmore St 1 1 1 1   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773384 6002335.87278 2119635.99284 37.800247665053 -122.43605331890801 (37.800247665053, -122.436053318908)
54785 66435 1 31 154 Highland Ave 1 1 1 1 1 01/29/2016 12:00:00 AM 3   Permit Number 776442 6005832.64379623 2096619.46427693 37.7372478105316 -122.422316867971 (37.7372478105316, -122.422316867971)
Powered by Datasette · Query took 5.976ms · Data source: data.sfgov.org