sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
887 251303 2 103 1 Cashmere St 2 13 1 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
896 251302 2 103 1 Cashmere St 1 13 1 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
966 251417 5 103 418 19th Ave 1 1 1 6       3x3   5990003.0 2112517.0 37.779992561868504 -122.478208632121 (37.7799925618685, -122.478208632121)
2603 253136 2 103 3059 Pine St 1 1 1 1       4x5   5999298.0 2114593.0 37.786227889505604 -122.446202552789 (37.7862278895056, -122.446202552789)
3693 252877 2 103 1400 Baker St 2 7 1 1       3x3   6000422.0 2113928.0 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376)
3843 253568 6 103 301X Sargent St 1 8 1 1       3x3   5993018.0 2089140.0 37.7159798527116 -122.46607925705901 (37.7159798527116, -122.466079257059)
5068 253206 2 103 2253 09th Ave 3 5 1 1       3x3   5993186.0 2100608.0 37.7474778324271 -122.466331547971 (37.7474778324271, -122.466331547971)
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)
22892 251144 6 103 200X Clarendon Ave 1 9 1 1       3x3   5996559.0 2104265.0 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022)
22896 251145 6 103 200X Clarendon Ave 1 9 1 1       3x3   5996559.0 2104265.0 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022)
42995 52091 1 103 300 Dorantes Ave 2 1 1 1   10/24/2005 12:00:00 AM     Permit Number 48287 5993176.51233561 2099718.04340733 37.745033690620396 -122.46629968747601 (37.7450336906204, -122.466299687476)
78601 92035 1 103 10 Elk St 3 1 1 1       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.44267015975201 (37.7402285519688, -122.442670159752)
78981 113860 2 103 456 HILL ST 2 1 1 1       3x3   6003369.0 2103347.0 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346)
85741 114041 3 103 95 LINARES AVE 2 7 1 2       3x3   5994258.0 2102054.0 37.751509977458795 -122.462729551044 (37.7515099774588, -122.462729551044)
89080 106004 2 103 695X CAMPBELL AVE   19 1 3           6009136.9 2088912.4 37.716271678506 -122.41034847162202 (37.716271678506, -122.410348471622)
89710 92040 1 103 10 Elk St 8 1 1 1       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.44267015975201 (37.7402285519688, -122.442670159752)
90489 113805 2 103 990X OSHAUGHNESSY BLVD 2 7 1 3       3x30   6000025.0 2096199.0 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687)
90640 114042 3 103 95 LINARES AVE 3 7 1 2       3x3   5994258.0 2102054.0 37.751509977458795 -122.462729551044 (37.7515099774588, -122.462729551044)
92339 115295 6 103 500X 08TH ST 1 1 1 1       3x3   6010511.0 2109243.0 37.77217202356729 -122.407031076357 (37.7721720235673, -122.407031076357)
92750 113861 2 103 456 HILL ST 3 1 1 1       3x3   6003369.0 2103347.0 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346)
92823 116020 2 103 2023 09TH AVE 2 1 1 1       6x6   5993447.0 2101700.0 37.7504912419676 -122.46550835159401 (37.7504912419676, -122.465508351594)
95756 92036 1 103 10 Elk St 4 1 1 1       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.44267015975201 (37.7402285519688, -122.442670159752)
97315 113859 2 103 456 HILL ST 1 1 1 1       3x3   6003369.0 2103347.0 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346)
97794 92038 1 103 10 Elk St 6 1 1 1       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.44267015975201 (37.7402285519688, -122.442670159752)
100855 114731 7 103 934 BRANNAN ST   13 1 1 9     10x10   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
101800 114043 3 103 95 LINARES AVE 4 7 1 2       3x3   5994258.0 2102054.0 37.751509977458795 -122.462729551044 (37.7515099774588, -122.462729551044)
103018 104402 2 103 301 Joost Ave 1 9 1 1           6000011.7 2094912.1 37.7322297190532 -122.44231994912901 (37.7322297190532, -122.442319949129)
103214 106173 6 103 267 Green St 1 7 1 1         Permit Number 771881 6011670.8 2119368.7 37.8000396459541 -122.403731811098 (37.8000396459541, -122.403731811098)
105251 92899 6 103 208 States St 3 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
105598 106227 7 103 38 Stanford Heights Ave 1 13 1 1           5997884.0 2095808.5 37.7345695210024 -122.44974042873999 (37.7345695210024, -122.44974042874)
106936 105441 5 103 425 WAWONA ST   19 1 1           5991587.6 2097036.5 37.737579050883106 -122.471598439568 (37.7375790508831, -122.471598439568)
108603 114396 1 103 35 HIGUERA AVE 3 1 1 1           5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
109652 113804 2 103 990X OSHAUGHNESSY BLVD 1 7 1 3       3x30   6000025.0 2096199.0 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687)
109893 114409 6 103 500X ARBALLO DR 6 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
111260 111511 3 103 800x BOSWORTH ST 6 7 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
114512 108201 2 103 90 Reuel Ct 2 7 1 1         Permit Number 774102 6017404.09127 2096025.6169900002 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258)
115179 106275 7 103 42 Stanford Heights Ave 1 13 1 1           5997882.5 2095834.4 37.7346405503947 -122.449747480555 (37.7346405503947, -122.449747480555)
115215 92034 1 103 10 Elk St 2 1 1 1       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.44267015975201 (37.7402285519688, -122.442670159752)
116196 92033 1 103 10 Elk St 1 1 1 1       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.44267015975201 (37.7402285519688, -122.442670159752)
119166 92897 6 103 208 States St 1 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
119476 108200 2 103 90 Reuel Ct 1 7 1 1         Permit Number 774102 6017404.09127 2096025.6169900002 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258)
121824 92039 1 103 10 Elk St 7 1 1 1       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.44267015975201 (37.7402285519688, -122.442670159752)
122260 66251 1 103 35 HIGUERA AVE 2 1 1 1   10/24/1990 12:00:00 AM     Permit Number 29352 5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
128237 92037 1 103 10 Elk St 5 1 1 1       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.44267015975201 (37.7402285519688, -122.442670159752)
128646 92900 6 103 208 States St 4 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
128787 116019 2 103 2023 09TH AVE 1 1 1 1       6x6   5993447.0 2101700.0 37.7504912419676 -122.46550835159401 (37.7504912419676, -122.465508351594)
139866 115801 2 103 9M CAIRE TER 1 7 1 1           6012720.0 2101959.0 37.7522951385919 -122.398878598484 (37.7522951385919, -122.398878598484)
141326 113862 2 103 456 HILL ST 4 1 1 1       3x3   6003369.0 2103347.0 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346)
141792 119265 2 103 1317 Bosworth St 1 5 1 1           6000208.0 2096491.0 37.7365761953737 -122.44175457190599 (37.7365761953737, -122.441754571906)
141824 121089 5 103 1X Grand View Ave 2 1 1 1       3x3   6000227.0 2103854.0 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848)
143929 92898 6 103 208 States St 2 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
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)
34595 209040 2 103 419 Baden St 5 7 1 1     1     6000753.71672 2095344.13435 37.7334582487793 -122.43978559983 (37.7334582487793, -122.43978559983)
36668 209041 2 103 419 Baden St 6 7 1 1     1     6000751.4342 2095340.2355900002 37.7334474137664 -122.43979321169901 (37.7334474137664, -122.439793211699)
157173 209039 2 103 419 Baden St 4 7 1 1     1     6000750.66308 2095345.5130200002 37.7334618604699 -122.439796255913 (37.7334618604699, -122.439796255913)
176149 209037 2 103 419 Baden St 2 7 1 1     1     6000749.92806 2095352.54396 37.7334811239592 -122.43979930099701 (37.7334811239592, -122.439799300997)
76683 185931 2 103 2000 Sunset Blvd 74 9 1 1     2 Width 0ft   5985001.315 2101504.3546 37.749463324703996 -122.494699314147 (37.749463324704, -122.494699314147)
3850 207785 2 103 290 Santa Clara Ave 1 2 1 1   09/28/2017 12:00:00 AM 3 Width 10ft   5993081.87997 2096205.8056700001 37.7353845093885 -122.46637169180299 (37.7353845093885, -122.466371691803)
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)
20364 4837 1 103 127 Cortland Ave 1 1 1 1     3 3X3   6006404.24922 2097646.68025 37.7401005434118 -122.420413452032 (37.7401005434118, -122.420413452032)
84894 105492 2 103 1575 07TH AVE 6 1 1 1     3 3x3 Permit Number 773490 5993962.3 2104771.9 37.7589555970933 -122.463949378571 (37.7589555970933, -122.463949378571)
26956 208920 2 103 135 Saint Francis Blvd 2 2 1 1     4 Width 10ft   5992288.77396 2096040.55395 37.734884974665 -122.46910170710301 (37.734884974665, -122.469101707103)
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)
42046 209030 2 103 36 Martha Ave 7 7 1 1     5     6000755.13076 2095576.9220900002 37.7340975102859 -122.439797395328 (37.7340975102859, -122.439797395328)
66266 191737 2 103 200 Helena St 2 2 1 1     5     6010885.73151 2096220.33708 37.736435634280895 -122.40481783988199 (37.7364356342809, -122.404817839882)
130011 209032 2 103 38 Martha Ave 1 7 1 1     5     6000749.17916 2095580.7996200002 37.7341078183059 -122.43981824973301 (37.7341078183059, -122.439818249733)
178073 224242 2 103 1100 San Jose Ave 40 7 1 1     5     6004773.2240699995 2096631.25513 37.7372203683314 -122.425980609816 (37.7372203683314, -122.425980609816)
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)
35228 209038 2 103 419 Baden St 3 7 1 1     6     6000746.779019999 2095349.3205099998 37.7334720938659 -122.439809957065 (37.7334720938659, -122.439809957065)
48572 224238 2 103 1100 San Jose Ave 30 7 1 1     6     6004809.6017 2096680.0059200001 37.737356282853 -122.425858304718 (37.737356282853, -122.425858304718)
135102 224232 2 103 1100 San Jose Ave 22 7 1 1     6     6004847.66693 2096700.7431599998 37.7374153737207 -122.425728171024 (37.7374153737207, -122.425728171024)
150050 209031 2 103 36 Martha Ave 8 7 1 1     6     6000753.40861 2095578.70975 37.734102320756996 -122.43980347745001 (37.734102320757, -122.43980347745)
45082 209042 2 103 419 Baden St 7 7 1 1     7     6000746.1619 2095340.78312 37.7334486170489 -122.439811478728 (37.7334486170489, -122.439811478728)
45967 209014 2 103 412 Baden St 2 17 1 1     7     6000787.79858 2095464.06576 37.733789492485 -122.43967636459601 (37.733789492485, -122.439676364596)
148899 247820 2 103 1201 Jarboe Ave 2 7 1 1     7     6009707.559769999 2096850.2861400002 37.7380994142676 -122.40893572671699 (37.7380994142676, -122.408935726717)
154936 224219 2 103 1201 San Jose Ave 4 7 1 1     7     6004118.53569 2095824.9734900002 37.734969479450896 -122.428186723249 (37.7349694794509, -122.428186723249)
71482 176344 2 103 450 Raymond Ave 2 9 1 1     8     6008453.924319999 2088393.6006200002 37.714808853708604 -122.41267251952299 (37.7148088537086, -122.412672519523)
146980 247819 2 103 1201 Jarboe Ave 1 7 1 1     8     6009694.17454 2096850.5592099999 37.738099414264 -122.408982025597 (37.738099414264, -122.408982025597)
172652 247821 2 103 1201 Jarboe Ave 3 7 1 1     8     6009717.95526 2096849.3331900002 37.7380973799798 -122.40889971695 (37.7380973799798, -122.40889971695)
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)
56581 209009 2 103 408 Baden St 1 7 1 1     9     6000785.2821 2095342.6683900002 37.7334560202787 -122.439676364582 (37.7334560202787, -122.439676364582)
133399 224230 2 103 1100 San Jose Ave 20 7 1 1     9     6004850.154069999 2096702.7007099998 37.7374208892559 -122.425719711103 (37.7374208892559, -122.425719711103)
72359 209033 2 103 38 Martha Ave 2 7 1 1     10     6000746.954419999 2095582.5977 37.7341126287783 -122.439826070211 (37.7341126287783, -122.439826070211)
160722 209027 2 103 36 Martha Ave 4 7 1 1     10     6000763.850930001 2095573.2374 37.7340878893448 -122.439766982962 (37.7340878893448, -122.439766982962)
165768 208980 2 103 302 Santa Clara Ave 1 2 1 1     10 Width 3ft   5993091.73044 2095958.45065 37.7347059025462 -122.46631966423901 (37.7347059025462, -122.466319664239)
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)
65353 207764 2 103 1520 Monterey Blvd 2 2 1 1     11 Width 4ft   5993438.38203 2095281.4007599999 37.7328668869905 -122.46507202306299 (37.7328668869905, -122.465072023063)
113760 106810 3 103 3500X MISSION ST 10 11 1 2     11     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716)
170494 209008 2 103 406 Baden St 1 7 1 1     11     6000788.7045 2095325.02184 37.7334077617457 -122.439663267741 (37.7334077617457, -122.439663267741)
181095 247932 2 103 1099 Esmeralda Ave 5 17 1 1     11     6010369.906140001 2098762.7933799997 37.743387826290395 -122.406780401602 (37.7433878262904, -122.406780401602)
684 24323 1 103 600X Golden Gate Ave 10 1 1 1     12 3X3   6006332.380890001 2112512.31586 37.7809140549901 -122.42171754994101 (37.7809140549901, -122.421717549941)
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)
41213 224227 2 103 1100 San Jose Ave 17 7 1 1     12     6004843.36157 2096707.31423 37.7374331731056 -122.425743524245 (37.7374331731056, -122.425743524245)
54495 118438 2 103 5201 Anza St 6 2 1 1     12 Width 3ft   5982520.38622 2111663.82262 37.7772127952946 -122.50403070229099 (37.7772127952946, -122.504030702291)
63043 209019 2 103 33 Martha Ave 2 23 1 1     12     6000764.3171 2095528.5679900001 37.7339652640682 -122.43976216978201 (37.7339652640682, -122.439762169782)
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)
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)
127427 106795 3 103 199X ARLINGTON ST 55 11 1 2     12     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
Powered by Datasette · Query took 4.808ms · Data source: data.sfgov.org