sf-trees

Data source: data.sfgov.org

Custom SQL query returning 35 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
188538 204729 2 58 400 Junipero Serra Blvd 16 4 1 1     1 Width 0ft   5991368.5463 2094108.06034 37.729525618690204 -122.47214240847 (37.7295256186902, -122.47214240847)
130324 123045 2 58 568 Funston Ave 2 2 1 1     1 Width 3ft   5991929.81513 2111594.03006 37.777569997766705 -122.47147570428301 (37.7775699977667, -122.471475704283)
153957 218236 2 58 353 Wawona St 1 4 1 1     1 Width 3ft   5991977.13565 2097137.64691 37.7378793033766 -122.47025900595101 (37.7378793033766, -122.470259005951)
38985 123068 2 58 678 12th Ave 2 1 1 1     1 Width 3ft   5992266.69336 2110864.34538 37.7755859643914 -122.47025718989201 (37.7755859643914, -122.470257189892)
165838 59091 1 58 3524 Fulton St 1 1 1 1   04/23/1980 12:00:00 AM 1   Permit Number 18392 5992426.174880001 2110042.4468799997 37.77333847202161 -122.46964566266001 (37.7733384720216, -122.46964566266)
35603 204716 2 58 155 Madrone Ave 3 1 1 1     1 Width 3ft   5992699.213880001 2098207.72713 37.7408591943976 -122.467840257748 (37.7408591943976, -122.467840257748)
171203 204735 2 58 40 Vasquez Ave 2 1 1 1     1 Width 3ft   5995650.24765 2100035.09823 37.746046665624 -122.457768945275 (37.746046665624, -122.457768945275)
172403 204736 2 58 40 Vasquez Ave 4 1 1 1     1 Width 3ft   5995677.52131 2100065.8007099996 37.7461325337836 -122.457676858293 (37.7461325337836, -122.457676858293)
185050 204744 2 58 545 Melrose Ave 2 9 1 1     1 Width 6ft   5996927.5801099995 2095415.2897 37.733435093958896 -122.453018700168 (37.7334350939589, -122.453018700168)
52474 204720 2 58 60 Agua Way 1 1 1 1     1 Width 2ft   5997138.083869999 2098588.27013 37.7421593919444 -122.452519836329 (37.7421593919444, -122.452519836329)
63826 204741 2 58 843 Detroit St 1 1 1 1     1 Width 3ft   5999425.99834 2095633.84899 37.734178072446205 -122.444396695552 (37.7341780724462, -122.444396695552)
105228 57041 1 58 200 Central Ave 1 1 1 1   06/12/2015 12:00:00 AM 1   Permit Number 31232 5999893.57375842 2109179.37340811 37.7713974526383 -122.443752960181 (37.7713974526383, -122.443752960181)
48921 204737 2 58 230 Acadia St 1 1 1 1     1 Width 3ft   6001436.76661 2095116.79206 37.7328728755875 -122.43740783373 (37.7328728755875, -122.43740783373)
44119 222706 2 58 4218 24th St 1 1 1 1     1 Width 3ft   6001708.51992 2101780.94195 37.7511865150679 -122.43694523773199 (37.7511865150679, -122.436945237732)
187407 175800 2 58 701 Madrid St 1 1 1 1     1 Width 2ft   6001959.2202699995 2089802.6495400001 37.71831113034379 -122.43522160969401 (37.7183111303438, -122.435221609694)
28752 222686 2 58 1201 San Jose Ave 17 7 1 1     1     6004284.84781 2095906.59844 37.735203011805204 -122.427617536921 (37.7352030118052, -122.427617536921)
149164 175811 2 58 15 Athens St 1 9 1 1     1     6005336.45581 2093162.3032099998 37.727727212929004 -122.423786672331 (37.727727212929, -122.423786672331)
39239 175813 2 58 15 Athens St 3 9 1 1     1     6005348.05368 2093155.48995 37.727709159929105 -122.42374609402201 (37.7277091599291, -122.423746094022)
49828 222696 2 58 73 Leese St 1 1 1 1     1 Width 3ft   6005530.879319999 2096284.28114 37.736310445970204 -122.423336387162 (37.7363104459702, -122.423336387162)
53901 222695 2 58 52 Mirabel Ave 1 1 1 1     1 Width 3ft   6007649.81084 2099951.99688 37.746500541785394 -122.416270032545 (37.7465005417854, -122.416270032545)
137834 175805 2 58 35 Ervine St 1 1 1 1     1 Width 2ft   6009673.12409 2089221.0725599998 37.7171492746007 -122.408516774841 (37.7171492746007, -122.408516774841)
156475 175816 2 58 616 Dwight St 2 1 1 1     1 Width 3ft   6009781.28405 2091163.7033900002 37.7224893931511 -122.40827985473699 (37.7224893931511, -122.408279854737)
37117 175815 2 58 616 Dwight St 1 1 1 1     1 Width 3ft   6009798.67948 2091167.8757200001 37.722501823573 -122.40822001654301 (37.722501823573, -122.408220016543)
40369 222690 2 58 1071 Hampshire St 1 1 1 1     1 Width 4ft   6010267.11643 2102987.22407 37.754981431951606 -122.40743358371901 (37.7549814319516, -122.407433583719)
170167 222677 2 58 1498 Hampshire St 1 1 1 1     1 Width 3ft   6010454.79524 2100826.85949 37.749060050992604 -122.40663230034201 (37.7490600509926, -122.406632300342)
56499 222681 2 58 2318 22nd St 1 2 1 1     1     6011232.98207 2103716.09635 37.7570367677534 -122.404144621787 (37.7570367677534, -122.404144621787)
24848 188408 2 58 2033 22nd St 2 9 1 1     1 Width 3ft   6011976.80987 2103707.86259 37.7570556930855 -122.40157158857299 (37.7570556930855, -122.401571588573)
178316 202043 2 58 52 Exeter St 2 4 1 1     1 Width 3ft   6012522.16713 2090984.69593 37.722150974681604 -122.398792625891 (37.7221509746816, -122.398792625891)
77059 188411 2 58 398 Mississippi St 2 4 1 1     1 Width 3ft   6014024.24871 2105357.36092 37.7616988910081 -122.394606216998 (37.7616988910081, -122.394606216998)
62795 188412 2 58 398 Mississippi St 3 4 1 1     1 Width 3ft   6014026.1658 2105339.44297 37.761649798808996 -122.394598331744 (37.761649798809, -122.394598331744)
54760 188413 2 58 398 Mississippi St 4 4 1 1     1 Width 3ft   6014027.478680001 2105319.8341099997 37.7615960301482 -122.394592417822 (37.7615960301482, -122.394592417822)
167143 188401 2 58 909 Minnesota St 1 1 1 1     1 Width 5ft   6015267.441000001 2104396.98208 37.7591309344718 -122.39023938074101 (37.7591309344718, -122.390239380741)
47522 188400 2 58 1045 Tennessee St 1 1 1 1     1 Width 4ft   6015554.8451 2104260.21833 37.7587713477501 -122.389235841663 (37.7587713477501, -122.389235841663)
109961 22155 5 58 1570X FAIRFAX AVE 7 1 1 1     1 3X3   6015579.0 2098247.0 37.74226164995721 -122.388732527256 (37.7422616499572, -122.388732527256)
174132 188415 2 58 2 Jennings St 2 4 1 1     1 Width 3ft   6019090.329030001 2097590.47628 37.7406529492792 -122.37654576818998 (37.7406529492792, -122.37654576819)
Powered by Datasette · Query took 2.716ms · Data source: data.sfgov.org