sf-trees

Data source: data.sfgov.org

Custom SQL query returning 72 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)
19054 94934 6 311 2451X Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
50102 94943 6 417 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
76012 97025 7 88 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
78805 97021 7 180 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
81078 94935 6 469 2451X Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
81165 97014 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
81341 97022 7 195 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
81359 112751 2 43 135X TRENTON ST 5 1 1 20 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
82893 97042 7 322 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
84182 104279 6 17 150X Middle Point Rd 1 7 1 20   09/17/2013 12:00:00 AM     Permit Number 770341 6018215.0 2095138.0 37.733870695497295 -122.37940203679399 (37.7338706954973, -122.379402036794)
85013 97015 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
86272 104288 6 17 137X Middle Point Rd 1 7 1 20   09/17/2013 12:00:00 AM     Permit Number 770341 6018215.0 2095138.0 37.733870695497295 -122.37940203679399 (37.7338706954973, -122.379402036794)
86815 112748 2 21 135X TRENTON ST 2 1 1 20 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
87276 112509 2 11 699x WILLOW ST 1 1 1 20 4     2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
87538 97027 7 1 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
88058 94937 6 498 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
88802 97029 7 232 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
90248 97040 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
90953 104290 6 17 11X Hare St 1 7 1 20   09/17/2013 12:00:00 AM     Permit Number 770341 6018215.0 2095138.0 37.733870695497295 -122.37940203679399 (37.7338706954973, -122.379402036794)
92954 97034 7 54 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
94845 97016 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
94993 112510 2 11 699x WILLOW ST 2 1 1 20 4     2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
96189 94940 6 112 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
99914 97028 7 112 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
101441 112750 2 43 135X TRENTON ST 4 1 1 20 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
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)
104476 97043 7 322 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
104783 96999 7 20 195A Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
107391 104289 6 17 10X Hare St 1 7 1 20   09/17/2013 12:00:00 AM     Permit Number 770341 6018215.0 2095138.0 37.733870695497295 -122.37940203679399 (37.7338706954973, -122.379402036794)
107550 97032 7 477 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
108419 104281 6 17 150X Middle Point Rd 3 7 1 20   09/17/2013 12:00:00 AM     Permit Number 770341 6018215.0 2095138.0 37.733870695497295 -122.37940203679399 (37.7338706954973, -122.379402036794)
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)
111442 104286 6 17 200X West Point Rd 1 7 1 20   09/17/2013 12:00:00 AM     Permit Number 770341 6018215.0 2095138.0 37.733870695497295 -122.37940203679399 (37.7338706954973, -122.379402036794)
111560 94941 6 112 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
111884 94939 6 112 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
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)
112975 94938 6 498 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
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)
118120 114914 2 40 200x MIDDLE POINT RD 1 1 1 20 3     3x3   6017974.0 2095171.0 37.7339480130439 -122.380237547959 (37.7339480130439, -122.380237547959)
119692 104284 6 17 45X Middle Point Rd 1 7 1 20   09/17/2013 12:00:00 AM     Permit Number 770341 6018215.0 2095138.0 37.733870695497295 -122.37940203679399 (37.7338706954973, -122.379402036794)
120473 112511 2 11 699x WILLOW ST 3 1 1 20 4 08/08/2015 03:37:00 PM 3 2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
120602 115341 2 9 1514 SUNNYDALE AVE 2 9 1 20 3     3x3   6006572.0 2087815.0 37.7131143345755 -122.41913622882099 (37.7131143345755, -122.419136228821)
125137 104285 6 17 71X Middle Point Rd 1 7 1 20   09/17/2013 12:00:00 AM     Permit Number 770341 6018215.0 2095138.0 37.733870695497295 -122.37940203679399 (37.7338706954973, -122.379402036794)
125485 97041 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
125835 97004 7 20 195A Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
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)
127056 104283 6 17 150X Middle Point Rd 5 7 1 20   09/17/2013 12:00:00 AM     Permit Number 770341 6018215.0 2095138.0 37.733870695497295 -122.37940203679399 (37.7338706954973, -122.379402036794)
127473 97045 7 207 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
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)
128784 97039 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
129300 104280 6 17 150X Middle Point Rd 2 7 1 20   09/17/2013 12:00:00 AM     Permit Number 770341 6018215.0 2095138.0 37.733870695497295 -122.37940203679399 (37.7338706954973, -122.379402036794)
138572 112749 2 21 135X TRENTON ST 3 1 1 20 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
139320 94936 6 498 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
140389 97037 7 477 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
140586 97044 7 322 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
140629 97038 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
140648 104282 6 17 150X Middle Point Rd 4 7 1 20   09/17/2013 12:00:00 AM     Permit Number 770341 6018215.0 2095138.0 37.733870695497295 -122.37940203679399 (37.7338706954973, -122.379402036794)
141507 104287 6 17 119X Middle Point Rd 1 7 1 20   09/17/2013 12:00:00 AM     Permit Number 770341 6018215.0 2095138.0 37.733870695497295 -122.37940203679399 (37.7338706954973, -122.379402036794)
141804 96996 6 235 2451X Griffith St   5 1 20 1         6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
142369 97035 7 309 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
143629 96998 6 84 2451X Griffith St   5 1 20 1         6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
144144 94944 6 540 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
144482 98742 2 51 1150 Scott St 6 1 1 20 2 03/21/2012 12:00:00 AM 3 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
144883 94942 6 417 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
145213 97026 7 208 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
145522 97036 7 477 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
145720 98741 2 51 1150 Scott St 5 1 1 20 2 03/21/2012 12:00:00 AM 3 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
181574 102134 1 37 400 Beale St 3 1 1 20 3 11/24/2015 12:00:00 AM 1 3x3 Permit Number 769373 6015285.47231 2114577.79035 37.787086180420296 -122.390888542866 (37.7870861804203, -122.390888542866)
Powered by Datasette · Query took 2.415ms · Data source: data.sfgov.org