sf-trees

Data source: data.sfgov.org

Custom SQL query returning 34 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
6478 98738 2 5 1150 Scott St 2 1 1 20 2   3 4X4   6001885.6171 2112431.4484 37.780440254610205 -122.43709527307301 (37.7804402546102, -122.437095273073)
77569 98569 3 5 301X Francisco St 7 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
79463 116977 2 5 100x CARGO WAY 117 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
79583 73289 3 5 1600X GREEN ST 6 1 1 4 2 11/20/1999 12:00:00 AM 10 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
80033 96215 3 5 200X Collingwood St 3 1 1 4 2   26 4x4   6002035.7 2104682.0 37.7591707149085 -122.436021383266 (37.7591707149085, -122.436021383266)
81902 96211 3 5 201X Diamond St 3 1 1 4 2   14 4x4   6001762.6 2104666.8 37.759113460692 -122.43696480408701 (37.759113460692, -122.436964804087)
85600 93121 3 5 151X Palm Ave 11 1 1 4 2   9 3x3   5995892.67419 2113127.59534 37.7820092173573 -122.457877934554 (37.7820092173573, -122.457877934554)
86000 102186 2 5 3999X Folsom St 1 1 1 4 2   8 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
90252 96214 3 5 200X Collingwood St 2 1 1 4 2   20 3x3   6002035.7 2104682.0 37.7591707149085 -122.436021383266 (37.7591707149085, -122.436021383266)
96597 42644 3 5 1600X GREEN ST 3 1 1 4 2 06/26/2000 12:00:00 AM 10 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
98830 96212 3 5 201X Diamond St 4 1 1 4 2   14 4x4   6001762.6 2104666.8 37.759113460692 -122.43696480408701 (37.759113460692, -122.436964804087)
99139 74759 3 5 250 Foerster St 13 5 1 4 2 05/15/1999 12:00:00 AM 30 5x7   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
100783 73287 3 5 1600X GREEN ST 8 1 1 4 2 11/20/1999 12:00:00 AM 8 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
102473 95360 3 5 775X Broadway 3 1 1 20 2   12 3x3 Permit Number 778058 6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
105405 98743 2 5 155 Masonic Ave 5 26 1 4 2         5998843.8 2112455.0 37.7803315496091 -122.447619999218 (37.7803315496091, -122.447619999218)
105706 96216 3 5 200X Collingwood St 4 1 1 4 2   6 4x4   6002035.7 2104682.0 37.7591707149085 -122.436021383266 (37.7591707149085, -122.436021383266)
108653 73528 3 5 4235 19th St 7 1 1 4 2 08/05/1995 12:00:00 AM 12 4x4   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342)
111189 98571 3 5 301X Francisco St 9 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
111421 95362 3 5 775X Broadway 2 1 1 20 2     3x3 Permit Number 778058 6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
112944 95359 3 5 775X Broadway 5 1 1 20 2   12 3x3 Permit Number 778058 6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
114297 95361 3 5 775X Broadway 4 1 1 20 2   10 3x3 Permit Number 778058 6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
114699 98740 2 5 1150 Scott St 4 1 1 20 2   20 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
118079 95358 3 5 775X Broadway 1 1 1 20 2   25 3x3 Permit Number 778058 6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
118717 102187 2 5 3999X Folsom St 2 1 1 4 2   8 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
124535 73286 3 5 1600X GREEN ST 9 1 1 4 2 11/20/1999 12:00:00 AM 8 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
126442 95363 3 5 775X Broadway 6 1 1 20 2   20 3x3   6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
126702 98737 2 5 1150 Scott St 1 1 1 20 2   24 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
127279 71177 3 5 4235 19th St 4 1 1 4 2 08/05/1995 12:00:00 AM 12 4x4   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342)
128247 116052 2 5 650x KANSAS ST 8 1 1 4 2     4x4   6011530.0 2105347.0 37.761531458187 -122.403232137637 (37.761531458187, -122.403232137637)
128761 98739 2 5 1150 Scott St 3 1 1 20 2   20 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
129870 116056 2 5 650x Kansas St 12 1 1 4 2   23 4x4   6011515.191980001 2105171.68257 37.7610492486475 -122.40327101944901 (37.7610492486475, -122.403271019449)
139596 73288 3 5 1600X GREEN ST 7 1 1 4 2 11/20/1999 12:00:00 AM 8 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
140357 73285 3 5 1600X GREEN ST 10 1 1 4 2 11/20/1999 12:00:00 AM 13 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
142663 42642 3 5 1600X GREEN ST 1 1 1 4 2 06/26/2000 12:00:00 AM 5 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
Powered by Datasette · Query took 8.155ms · Data source: data.sfgov.org