sf-trees

Data source: data.sfgov.org

Custom SQL query returning 18 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
73004 190635 2 14 1 01st St 28 23 1 1     9     6014407.37845 2105898.42582 37.7632058300952 -122.393318979581 (37.7632058300952, -122.393318979581)
139126 199549 2 224 1 01st St 5 23 1 1     9     6014392.26095 2105920.87265 37.7632666242892 -122.39337283731399 (37.7632666242892, -122.393372837314)
153276 199557 2 224 1 01st St 18 23 1 1     9     6014448.03527 2105905.59327 37.7632277690557 -122.393178861636 (37.7632277690557, -122.393178861636)
171136 199548 2 224 1 01st St 4 23 1 1     9     6014382.11605 2105919.95745 37.7632635477036 -122.39340786139499 (37.7632635477036, -122.393407861395)
134718 196565 2 362 1 24th St 22 23 1 1     9     6017179.65065 2102592.91539 37.7542832244069 -122.38350039013599 (37.7542832244069, -122.383500390136)
137284 189677 2 32 1 24th St 14 23 1 1     9     6017255.58244 2102660.6719 37.754473466102795 -122.38324251223801 (37.7544734661028, -122.383242512238)
150675 190752 2 348 1 24th St 5 23 1 1     9     6017117.58441 2102700.05767 37.7545739842169 -122.383722492107 (37.7545739842169, -122.383722492107)
163742 189680 2 32 1 24th St 21 23 1 1     9     6017213.38014 2102597.10976 37.754296605427704 -122.38338403586701 (37.7542966054277, -122.383384035867)
60000 192362 2 10 1 25th St 20 23 1 1     9     6014965.98324 2102248.74822 37.7532156176115 -122.391131817592 (37.7532156176115, -122.391131817592)
74692 196073 2 16 1 25th St 5 23 1 1     9     6014983.580569999 2102134.9117099997 37.752904023218605 -122.391063005979 (37.7529040232186, -122.391063005979)
150778 188007 2 12 1310 Indiana St 2 23 1 1     9     6015000.133780001 2102555.57956 37.7540600063901 -122.391035161147 (37.7540600063901, -122.391035161147)
37555 237003 2 16 199 Franconia St 14 23 1 1     9 Width 3ft   6010106.165469999 2099668.32603 37.7458594609566 -122.40775619120001 (37.7458594609566, -122.4077561912)
152462 233605 2 41 199 Franconia St 12 23 1 1     9 Width 3ft   6010122.88511 2099649.32748 37.745808231063705 -122.407697037414 (37.7458082310637, -122.407697037414)
154821 237005 2 16 199 Franconia St 16 23 1 1     9 Width 3ft   6010090.49979 2099699.0653 37.7459429872721 -122.40781252834101 (37.7459429872721, -122.407812528341)
156957 233233 2 41 199 Franconia St 6 23 1 1     9 Width 3ft   6010125.251569999 2099665.5030400003 37.745852778088 -122.407689994823 (37.745852778088, -122.407689994823)
152563 234500 2 302 4090 20th St 8 23 1 1     9 Width 3ft   6003098.9698 2104154.51537 37.757782715804204 -122.43230641682699 (37.7577827158042, -122.432306416827)
172054 222663 2 270 4090 20th St 2 23 1 1     9 Width 3ft   6003162.223809999 2104187.96649 37.7578781509761 -122.43209004713002 (37.7578781509761, -122.43209004713)
179643 222664 2 270 4090 20th St 3 23 1 1     9 Width 3ft   6003149.42788 2104190.19818 37.7578835531891 -122.432134460156 (37.7578835531891, -122.432134460156)
Powered by Datasette · Query took 3.087ms · Data source: data.sfgov.org