sf-trees

Data source: data.sfgov.org

Custom SQL query returning 19 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1930 252828 6 161 3852 17th St 7 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
9661 114148 6 3 1200X JUNIPERO SERRA BLVD 7 7 1 1     19     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9749 173677 6 258 299x Beale St 7 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
74397 120924 6 143 3995X Alemany Blvd 7 5 1 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
86202 98947 6 340 401 Grove St 7 7 1 1           6005778.2 2111279.0 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313)
91855 122410 6 55 499x Ocean Ave 7 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
92297 121163 6 11 350x Octavia St 7 17 1 1           6005623.0 2110494.0 37.7753322239184 -122.42402807847701 (37.7753322239184, -122.424028078477)
100392 96279 6 12 55@ Alemany Trumbull St 7 13 1 1           6004020.1 2094407.4 37.7310715719205 -122.428426044208 (37.7310715719205, -122.428426044208)
100778 102077 6 511 273 Magellan Ave 7 7 1 1           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194)
112189 114231 6 140 99x FONT BLVD 7 2 1 1     10     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
118020 116097 6 86 300x EXECUTIVE PARK BLVD 7 1 1 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
120796 105087 6 54 344 Fulton St 7 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
122611 112487 6 40 1275 Columbus Ave 7 7 1 1           6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209)
124454 113730 6 26 1580 Valencia St 7 7 1 1           6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
139348 100700 6 85 200X 01st St 7 7 1 1   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954.0 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137)
126769 104685 6 26 33 08th St 7 7 1 1         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615)
92995 105436 6 17 610 PARNASSUS AVE 7 9 1 1   03/05/2014 12:00:00 AM 15   Permit Number 771221 5995151.3 2106193.4 37.762927120328996 -122.459940260935 (37.762927120329, -122.459940260935)
95270 121186 6 1 1000x Duncan St 7 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
142191 114191 6 17 201 Delano Ave 7 13 1 1     20   Permit Number 776814 6000172.52130735 2092388.14283689 37.7253086814057 -122.44158289611 (37.7253086814057, -122.44158289611)
Powered by Datasette · Query took 12.889ms · Data source: data.sfgov.org