sf-trees

Data source: data.sfgov.org

Custom SQL query returning 26 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
11095 17586 3 46 801X Persia Ave 10 1 1 2     18 3x3   6003709.25966 2090367.0753099998 37.7199601443381 -122.42921268601499 (37.7199601443381, -122.429212686015)
28480 198590 2 46 980 16th St 10 1 1 1     3 Width 4ft   6013501.44813 2107135.10099 37.766551094088996 -122.39653900576599 (37.766551094089, -122.396539005766)
39642 198442 2 46 500 Mariposa St 10 1 1 1     3 Width 6ft   6015430.62355 2106285.94365 37.7643266659781 -122.389806954341 (37.7643266659781, -122.389806954341)
41121 242505 2 46 2618 Folsom St 10 1 1 1     19 Width 4ft   6008253.8889999995 2102895.90395 37.754617798278204 -122.414389457507 (37.7546177982782, -122.414389457507)
74871 97841 1 46 900 Minnesota St 10 1 1 1     15     6015209.75012 2104419.2004 37.7591887410927 -122.390440457463 (37.7591887410927, -122.390440457463)
87917 108237 2 46 131 RUSS ST 10 1 1 1       4x4   6010302.0 2111707.0 37.7789258960759 -122.407927816208 (37.7789258960759, -122.407927816208)
113193 16447 3 46 1395 Newcomb Ave 10 1 1 2   02/10/2012 12:00:00 AM 3 3x3   6016285.996927 2094866.0167389999 37.733017311739104 -122.386052291775 (37.7330173117391, -122.386052291775)
118193 17927 3 46 2397X Pine St 10 1 1 2     4 3X3   6002488.019783099 2115056.9941341 37.787683560918495 -122.435199131446 (37.7876835609185, -122.435199131446)
71828 198651 2 46 421 Mission Bay Blvd North 10 2 1 1     6     6016332.95432 2108773.69506 37.7712074895574 -122.386859524348 (37.7712074895574, -122.386859524348)
137069 198572 2 46 400 01st St 10 2 1 1     10 Width 6ft   6014810.33886 2114095.2184 37.785734773695395 -122.392498644996 (37.7857347736954, -122.392498644996)
149371 198636 2 46 419 Mission Bay Blvd North 10 2 1 1     5     6015870.564680001 2108748.5584299997 37.771112857499 -122.38845720776001 (37.771112857499, -122.38845720776)
161224 198462 2 46 700 Mariposa St 10 2 1 1     1 Width 6ft   6014805.14744 2106272.7941799997 37.7642558551341 -122.391969398478 (37.7642558551341, -122.391969398478)
162785 198610 2 46 456 Mission Bay Blvd South 10 2 1 1     5     6016166.070780001 2108644.55968 37.770843670618504 -122.38742777629601 (37.7708436706185, -122.387427776296)
188022 198621 2 46 454 Mission Bay Blvd South 10 2 1 1     5     6015788.5708800005 2108619.95844 37.7707552061109 -122.388731850804 (37.7707552061109, -122.388731850804)
133946 198657 2 46 1670 Owen St 10 9 1 1     4 Width 8ft   6013998.084530001 2107337.5024 37.7671344699085 -122.39483539216499 (37.7671344699085, -122.394835392165)
1222 119837 3 46 301x Octavia St 10 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
67382 244287 3 46 201x Octavia St 10 11 1 2     6 Width 0ft   6005585.9927 2110033.3819999998 37.7740653890161 -122.424123330561 (37.7740653890161, -122.424123330561)
69750 244330 3 46 100x Octavia St 10 11 1 2     7 Width 0ft   6005665.121 2109878.6077 37.7736448835433 -122.42383860414199 (37.7736448835433, -122.423838604142)
73396 244466 3 46 101x Octavia St 10 11 1 2     6 Width 0ft   6005631.2066 2109707.3231 37.7731726627699 -122.423943736898 (37.7731726627699, -122.423943736898)
85315 119826 3 46 302x Octavia St Frontage East 10 11 1 2           2110484.0 6005595.0 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)
96137 119790 3 46 202x Octavia St Frontage East 10 11 1 2           2110143.0 6005643.0 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)
99951 119755 3 46 106x Octavia St Frontage West 10 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
124457 119717 3 46 102x Octavia St Frontage East 10 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
147182 244399 3 46 200x Octavia St 10 11 1 2     5 Width 0ft   6005618.8355 2110208.2889 37.7745474953334 -122.424022162207 (37.7745474953334, -122.424022162207)
166112 244308 3 46 300x Octavia St 10 11 1 2     7 Width 0ft   6005570.3518 2110556.8538 37.7755018326332 -122.424214672145 (37.7755018326332, -122.424214672145)
170608 244363 3 46 301x Octavia St 10 11 1 2     8 Width 0ft   6005533.5243 2110362.3292 37.7749656357807 -122.42432822890801 (37.7749656357807, -122.424328228908)
Powered by Datasette · Query took 9.607ms · Data source: data.sfgov.org