sf-trees

Data source: data.sfgov.org

Custom SQL query returning 13 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
8146 35450 1 62 790 Peninsula Ave 9 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
76689 191544 2 62 700 Pennsylvania Ave 9 1 1 1     4 Width 3ft   6014401.68997 2103590.98438 37.756869779843505 -122.39317718618 (37.7568697798435, -122.39317718618)
85965 32663 1 62 750 Brannan St 9 1 1 1 1 10/23/1996 12:00:00 AM     Permit Number 37093 6011928.74882851 2109868.72792778 37.773969364433 -122.402170934506 (37.773969364433, -122.402170934506)
87759 37998 1 62 650 Texas St 9 1 1 1   07/08/1998 12:00:00 AM     Permit Number 40210 6013817.86875392 2104108.88491558 37.758259371972706 -122.395232549515 (37.7582593719727, -122.395232549515)
96700 45695 1 62 399 04th St 9 1 1 1   09/27/2001 12:00:00 AM     Permit Number 44376 6012660.71426976 2112434.35553992 37.7810548194134 -122.39981911790701 (37.7810548194134, -122.399819117907)
146669 101221 1 62 444 De Haro St 9 1 1 1     10 3x3   6012019.899180001 2106139.93997 37.763736042505 -122.401593500559 (37.763736042505, -122.401593500559)
147342 76428 2 62 300 Spear St 9 1 1 1 1 07/18/1998 12:00:00 AM 1     6015359.03097 2115547.59056 37.7897531109548 -122.390701840925 (37.7897531109548, -122.390701840925)
161087 129700 2 62 2970 Washington St 9 1 1 1     7 Width 5ft   6000509.65087 2116188.56402 37.790678015119205 -122.442125143875 (37.7906780151192, -122.442125143875)
163311 191559 2 62 401 Rhode Island St 9 1 1 1     12 Width 5ft   6011776.16151 2106411.778 37.7644688451864 -122.40245563471399 (37.7644688451864, -122.402455634714)
166660 191534 2 62 201 16th St 9 1 1 1     3 Width 5ft   6016265.973669999 2107216.92727 37.7669292347089 -122.386982621765 (37.7669292347089, -122.386982621765)
177856 121713 2 62 880 Pennsylvania Ave 9 1 1 1     3     6014428.12864 2103144.99804 37.755646665865605 -122.39305454654499 (37.7556466658656, -122.393054546545)
178469 129721 2 62 1087 Chestnut St 9 1 1 1     7 Width 4ft   6006892.13335 2120470.8795 37.8027978438157 -122.420346130572 (37.8027978438157, -122.420346130572)
180211 140277 2 62 2064 Hayes St 9 1 1 1     2 Width 0ft   5997990.6776 2109965.9876 37.773448573595296 -122.45039185353599 (37.7734485735953, -122.450391853536)
Powered by Datasette · Query took 7.613ms · Data source: data.sfgov.org