sf-trees

Data source: data.sfgov.org

Custom SQL query returning 12 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
42028 188510 2 42 101 Pennsylvania Ave 25 7 1 1     2     6014318.1653 2106535.6894400003 37.76495065967789 -122.39367214607401 (37.7649506596779, -122.393672146074)
49864 203621 2 42 21 Juanita Way 1 1 1 1     2 Width 2ft   5997303.382119999 2099336.74248 37.7442239835511 -122.452002277389 (37.7442239835511, -122.452002277389)
50887 43172 1 42 370 Madison St 1 1 1 1 1 07/11/2000 12:00:00 AM 2   Permit Number 42981 6005806.0739 2092004.6857099999 37.7245751476096 -122.42208098844101 (37.7245751476096, -122.422080988441)
52495 220079 2 42 4021 20th St 2 1 1 1     2 Width 3ft   6003566.56829 2104171.42308 37.7578556427516 -122.43069047448799 (37.7578556427516, -122.430690474488)
55738 188509 2 42 101 Pennsylvania Ave 12 7 1 1     2     6014325.646980001 2106424.64729 37.7646461780098 -122.393638496141 (37.7646461780098, -122.393638496141)
59298 203625 2 42 15 Teresita Blvd 4 1 1 1     2 Width 3ft   5997311.4729 2099621.76413 37.7450070466421 -122.45199486067499 (37.7450070466421, -122.451994860675)
93809 203623 2 42 15 Teresita Blvd 2 1 1 1     2 Width 3ft   5997330.81089 2099592.0734900003 37.744926631064 -122.45192585212 (37.744926631064, -122.45192585212)
136911 220680 2 42 54 Fair Oaks St 1 1 1 1     2 Width 3ft   6005359.13512 2103393.3623900004 37.7558206631137 -122.424435681558 (37.7558206631137, -122.424435681558)
152179 220084 2 42 3580 21st St 1 1 1 1     2 Width 3ft   6004538.52309 2103691.84305 37.7565938462521 -122.427294885373 (37.7565938462521, -122.427294885373)
167841 43170 1 42 364 Madison St 1 1 1 1 1 07/11/2000 12:00:00 AM 2   Permit Number 42979 6005800.19112 2092023.1560099998 37.724625531232796 -122.42210263603701 (37.7246255312328, -122.422102636037)
177773 188511 2 42 101 Pennsylvania Ave 33 7 1 1     2     6014272.76615 2106665.73514 37.7653052137955 -122.393838275126 (37.7653052137955, -122.393838275126)
183611 220078 2 42 4021 20th St 1 1 1 1     2 Width 3ft   6003547.22001 2104169.9563599997 37.7578505193113 -122.430757284236 (37.7578505193113, -122.430757284236)
Powered by Datasette · Query took 8.329ms · Data source: data.sfgov.org