sf-trees

Data source: data.sfgov.org

Custom SQL query returning 66 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
656 23200 3 103 520X Van Ness Ave 2 11 1 2     30 9   6006725.22564 2112390.29825 37.7806011691535 -122.420349841196 (37.7806011691535, -122.420349841196)
1070 19942 3 103 100 STAIRWAY38 11 1 1 2     18 10ST            
3884 20320 3 103 101X Sunset Blvd 9 1 1 2     42 60            
6027 20016 3 103 100 STAIRWAY48 0 1 1 2     18 10ST            
6772 20314 3 103 101X Sunset Blvd 3 1 1 2     42 60            
7805 19939 3 103 100 STAIRWAY38 8 1 1 2     18 10ST            
7960 23202 3 103 520X Van Ness Ave 4 11 1 2     24 9   6006708.88776 2112470.99571 37.7808218241176 -122.420412091366 (37.7808218241176, -122.420412091366)
8002 19938 3 103 100 STAIRWAY38 7 1 1 2     18 10ST            
8496 20017 3 103 100 STAIRWAY48 1 1 1 2     18 10ST            
8841 23183 3 103 520X Van Ness Ave 3 11 1 2   06/09/2005 12:00:00 AM 6 3X3   6006719.9876 2112427.32903 37.780702551515496 -122.42037059124901 (37.7807025515155, -122.420370591249)
9734 173682 3 103 450x Raymond Ave 1 1 1 4 2     3x3   6008515.0 2088365.0 37.71473375007071 -122.41245939537501 (37.7147337500707, -122.412459395375)
9739 173683 3 103 450x Raymond Ave 2 1 1 4 2     3x3   6008515.0 2088365.0 37.71473375007071 -122.41245939537501 (37.7147337500707, -122.412459395375)
10119 173856 3 103 118 Saint Mary's Ave 2 9 1 2       Width 3ft   6003956.18287 2095944.61673 37.735288805319904 -122.42875656067 (37.7352888053199, -122.42875656067)
12003 20316 3 103 101X Sunset Blvd 5 1 1 2     42 60            
12342 24268 3 103 350X Winding Way 6 11 1 2     12 8   6001111.916180001 2086587.12369 37.7094338594537 -122.437920185566 (37.7094338594537, -122.437920185566)
12367 24267 3 103 350X Winding Way 5 11 1 2     12 8   6001124.44895 2086586.86413 37.7094338594468 -122.43787685174401 (37.7094338594468, -122.437876851744)
14348 19941 3 103 100 STAIRWAY38 10 1 1 2     18 10ST            
14547 19940 3 103 100 STAIRWAY38 9 1 1 2     18 10ST            
16276 20315 3 103 101X Sunset Blvd 4 1 1 2     42 60            
17047 20318 3 103 101X Sunset Blvd 7 1 1 2     36 60            
17109 20319 3 103 101X Sunset Blvd 8 1 1 2     36 60            
18271 28138 3 103 418 Eugenia Ave 2 1 1 2     90 4X5   6006975.957669999 2097881.62293 37.7407778444163 -122.41845336792801 (37.7407778444163, -122.418453367928)
19068 26911 3 103 10 Caine Ave 7 11 1 2     18 10   5997609.86555 2089654.4499099997 37.7176562610968 -122.450244747607 (37.7176562610968, -122.450244747607)
19139 29600 3 103 900X Junipero Serra Blvd 9 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991176.92289 2091079.14193 37.7211978713578 -122.472584119478 (37.7211978713578, -122.472584119478)
28512 176338 3 103 100x Mansell St 6 11 1 2     5 Width 0ft   6011479.2515 2090641.1055 37.721149380822 -122.402373605767 (37.721149380822, -122.402373605767)
38393 176339 3 103 100x Mansell St 7 11 1 2     26 Width 0ft   6011461.59774 2090655.36204 37.7211875408569 -122.402435631998 (37.7211875408569, -122.402435631998)
43329 111546 3 103 900x BOSWORTH ST 24 7 1 2     15     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
44177 113502 3 103 200x MANSELL ST 8 11 1 2     30 3x3   6011136.0 2090597.0 37.7210091086741 -122.403557031831 (37.7210091086741, -122.403557031831)
44888 176341 3 103 500x Mansell St 17 11 1 2     11 Width 0ft   6010266.44711 2090286.24099 37.7201072185592 -122.406540946309 (37.7201072185592, -122.406540946309)
47690 176337 3 103 100x Mansell St 5 11 1 2     59 Width 0ft   6011478.9031 2090656.6645400003 37.72119208331829 -122.40237590353901 (37.7211920833183, -122.402375903539)
55507 191724 3 103 950x Kansas St 5 3 1 2     43     6011608.5229400005 2103823.60133 37.7573529289142 -122.402853412073 (37.7573529289142, -122.402853412073)
71413 113506 3 103 200x Mansell St 12 11 1 2     39 3x3   6011135.08211 2090555.5358799999 37.7208952054249 -122.40355728893199 (37.7208952054249, -122.403557288932)
79476 116530 3 103 745X SANCHEZ ST 7 3 1 2     45     6003713.0 2103768.0 37.7567562336472 -122.430155272915 (37.7567562336472, -122.430155272915)
85741 114041 3 103 95 LINARES AVE 2 7 1 2       3x3   5994258.0 2102054.0 37.751509977458795 -122.462729551044 (37.7515099774588, -122.462729551044)
87799 13410 3 103 364 Marietta Dr 3 11 1 2     12 5   5999660.108164 2097381.7238333 37.738990678772396 -122.443712833155 (37.7389906787724, -122.443712833155)
88008 111551 3 103 900x BOSWORTH ST 29 7 1 2     27     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
90640 114042 3 103 95 LINARES AVE 3 7 1 2       3x3   5994258.0 2102054.0 37.751509977458795 -122.462729551044 (37.7515099774588, -122.462729551044)
92343 113367 3 103 6X Christopher Dr 1 7 1 2     25     5996701.11551 2103988.82524 37.7569629284433 -122.454420756361 (37.7569629284433, -122.454420756361)
92885 111536 3 103 900x BOSWORTH ST 14 7 1 2     24     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
99315 3751 3 103 990 Carolina St 1 11 1 2     42 18   6012435.5557064 2103342.2152382 37.756077292734105 -122.399959384248 (37.7560772927341, -122.399959384248)
100681 111529 3 103 900x BOSWORTH ST 7 7 1 2     24     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
101800 114043 3 103 95 LINARES AVE 4 7 1 2       3x3   5994258.0 2102054.0 37.751509977458795 -122.462729551044 (37.7515099774588, -122.462729551044)
102861 112189 3 103 301x CORBETT AVE 1 9 1 2     12 3x3   5999677.0 2105220.0 37.760513648972996 -122.444217531177 (37.760513648973, -122.444217531177)
102874 111513 3 103 800x BOSWORTH ST 8 7 1 2     16     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
102986 112188 3 103 301x CORBETT AVE 2 9 1 2     45 3x3   5999677.0 2105220.0 37.760513648972996 -122.444217531177 (37.760513648973, -122.444217531177)
106180 106794 3 103 199X ARLINGTON ST 51 11 1 2     18     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
109383 106792 3 103 199X ARLINGTON ST 1 11 1 2     15     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
111260 111511 3 103 800x BOSWORTH ST 6 7 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
112606 105901 3 103 11X ELLIOT ST 2 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
113760 106810 3 103 3500X MISSION ST 10 11 1 2     11     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716)
117576 111525 3 103 900x BOSWORTH ST 3 7 1 2     26     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
120548 111538 3 103 900x BOSWORTH ST 16 7 1 2     28     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
122561 105900 3 103 11X ELLIOT ST 1 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
123394 114040 3 103 95 LINARES AVE 1 7 1 2     40 3x3   5994258.0 2102054.0 37.751509977458795 -122.462729551044 (37.7515099774588, -122.462729551044)
127427 106795 3 103 199X ARLINGTON ST 55 11 1 2     12     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
138343 105902 3 103 11X ELLIOT ST 3 14 1 2     40     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
139032 30154 3 103 410X Mansell St 23 11 1 2     24 M   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
141204 111548 3 103 900x BOSWORTH ST 26 7 1 2     40     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
144679 106811 3 103 3500X MISSION ST 17 11 1 2     20     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716)
149487 208977 3 103 300x Marietta Dr 45 11 1 2     27 Width 5ft   5999505.82373 2097502.74743 37.7393141797969 -122.44425497048401 (37.7393141797969, -122.444254970484)
153783 191723 3 103 900x Carolina St 30 3 1 2     50     6012476.48508 2103328.88343 37.7560429683291 -122.39981689974701 (37.7560429683291, -122.399816899747)
165255 224249 3 103 500x 27th St 14 11 1 2     48 Width 4ft   6002852.0087 2100065.56768 37.7465414276517 -122.432868400457 (37.7465414276517, -122.432868400457)
168122 169607 3 103 118 Saint Mary's Ave 1 9 1 2     0 Width 3ft   6003956.18287 2095944.61673 37.735288805319904 -122.42875656067 (37.7352888053199, -122.42875656067)
173688 191721 3 103 1150x Tennessee St 7 3 1 2     50     6015559.12531 2103608.85918 37.75698309171089 -122.389175557402 (37.7569830917109, -122.389175557402)
178271 176340 3 103 200x Mansell St 15 11 1 2     8 Width 0ft   6011135.84107 2090535.2556900003 37.720839562571996 -122.403553239308 (37.720839562572, -122.403553239308)
180599 191725 3 103 950x Kansas St 6 3 1 2     46     6011608.2265 2103816.01851 37.75733209161471 -122.40285390399201 (37.7573320916147, -122.402853903992)
Powered by Datasette · Query took 31.807ms · Data source: data.sfgov.org