sf-trees

Data source: data.sfgov.org

Custom SQL query returning 30 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1119 38280 1 52 651 Texas St 9 1 1 1   07/27/1998 12:00:00 AM 12   Permit Number 40367 6013876.1493 2104054.9950099997 37.758114643000795 -122.395027213942 (37.7581146430008, -122.395027213942)
4895 69228 1 52 537 Grove St 1 1 1 1 1 01/31/1994 12:00:00 AM 12 7x7 Permit Number 33281 6005209.5873 2111278.8914 37.7774639950364 -122.425514041455 (37.7774639950364, -122.425514041455)
13611 27142 3 52 1775 Silver Ave 3 1 1 2     12 2X3   6011388.172669999 2095338.5375299999 37.7340424699754 -122.40301867507401 (37.7340424699754, -122.403018675074)
14097 27140 3 52 1775 Silver Ave 1 1 1 2     12 2X3   6011410.17472 2095355.19259 37.7340894298873 -122.40294377776002 (37.7340894298873, -122.40294377776)
16487 32962 1 52 952 Minnesota St 1 1 1 1 1 11/01/1996 12:00:00 AM 12 6x12 Permit Number 37276 6015219.88415 2104168.1362900003 37.7584999350397 -122.39038786691299 (37.7584999350397, -122.390387866913)
17784 18386 3 52 816 Potrero Ave 1 1 1 2   09/03/1997 12:00:00 AM 12 3X3   6010411.4798 2104364.47697 37.7587711399879 -122.407031402383 (37.7587711399879, -122.407031402383)
20704 26501 3 52 2752 Harrison St 1 1 1 2     12 3x3   6008910.69527 2102429.93481 37.7533752266066 -122.41208510844801 (37.7533752266066, -122.412085108448)
21333 28065 3 52 2576 Bryant St 1 1 1 2   03/13/2001 12:00:00 AM 12 3X3   6009719.0461099995 2102350.04498 37.753201188885605 -122.409284012572 (37.7532011888856, -122.409284012572)
23435 226459 2 52 3242 18th St 1 1 1 1     12 Width 3ft   6007896.86765 2105631.29342 37.762108488128796 -122.41581781745899 (37.7621084881288, -122.415817817459)
28716 226385 2 52 352 Coleridge St 1 1 1 1     12 Width 3ft   6006123.1231 2098057.1404 37.7412117286404 -122.421414615119 (37.7412117286404, -122.421414615119)
57800 190715 2 52 350 Texas St 1 4 1 1     12 Width 4ft   6013737.51284 2105460.97147 37.7619674375704 -122.395605187539 (37.7619674375704, -122.395605187539)
60833 226797 2 52 3970 20th St 1 1 1 1     12 Width 3ft   6003894.50507 2104240.41525 37.7580636523416 -122.429561252457 (37.7580636523416, -122.429561252457)
64595 229736 2 52 1446 Florida St 1 1 1 1     12 Width 4ft   6009548.10461 2100752.4115 37.748804863855604 -122.409762403312 (37.7488048638556, -122.409762403312)
66402 229837 2 52 226 San Carlos St 1 1 1 1     12 Width 3ft   6006672.14762 2104765.95957 37.759663556138 -122.41999225186301 (37.759663556138, -122.419992251863)
69857 226395 2 52 1467 Shotwell St 1 1 1 1     12 Width 3ft   6008034.1838 2099620.63234 37.7456122948636 -122.414917460292 (37.7456122948636, -122.414917460292)
70237 32980 1 52 553 Texas St 1 1 1 1 1 11/01/1996 12:00:00 AM 12   Permit Number 37293 6013848.61872 2104519.0613700002 37.7593873374867 -122.39515493295201 (37.7593873374867, -122.395154932952)
76883 226323 2 52 1139 Shotwell St 1 1 1 1     12 Width 3ft   6008076.0678 2101289.03077 37.7501956968847 -122.414890691951 (37.7501956968847, -122.414890691951)
78165 34059 1 52 1736 Bryant St 1 1 1 1   07/05/1997 12:00:00 AM 12 6x7 Permit Number 37961 6009447.37701969 2106694.23265708 37.7651141201322 -122.410530241296 (37.7651141201322, -122.410530241296)
79747 37675 1 52 3318 20th St 1 1 1 1 1 06/29/1998 12:00:00 AM 12 3x3 Permit Number 40071 6008076.0 2104474.0 37.758940895326 -122.415116344354 (37.758940895326, -122.415116344354)
120446 229783 2 52 975 San Bruno Ave 1 10 1 1     12 Width 4ft   6011090.02369 2103815.82999 37.7573026253193 -122.404646049572 (37.7573026253193, -122.404646049572)
125800 37663 1 52 3236 18th St 2 1 1 1 1 06/29/1998 12:00:00 AM 12 6x6 Permit Number 40069 6007902.47556564 2105636.26552701 37.7621224556474 -122.41579877386101 (37.7621224556474, -122.415798773861)
137114 226401 2 52 96 Manchester St 1 1 1 1     12 Width 3ft   6008220.52934 2099483.50303 37.74524623751729 -122.414263403134 (37.7452462375173, -122.414263403134)
137527 229876 2 52 231 27th St 1 1 1 1     12 Width 4ft   6004828.77791 2100152.4422299997 37.746891885367 -122.42603912601001 (37.746891885367, -122.42603912601)
137999 226461 2 52 2080 17th St 1 1 1 1     12 Width 3ft   6008035.4164 2106222.9796700003 37.7637409096456 -122.415380518518 (37.7637409096456, -122.415380518518)
153299 229859 2 52 800 Hampshire St 3 1 1 1     12 Width 3ft   6010147.5039099995 2104457.87286 37.7590128085149 -122.407950942988 (37.7590128085149, -122.407950942988)
157701 35349 1 52 1162 De Haro St 1 1 1 1 1 02/23/1998 12:00:00 AM 12   Permit Number 38812 6012188.571690001 2103037.2823900003 37.7552262409021 -122.400792120955 (37.7552262409021, -122.400792120955)
165158 226371 2 52 626 29th St 1 1 1 1     12 Width 3ft   6002431.857369999 2098894.2222599997 37.743301348371794 -122.43423751036 (37.7433013483718, -122.43423751036)
179360 226405 2 52 1405 Shotwell St 1 1 1 1     12 Width 3ft   6008013.30182 2099943.8587 37.746498628924996 -122.415012541103 (37.746498628925, -122.415012541103)
185078 226762 2 52 62 28th St 1 1 1 1     12 Width 3ft   6005544.98011 2099653.8434200003 37.745563298918704 -122.42352711990101 (37.7455632989187, -122.423527119901)
186891 226458 2 52 3318 20th St 1 1 1 1     12 Width 3ft   6008112.40239 2104471.67491 37.7589365568012 -122.41499028288 (37.7589365568012, -122.41499028288)
Powered by Datasette · Query took 10.522ms · Data source: data.sfgov.org