sf-trees

Data source: data.sfgov.org

Custom SQL query returning 21 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1409 251514 6 3 99x Mountview Ct 2 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1608 251603 6 47 44R Amber Dr 2 13 1 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1609 251630 6 47 8R Amethyst Way 2 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1611 251605 6 108 48R Amber Dr 2 13 1 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1616 251607 6 3 52R Amber Dr 2 13 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1623 251613 6 47 60R Amber Dr 2 13 1 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1637 251619 6 47 72R Amber Dr 2 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1646 251633 6 47 14R Amethyst Way 2 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1651 251609 6 47 56R Amber Dr 2 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
19360 105328 6 17 2051 03rd St 2 13 1 1         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631)
60806 96274 6 41 55@ Alemany Trumbull St 2 13 1 1     2     6004001.3006 2094332.0064299998 37.7308634942567 -122.428485665086 (37.7308634942567, -122.428485665086)
82211 115446 6 17 546 FRANCONIA ST 2 13 1 1   04/01/2016 12:00:00 AM 3 3x3 Permit Number 777844 6009931.0 2098208.0 37.7418399166086 -122.40825891223801 (37.7418399166086, -122.408258912238)
86911 87150 6 116 4 Bellair Pl 2 13 1 1         Permit Number 50135 6010093.0 2120950.0 37.8042932388788 -122.409303278994 (37.8042932388788, -122.409303278994)
87905 100771 6 108 450 Hayes St 2 13 1 1         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899)
90919 112420 6 357 268 Lily St 2 13 1 1   07/29/2015 12:00:00 AM 3     6005334.87738 2110100.0463 37.7742342515583 -122.42499672664302 (37.7742342515583, -122.424996726643)
91632 87216 6 502 500 Cortland Ave 2 13 1 1   02/08/2008 12:00:00 AM   3x3 Permit Number 50224 6007640.7 2097187.4 37.7389090609704 -122.416105779709 (37.7389090609704, -122.416105779709)
111685 107343 6 116 110 JULIAN AVE 2 13 1 1     15     6006340.8 2107214.1 37.7663669011591 -122.421312071366 (37.7663669011591, -122.421312071366)
125077 87149 6 116 4 Bellair Pl 2 13 1 1           6010093.0 2120950.0 37.8042932388788 -122.409303278994 (37.8042932388788, -122.409303278994)
140306 98695 6 338 191@Clarendon Forest Knolls Dr 2 13 1 1   05/01/2012 12:00:00 AM     Permit Number 768674 5996330.9 2103059.9 37.754391095173794 -122.455633951336 (37.7543910951738, -122.455633951336)
143929 92898 6 103 208 States St 2 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
144323 115460 6 17 80 Crestline Dr 2 13 1 1   02/02/2016 12:00:00 AM 3   Permit Number 776150 5999012.8 2102131.7 37.7519960240451 -122.446292521132 (37.7519960240451, -122.446292521132)
Powered by Datasette · Query took 12.613ms · Data source: data.sfgov.org