sf-trees

Data source: data.sfgov.org

Custom SQL query returning 22 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
174472 36791 1 31 1350 Donner Ave 4 1 1 1   05/26/1998 12:00:00 AM 9 3x3 Permit Number 39527 6015186.7443 2090870.701 37.7219860731406 -122.389573793771 (37.7219860731406, -122.389573793771)
179138 36792 1 31 1350 Donner Ave 5 1 1 1 1 05/26/1998 12:00:00 AM 9 3x3 Permit Number 39527 6015166.6448 2090882.8824 37.7220184063671 -122.38964412365499 (37.7220184063671, -122.389644123655)
62417 52600 1 31 1360WASHINGTON Jones St 2 1 1 1   02/03/2006 12:00:00 AM 9   Permit Number 48694 6008503.01401 2117214.59757 37.793947543601 -122.41454108323 (37.793947543601, -122.41454108323)
32139 215423 2 31 15 Fairfield Way 5 1 1 1     9 Width 3ft   5993769.4086 2092813.96021 37.72611098282629 -122.46374856183998 (37.7261109828263, -122.46374856184)
178204 197987 2 31 2 Bridgeview Dr 4 7 1 1     9     6014076.35565 2095353.09382 37.734232186468894 -122.39372574026501 (37.7342321864689, -122.393725740265)
128240 215433 2 31 20 Lakewood Ave 2 1 1 1     9 Width 3ft   5993594.89235 2092910.6701200001 37.726366466724 -122.464358867875 (37.726366466724, -122.464358867875)
188005 215430 2 31 20 Lakewood Ave 5 1 1 1     9 Width 3ft   5993628.724219999 2092981.5344200002 37.72656299287289 -122.464247056069 (37.7265629928729, -122.464247056069)
175277 241199 2 31 24 Carl St 1 1 1 1     9 Width 4ft   5998508.2304 2107266.01278 37.7660647371231 -122.448407097228 (37.7660647371231, -122.448407097228)
46627 182665 2 31 2618 Ortega St 1 2 1 1     9 Width 0ft   5985884.1902 2102331.3321 37.7517856167847 -122.491707219971 (37.7517856167847, -122.491707219971)
34372 241223 2 31 2800 17th St 7 1 1 1     9 Width 3ft   6009004.56515 2106399.07167 37.7642788409211 -122.41204096432699 (37.7642788409211, -122.412040964327)
60020 241221 2 31 2800 17th St 4 1 1 1     9 Width 3ft   6009078.922 2106403.19833 37.764294343422996 -122.411784075669 (37.764294343423, -122.411784075669)
66969 241217 2 31 4130 Cesar Chavez St 1 9 1 1     9 Width 6ft   6003092.5802 2100398.11558 37.7474681682247 -122.432060274186 (37.7474681682247, -122.432060274186)
164545 82366 6 31 51 Princeton St 3 1 1 1 1 05/28/2005 12:00:00 AM 9     6007564.92616 2093725.05049 37.7293979446509 -122.416122630059 (37.7293979446509, -122.416122630059)
185878 50830 1 31 621 Baker St 1 1 1 1   03/19/2004 12:00:00 AM 9   Permit Number 47349 6000535.8217 2111139.1847 37.7768152106013 -122.441672069607 (37.7768152106013, -122.441672069607)
50744 197985 2 31 669 Mississippi St 2 4 1 1     9 Width 3ft   6014155.897999999 2104063.80675 37.758154390328 -122.394060332116 (37.758154390328, -122.394060332116)
27769 215436 2 31 670 Mangels Ave 1 9 1 1     9 Width 10ft   5996989.65534 2095298.72051 37.7331185802561 -122.452795679095 (37.7331185802561, -122.452795679095)
146364 179967 2 31 716 Peru Ave 8 9 1 1     9 Width 2ft   6005275.29843 2092450.03888 37.7257680389529 -122.423947466603 (37.7257680389529, -122.423947466603)
42264 246217 2 31 725 Buena Vista Ave West 5 1 1 1     9 Width 0ft   5999828.0384 2107849.3991 37.7677419398126 -122.443884078726 (37.7677419398126, -122.443884078726)
135775 179965 2 31 86 Arago St 2 9 1 1     9     5999606.18552 2093002.3803299998 37.726962952855104 -122.443584762453 (37.7269629528551, -122.443584762453)
55655 198001 3 31 860x Jamestown Ave 1 11 1 2     9 Width 5ft   6014795.93259 2089063.22643 37.7170014260431 -122.390798490171 (37.7170014260431, -122.390798490171)
170469 197997 2 31 881 Jamestown Ave 19 9 1 1     9 Width 6ft   6014474.56871 2089262.00767 37.717529404523795 -122.391923191299 (37.7175294045238, -122.391923191299)
178543 197994 2 31 881 Jamestown Ave 14 9 1 1     9 Width 6ft   6014370.9162 2089321.9827 37.717688329142604 -122.392285665748 (37.7176883291426, -122.392285665748)
Powered by Datasette · Query took 4.582ms · Data source: data.sfgov.org