sf-trees

Data source: data.sfgov.org

Custom SQL query returning 23 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
6018 19926 3 190 100 STAIRWAY37 6 1 1 2     3 20ST            
11287 20003 3 190 100 STAIRWAY46 23 1 1 2     3 2            
16066 22498 1 190 6404 03rd St 1 1 1 1   02/20/2003 12:00:00 AM 3 3X3   6013069.4059 2090221.21293 37.720085079934705 -122.39684744087799 (37.7200850799347, -122.396847440878)
24799 120350 2 190 2122 Lake St 4 2 1 1     3 Width 6ft   5988813.63616 2114710.28976 37.7859456052821 -122.482483881641 (37.7859456052821, -122.482483881641)
26210 118831 2 190 662 46th Ave 1 2 1 1     3 Width 3ft   5981671.941000001 2111218.67307 37.775940615740105 -122.50693266579799 (37.7759406157401, -122.506932665798)
29285 207725 2 190 380 Ralston St 2 9 1 1     3 Width 6ft   5992234.508719999 2090438.5826599998 37.7195002121526 -122.468881791362 (37.7195002121526, -122.468881791362)
38723 191689 2 190 1 01st St 27 23 1 1     3     6014402.09171 2105890.67407 37.7631842517621 -122.393336722306 (37.7631842517621, -122.393336722306)
50134 191700 3 190 1700x Quesada Ave 39 3 1 2     3     6014384.30677 2095263.8272900002 37.7340041867507 -122.39265480417801 (37.7340041867507, -122.392654804178)
55093 202013 2 190 7 Wheat St 2 4 1 1     3 Width 3ft   6012149.42791 2091374.5561400002 37.723200675946394 -122.40010846893601 (37.7232006759464, -122.400108468936)
55948 207724 2 190 132 Ralston St 1 4 1 1     3 Width 3ft   5992208.616230001 2088772.7459099998 37.71492473315389 -122.46885013341999 (37.7149247331539, -122.46885013342)
59361 176270 2 190 195 Rome St 1 7 1 1     3 Width 0ft   5998756.35201 2088943.21744 37.7157689240671 -122.44623074418001 (37.7157689240671, -122.44623074418)
65580 191710 3 190 1427x Innes Ave 28 3 1 2     3     6016141.2133599995 2096757.17707 37.7382020430791 -122.386684681762 (37.7382020430791, -122.386684681762)
70263 48553 1 190 378 18th Ave 1 1 1 1   08/22/2002 12:00:00 AM 3   Permit Number 45869 5990302.44703 2112853.20794 37.780933073312504 -122.477197298017 (37.7809330733125, -122.477197298017)
79512 804 3 190 680X 39th Ave 2 11 1 2     3 6-HOA   5983823.94935 2111143.69789 37.7758612538886 -122.499482885033 (37.7758612538886, -122.499482885033)
115840 176282 2 190 35 Tomaso Ct 8 17 1 1     3 Width 3ft   6009202.48899 2086331.0577900002 37.709187518951296 -122.40993964441401 (37.7091875189513, -122.409939644414)
154658 207718 2 190 315 Faxon Ave 1 1 1 1     3 Width 3ft   5994723.84306 2090686.3460799998 37.7203240181088 -122.46029507616998 (37.7203240181088, -122.46029507617)
158994 207710 2 190 641 Moraga St 1 1 1 1     3 Width 3ft   5992286.81518 2103851.81856 37.7563325940936 -122.46967695664 (37.7563325940936, -122.46967695664)
165907 126567 2 190 2843 Larkin St 4 9 1 1     3 Width 5ft   6006455.5801099995 2121070.56705 37.8044198232789 -122.42189945398998 (37.8044198232789, -122.42189945399)
177760 184363 2 190 2251 47th Ave 1 2 1 1     3 Width 0ft   5981706.71 2099767.9271 37.7445021893581 -122.50596322728998 (37.7445021893581, -122.50596322729)
177778 176281 2 190 600 Blanken Ave 3 9 1 1     3 Width 5ft   6013188.37125 2086854.32403 37.710846891333105 -122.39620037057101 (37.7108468913331, -122.396200370571)
179929 207728 2 190 3802 19th Ave 1 9 1 1     3 Width 4ft   5990564.76109 2090542.95021 37.7196901687566 -122.47466105158199 (37.7196901687566, -122.474661051582)
180486 176271 2 190 195 Rome St 2 7 1 1     3 Width 0ft   5998766.3474 2088951.7637599998 37.715792961145205 -122.446196810045 (37.7157929611452, -122.446196810045)
182532 247879 2 190 388 Mayflower St 8 17 1 1     3     6009924.148030001 2098382.32436 37.7423181897436 -122.408294896795 (37.7423181897436, -122.408294896795)
Powered by Datasette · Query took 4.194ms · Data source: data.sfgov.org