sf-trees

Data source: data.sfgov.org

Custom SQL query returning 16 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
30147 227061 2 199 800 Alvarado St 2 1 1 1     2 Width 3ft   6001153.3216699995 2102624.46205 37.75347104667021 -122.438925612327 (37.7534710466702, -122.438925612327)
30485 227075 2 199 1720 Sanchez St 1 1 1 1     2 Width 3ft   6003949.62803 2098226.14791 37.741552998869295 -122.42894183272301 (37.7415529988693, -122.428941832723)
45749 227069 2 199 880 Church St 4 1 1 1     2 Width 3ft   6004326.63425 2103721.26686 37.7566626515725 -122.42802976997 (37.7566626515725, -122.42802976997)
65370 227064 2 199 4441 19th St 1 1 1 1     2 Width 3ft   6001211.68109 2104631.03803 37.7589839384659 -122.438867577298 (37.7589839384659, -122.438867577298)
66352 176873 2 199 34 Kelloch Ave 1 1 1 1     2 Width 3ft   6008389.4363 2086207.95793 37.7088039104301 -122.412740993025 (37.7088039104301, -122.412740993025)
68137 139627 2 199 1911 EDDY ST 1 1 1 1     2 Width 0ft   6001197.3517 2112443.2085 37.7804333986461 -122.439477144015 (37.7804333986461, -122.439477144015)
70508 191215 2 199 695 Wisconsin St 1 9 1 1     2 Width 6ft   6012749.19171 2104260.69013 37.758616704812496 -122.398939180317 (37.7586167048125, -122.398939180317)
134020 176869 2 199 466 Paris St 2 1 1 1     2 Width 1ft   6001971.78547 2090916.90643 37.7213713443005 -122.435257834404 (37.7213713443005, -122.435257834404)
147129 42951 1 199 454 Utah St 1 1 1 1 1 07/05/2000 12:00:00 AM 2   Permit Number 42844 6010612.89233 2106188.0109099997 37.7637894226584 -122.406463315032 (37.7637894226584, -122.406463315032)
148590 227067 2 199 880 Church St 2 1 1 1     2 Width 3ft   6004324.426109999 2103760.8259900003 37.75677114668179 -122.428040225476 (37.7567711466818, -122.428040225476)
149825 227070 2 199 3600 21st St 1 1 1 1     2 Width 3ft   6004299.63219 2103676.28895 37.75653762513971 -122.428119947672 (37.7565376251397, -122.428119947672)
151843 97782 1 199 1616 20th St 1 1 1 1   04/02/2010 12:00:00 AM 2 3x3 Permit Number 56445 6013154.51165 2104761.54844 37.760014529165296 -122.39757251837099 (37.7600145291653, -122.397572518371)
153420 129363 2 199 2936 Scott St 1 1 1 1     2 Width 2ft   6001041.88573 2118458.1197099998 37.7969399387778 -122.44044648643299 (37.7969399387778, -122.440446486433)
156198 186879 2 199 2700 Sunset Blvd 28 9 1 1     2 Width 0ft   5985177.7993 2096457.4623 37.7356162487584 -122.49371718453101 (37.7356162487584, -122.493717184531)
158758 227066 2 199 880 Church St 1 1 1 1     2 Width 3ft   6004322.18511 2103780.44049 37.7568248766824 -122.42804937340401 (37.7568248766824, -122.428049373404)
177767 227068 2 199 880 Church St 3 1 1 1     2 Width 3ft   6004327.06054 2103741.95573 37.7567194824462 -122.428029769971 (37.7567194824462, -122.428029769971)
Powered by Datasette · Query took 1.858ms · Data source: data.sfgov.org