sf-trees

Data source: data.sfgov.org

Custom SQL query returning 18 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
576 240412 3 45 3420 Market St 1 4 1 2   04/19/1996 12:00:00 AM 7 Width 3ft   6000095.059769999 2103920.2632400002 37.7569687331323 -122.442678332141 (37.7569687331323, -122.442678332141)
31386 214044 2 45 119 Staples Ave 1 1 1 1     7 Width 2ft   5999274.87025 2093768.2240099998 37.729046879900295 -122.444785134325 (37.7290468799003, -122.444785134325)
35367 197333 2 45 1501 25th St 22 2 1 1     7     6014202.148440001 2101967.42619 37.7524007500093 -122.39375364352301 (37.7524007500093, -122.393753643523)
35987 51788 1 45 339 Bridgeview Dr 1 1 1 1   07/01/2009 12:00:00 AM 7 3x3 Permit Number 52292 6012718.572319999 2094804.9461700001 37.7326515416146 -122.39838161323 (37.7326515416146, -122.39838161323)
43641 179373 2 45 670 Brunswick St 17 10 1 1     7     5998557.70629 2086647.36142 37.709453678716706 -122.446752254708 (37.7094536787167, -122.446752254708)
46883 214041 2 45 431 Staples Ave 1 1 1 1     7 Width 3ft   5997281.4748599995 2093791.4004 37.7289965565343 -122.451678093372 (37.7289965565343, -122.451678093372)
50125 35432 1 45 1506 25th St 1 1 1 1 1 03/16/1998 12:00:00 AM 7   Permit Number 38878 6014141.4984800005 2102013.02263 37.7525225775725 -122.39396657421499 (37.7525225775725, -122.393966574215)
68004 240379 2 45 87 14th St 3 1 1 1     7 Width 3ft   6008087.13667 2107952.681 37.7684931737476 -122.41532408966002 (37.7684931737476, -122.41532408966)
73689 87871 1 45 2335 Francisco St 1 1 1 1   06/13/2008 12:00:00 AM 7 3x3 Permit Number 50842 6000134.07181 2119870.32478 37.8007657456038 -122.44368923307199 (37.8007657456038, -122.443689233072)
74383 240409 2 45 1 Arbor St 1 1 1 1     7 Width 2ft   6002196.797259999 2096967.0919299999 37.7379965524899 -122.434912495609 (37.7379965524899, -122.434912495609)
74893 73753 2 45 2019 Balboa St 1 1 1 1 1 02/17/1996 12:00:00 AM 7     5989295.11737 2111227.81825 37.7764117112404 -122.480563089536 (37.7764117112404, -122.480563089536)
137888 214039 2 45 57 Nordhoff St 1 9 1 1     7 Width 2ft   6000414.26094 2095519.5651200002 37.7339206127394 -122.440971772322 (37.7339206127394, -122.440971772322)
147458 48456 1 45 520 06th St 4 1 1 1   08/05/2002 12:00:00 AM 7   Permit Number 45824 6011955.4839699995 2110455.52014 37.7755820536976 -122.402119714552 (37.7755820536976, -122.402119714552)
159694 39695 1 45 1583 Shafter Ave 1 1 1 1 1 01/05/1999 12:00:00 AM 7   Permit Number 41080 6014997.8516 2094075.2851 37.730774746396 -122.390450554434 (37.730774746396, -122.390450554434)
166990 136321 2 45 150 Francisco St 13 7 1 1     7     6010437.78302 2121369.6786 37.8054648831642 -122.408139740375 (37.8054648831642, -122.408139740375)
169354 117837 3 45 660x 39th Ave 2 11 1 2     7 Width 6ft   5983820.01458 2111273.2343900003 37.776216692790705 -122.49950607144899 (37.7762166927907, -122.499506071449)
177864 214036 2 45 262 Ralston St 1 4 1 1     7 Width 3ft   5992219.26388 2089623.39625 37.7172610279406 -122.46887519663 (37.7172610279406, -122.46887519663)
185623 78275 2 45 65 Pomona St 1 1 1 1 1 07/15/2000 12:00:00 AM 7     6014137.61661 2094337.2388799998 37.7314462603177 -122.39344287108901 (37.7314462603177, -122.393442871089)
Powered by Datasette · Query took 9.213ms · Data source: data.sfgov.org