sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
179689 176336 2 103 287 Hester Ave 9 17 1 1     31     6012249.60162 2087766.47281 37.713299190589794 -122.39950899437001 (37.7132991905898, -122.39950899437)
701 176335 2 103 287 Hester Ave 5 17 1 1     17     6012233.93602 2087774.2056900002 37.7133195503322 -122.399563683027 (37.7133195503322, -122.399563683027)
692 176334 2 103 287 Hester Ave 7 17 1 1     34     6012223.87562 2087782.5469900002 37.713341893097 -122.399599040764 (37.713341893097, -122.399599040764)
37470 176346 2 103 40 Teddy Ave 1 9 1 1     18     6011228.44814 2087808.7969 37.7133584325151 -122.40304144861 (37.7133584325151, -122.40304144861)
183396 176347 2 103 40 Teddy Ave 2 9 1 1     29     6011214.18105 2087815.3375799998 37.7133755951756 -122.403091220704 (37.7133755951756, -122.403091220704)
158274 176343 2 103 450 Raymond Ave 1 9 1 1     76     6008484.74111 2088383.4213400001 37.714782633086294 -122.412565284366 (37.7147826330863, -122.412565284366)
71482 176344 2 103 450 Raymond Ave 2 9 1 1     8     6008453.924319999 2088393.6006200002 37.714808853708604 -122.41267251952299 (37.7148088537086, -122.412672519523)
32543 176345 2 103 450 Raymond Ave 3 9 1 1     34     6008420.88631 2088405.51015 37.7148397004654 -122.412787554496 (37.7148397004654, -122.412787554496)
3843 253568 6 103 301X Sargent St 1 8 1 1       3x3   5993018.0 2089140.0 37.7159798527116 -122.46607925705901 (37.7159798527116, -122.466079257059)
109893 114409 6 103 500X ARBALLO DR 6 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
113956 114069 2 103 2 HIGUERA AVE 2 2 1 1     40     5988091.0 2090188.0 37.7185719141165 -122.483185851801 (37.7185719141165, -122.483185851801)
90554 114400 2 103 1X HIGUERA AVE 3 5 1 1     22 3x3   5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
92772 114075 2 103 24 HIGUERA AVE 1 2 1 1     26     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
108603 114396 1 103 35 HIGUERA AVE 3 1 1 1           5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
113582 114403 2 103 1X HIGUERA AVE 6 1 1 1     25 3x3   5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
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)
138466 114076 2 103 24 HIGUERA AVE 2 2 1 1     24     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
54108 176348 2 103 0 Fuente Ave 2 2 1 1     26     5989603.79735 2090546.09261 37.7196430676648 -122.47798295295799 (37.7196430676648, -122.477982952958)
171841 176342 2 103 101 Mansell St 1 1 1 1     18 Width 3ft   6011455.5144 2090588.63485 37.721003982019504 -122.40245197087799 (37.7210039820195, -122.402451970878)
175511 208978 2 103 700 Junipero Serra Blvd 109 4 1 1     14 Width 0ft   5991241.872330001 2091923.37185 37.723519677182495 -122.47242112456001 (37.7235196771825, -122.47242112456)
48548 65198 1 103 371 Madrid St 1 1 1 1 1 07/29/1989 12:00:00 AM 34   Permit Number 27183 6003158.74485 2091706.4873099998 37.7236066919673 -122.431211180179 (37.7236066919673, -122.431211180179)
175100 207765 2 103 356 Santa Ana Ave 1 1 1 1     25 Width 3ft   5992543.86147 2094436.1305 37.7304943639181 -122.46810311696998 (37.7304943639181, -122.46810311697)
103018 104402 2 103 301 Joost Ave 1 9 1 1           6000011.7 2094912.1 37.7322297190532 -122.44231994912901 (37.7322297190532, -122.442319949129)
74562 209046 2 103 301 Joost Ave 1 9 1 1     55 Width 10ft   5999983.24986 2094934.98428 37.732290932375605 -122.442419949729 (37.7322909323756, -122.442419949729)
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)
154149 201514 2 103 1001 Innes Ave 12 7 1 1     75     6018663.55815 2094844.4948099998 37.733089515074795 -122.377830854436 (37.7330895150748, -122.377830854436)
161658 209044 2 103 690 Mangels Ave 8 9 1 1     30 Width 10ft   5996811.85436 2095301.80777 37.7331168670328 -122.453410604043 (37.7331168670328, -122.453410604043)
46778 209043 2 103 690 Mangels Ave 5 9 1 1     54 Width 10ft   5996832.93686 2095303.5906200001 37.7331229707542 -122.453337845278 (37.7331229707542, -122.453337845278)
172222 201510 2 103 1001 Innes Ave 8 7 1 1     38     6018594.17439 2094891.11142 37.73321369166371 -122.378073969944 (37.7332136916637, -122.378073969944)
175986 207763 2 103 290 Santa Clara Ave 1 2 1 1     36 Width 10ft   5993266.97338 2095443.21542 37.7333013044925 -122.46567637377599 (37.7333013044925, -122.465676373776)
170494 209008 2 103 406 Baden St 1 7 1 1     11     6000788.7045 2095325.02184 37.7334077617457 -122.439663267741 (37.7334077617457, -122.439663267741)
36668 209041 2 103 419 Baden St 6 7 1 1     1     6000751.4342 2095340.2355900002 37.7334474137664 -122.43979321169901 (37.7334474137664, -122.439793211699)
45082 209042 2 103 419 Baden St 7 7 1 1     7     6000746.1619 2095340.78312 37.7334486170489 -122.439811478728 (37.7334486170489, -122.439811478728)
56581 209009 2 103 408 Baden St 1 7 1 1     9     6000785.2821 2095342.6683900002 37.7334560202787 -122.439676364582 (37.7334560202787, -122.439676364582)
34595 209040 2 103 419 Baden St 5 7 1 1     1     6000753.71672 2095344.13435 37.7334582487793 -122.43978559983 (37.7334582487793, -122.43978559983)
157173 209039 2 103 419 Baden St 4 7 1 1     1     6000750.66308 2095345.5130200002 37.7334618604699 -122.439796255913 (37.7334618604699, -122.439796255913)
35228 209038 2 103 419 Baden St 3 7 1 1     6     6000746.779019999 2095349.3205099998 37.7334720938659 -122.439809957065 (37.7334720938659, -122.439809957065)
176149 209037 2 103 419 Baden St 2 7 1 1     1     6000749.92806 2095352.54396 37.7334811239592 -122.43979930099701 (37.7334811239592, -122.439799300997)
134583 209010 2 103 408 Baden St 2 7 1 1     41     6000785.06362 2095352.2063400003 37.7334821968386 -122.439677803484 (37.7334821968386, -122.439677803484)
182141 209011 2 103 408 Baden St 3 7 1 1     13     6000782.1941599995 2095354.33843 37.7334878877384 -122.439687876799 (37.7334878877384, -122.439687876799)
25962 209036 2 103 427 Baden St 2 7 1 1     41     6000750.14831 2095370.65935 37.7335308771479 -122.439799837889 (37.7335308771479, -122.439799837889)
165522 209035 2 103 427 Baden St 1 7 1 1     32     6000759.78323 2095371.55913 37.733533896164104 -122.43976659178101 (37.7335338961641, -122.439766591781)
159119 209012 2 103 410 Baden St 1 7 1 1     24     6000789.00569 2095372.0781 37.7335369844496 -122.439665598801 (37.7335369844496, -122.439665598801)
48153 209013 2 103 412 Baden St 1 17 1 1     20     6000780.48794 2095392.50815 37.7335925958074 -122.439696511209 (37.7335925958074, -122.439696511209)
69214 208986 2 103 372 Santa Clara Ave 2 2 1 1     24 Width 3ft   5993143.09775 2095558.09178 37.7336095804246 -122.46611298742701 (37.7336095804246, -122.466112987427)
52384 208985 2 103 372 Santa Clara Ave 1 2 1 1     59 Width 3ft   5993126.32529 2095592.5648700001 37.7337032672843 -122.466173478533 (37.7337032672843, -122.466173478533)
45967 209014 2 103 412 Baden St 2 17 1 1     7     6000787.79858 2095464.06576 37.733789492485 -122.43967636459601 (37.733789492485, -122.439676364596)
35692 209045 2 103 300 Melrose Ave 3 17 1 1     88     5998032.3562900005 2095523.6559099997 37.733795893852296 -122.44920699922599 (37.7337958938523, -122.449206999226)
189014 209015 2 103 412 Baden St 3 17 1 1     12     6000779.78636 2095479.1538 37.73383046469421 -122.439705146498 (37.7338304646942, -122.439705146498)
114729 96803 2 103 300X Melrose Ave 1 14 1 1     48     5998134.5 2095546.7 37.733865009274204 -122.448855518806 (37.7338650092742, -122.448855518806)
182600 209016 2 103 412 Baden St 4 17 1 1     16     6000787.61929 2095495.57167 37.7338759901863 -122.43967924239901 (37.7338759901863, -122.439679242399)
36584 208984 2 103 354 Santa Clara Ave 1 2 1 1     38 Width 3ft   5993109.71634 2095669.50335 37.7339135629453 -122.466236489538 (37.7339135629453, -122.466236489538)
158456 207762 2 103 355 Santa Clara Ave 1 2 1 1     25 Width 10ft   5993165.17049 2095669.26931 37.7339161197195 -122.46604475226499 (37.7339161197195, -122.466044752265)
28853 209017 2 103 33 Martha Ave 1 23 1 1     25     6000774.79116 2095519.5815700002 37.7339411856303 -122.43972531378401 (37.7339411856303, -122.439725313784)
63043 209019 2 103 33 Martha Ave 2 23 1 1     12     6000764.3171 2095528.5679900001 37.7339652640682 -122.43976216978201 (37.7339652640682, -122.439762169782)
185838 209018 2 103 33 Martha Ave 3 23 1 1     38     6000767.57935 2095529.42368 37.733967799282 -122.439750952539 (37.733967799282, -122.439750952539)
153234 209020 2 103 33 Martha Ave 4 23 1 1     12     6000767.68455 2095534.49854 37.7339817396554 -122.439750952547 (37.7339817396554, -122.439750952547)
27200 209021 2 103 34 Martha Ave 1 7 1 1     25     6000790.06178 2095561.6998400001 37.7340577017886 -122.43967553722 (37.7340577017886, -122.43967553722)
30144 209022 2 103 34 Martha Ave 2 7 1 1     33     6000785.93499 2095562.5681900003 37.7340598511869 -122.43968986701401 (37.7340598511869, -122.439689867014)
156854 209023 2 103 34 Martha Ave 3 7 1 1     20     6000780.47253 2095565.1582 37.7340666518368 -122.439708938014 (37.7340666518368, -122.439708938014)
77296 209024 2 103 36 Martha Ave 1 7 1 1     32     6000772.29534 2095570.30388 37.7340803152378 -122.43973757782601 (37.7340803152378, -122.439737577826)
57024 209025 2 103 36 Martha Ave 2 7 1 1     46     6000769.58789 2095570.4874200001 37.7340806650885 -122.43974695145599 (37.7340806650885, -122.439746951456)
158564 209026 2 103 36 Martha Ave 3 7 1 1     24     6000767.091 2095571.9190599998 37.7340844539158 -122.439755686569 (37.7340844539158, -122.439755686569)
160722 209027 2 103 36 Martha Ave 4 7 1 1     10     6000763.850930001 2095573.2374 37.7340878893448 -122.439766982962 (37.7340878893448, -122.439766982962)
148610 209028 2 103 36 Martha Ave 5 7 1 1     29     6000760.3597 2095574.5612700002 37.7340913256606 -122.439779148088 (37.7340913256606, -122.439779148088)
72350 209029 2 103 36 Martha Ave 6 7 1 1     18     6000758.12976 2095576.10922 37.7340954490409 -122.43978696861299 (37.7340954490409, -122.439786968613)
42046 209030 2 103 36 Martha Ave 7 7 1 1     5     6000755.13076 2095576.9220900002 37.7340975102859 -122.439797395328 (37.7340975102859, -122.439797395328)
150050 209031 2 103 36 Martha Ave 8 7 1 1     6     6000753.40861 2095578.70975 37.734102320756996 -122.43980347745001 (37.734102320757, -122.43980347745)
130011 209032 2 103 38 Martha Ave 1 7 1 1     5     6000749.17916 2095580.7996200002 37.7341078183059 -122.43981824973301 (37.7341078183059, -122.439818249733)
55842 207761 2 103 345 Santa Clara Ave 1 2 1 1     41 Width 10ft   5993145.033430001 2095739.54752 37.7341079244482 -122.46611947693701 (37.7341079244482, -122.466119476937)
72359 209033 2 103 38 Martha Ave 2 7 1 1     10     6000746.954419999 2095582.5977 37.7341126287783 -122.439826070211 (37.7341126287783, -122.439826070211)
138770 209034 2 103 38 Martha Ave 3 7 1 1     30     6000740.95615 2095584.22378 37.7341167521787 -122.439846924607 (37.7341167521787, -122.439846924607)
53855 208983 2 103 330 Santa Clara Ave 1 2 1 1     35 Width 3ft   5993097.51511 2095800.07009 37.73427136274 -122.466288158284 (37.73427136274, -122.466288158284)
162672 207760 2 103 333 Santa Clara Ave 1 2 1 1     16 Width 10ft   5993144.47081 2095802.99513 37.734282103340796 -122.46612603120501 (37.7342821033408, -122.466126031205)
131911 207759 2 103 315 Santa Clara Ave 1 2 1 1     20 Width 10ft   5993145.97421 2095838.45755 37.7343795610583 -122.46612340966999 (37.7343795610583, -122.46612340967)
112663 114044 2 103 549X ARLINGTON ST   11 1 1     70     6003400.0 2095634.0 37.734404428182295 -122.430657330781 (37.7344044281823, -122.430657330781)
23367 208982 2 103 320 Santa Clara Ave 1 2 1 1     45 Width 3ft   5993096.565780001 2095876.3159599998 37.7344806601409 -122.46629697974501 (37.7344806601409, -122.466296979745)
105598 106227 7 103 38 Stanford Heights Ave 1 13 1 1           5997884.0 2095808.5 37.7345695210024 -122.44974042873999 (37.7345695210024, -122.44974042874)
24602 208981 2 103 310 Santa Clara Ave 1 2 1 1     43 Width 3ft   5993092.40274 2095921.0497 37.7346032476459 -122.466314622626 (37.7346032476459, -122.466314622626)
115179 106275 7 103 42 Stanford Heights Ave 1 13 1 1           5997882.5 2095834.4 37.7346405503947 -122.449747480555 (37.7346405503947, -122.449747480555)
76953 208935 2 103 3 Saint Francis Blvd 1 2 1 1     16 Width 10ft   5991812.79149 2095969.62922 37.7346627188958 -122.47074216493401 (37.7346627188958, -122.470742164934)
152307 208936 2 103 3 Saint Francis Blvd 2 2 1 1     15 Width 10ft   5991855.38456 2095971.03212 37.7346690339426 -122.470595009771 (37.7346690339426, -122.470595009771)
76936 208937 2 103 64 Saint Francis Blvd 1 2 1 1     36 Width 10ft   5991925.34536 2095973.96809 37.734681140613105 -122.47035334753201 (37.7346811406131, -122.470353347532)
28258 208938 2 103 66 Saint Francis Blvd 1 2 1 1     28 Width 10ft   5991979.81471 2095977.19537 37.7346931510662 -122.470165265142 (37.7346931510662, -122.470165265142)
185411 208939 2 103 100 Saint Francis Blvd 1 2 1 1     33 Width 10ft   5992155.70572 2095974.23732 37.7346951961161 -122.469556940308 (37.7346951961161, -122.469556940308)
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)
26365 208940 2 103 100 Saint Francis Blvd 2 2 1 1     37 Width 10ft   5992201.32921 2095978.5342700002 37.7347096311457 -122.469399518468 (37.7347096311457, -122.469399518468)
41832 208941 2 103 130 Saint Francis Blvd 1 2 1 1     30 Width 10ft   5992287.573419999 2095984.60456 37.734731282309106 -122.469101787134 (37.7347312823091, -122.469101787134)
64951 208942 2 103 200 Saint Francis Blvd 1 2 1 1     32 Width 10ft   5992406.13159 2095989.66706 37.7347520323855 -122.468692262863 (37.7347520323855, -122.468692262863)
131518 208943 2 103 200 Saint Francis Blvd 2 2 1 1     39 Width 10ft   5992457.65692 2095992.19703 37.7347619554908 -122.46851430770701 (37.7347619554908, -122.468514307707)
25657 208945 2 103 234 Saint Francis Blvd 2 2 1 1     40 Width 10ft   5992554.30272 2095990.82137 37.73476376044329 -122.46818007286001 (37.7347637604433, -122.46818007286)
180635 208944 2 103 234 Saint Francis Blvd 1 2 1 1     41 Width 10ft   5992497.26068 2095992.6782799999 37.73476556447329 -122.468377420108 (37.7347655644733, -122.468377420108)
155663 208953 2 103 502 Saint Francis Blvd 1 2 1 1     25 Width 8ft   5993239.50835 2095986.2551799999 37.734790772481 -122.46581076936701 (37.734790772481, -122.465810769367)
173362 208948 2 103 340 Saint Francis Blvd 2 2 1 1     32 Width 10ft   5992820.42769 2095999.6816200002 37.734803454707496 -122.46726063928499 (37.7348034547075, -122.467260639285)
71759 208946 2 103 300 Saint Francis Blvd 2 2 1 1     13 Width 10ft   5992719.83793 2096001.79663 37.7348034547201 -122.467608563598 (37.7348034547201, -122.467608563598)
167226 208947 2 103 340 Saint Francis Blvd 1 2 1 1     35 Width 10ft   5992761.11825 2096003.55707 37.734810671779705 -122.467465972472 (37.7348106717797, -122.467465972472)
61439 208913 2 103 25 Saint Francis Blvd 1 2 1 1     52 Width 10ft   5991855.18446 2096027.3519599999 37.7348236624713 -122.470599802253 (37.7348236624713, -122.470599802253)
153452 208949 2 103 402 Saint Francis Blvd 2 2 1 1     26 Width 10ft   5992933.736169999 2096006.17085 37.7348278128415 -122.46686936763099 (37.7348278128415, -122.466869367631)
24218 208954 2 103 600 Saint Francis Blvd 3 2 1 1     30 Width 8ft   5993495.97502 2095994.9515900002 37.7348294415148 -122.464924714122 (37.7348294415148, -122.464924714122)
72305 208950 2 103 440 Saint Francis Blvd 1 2 1 1     26 Width 10ft   5992985.54967 2096006.72468 37.734832323836706 -122.46669027215599 (37.7348323238367, -122.466690272156)
70660 208956 2 103 630 Saint Francis Blvd 2 2 1 1     35 Width 8ft   5993584.21489 2095997.1565599998 37.7348405832115 -122.464619800786 (37.7348405832115, -122.464619800786)
Powered by Datasette · Query took 7.807ms · Data source: data.sfgov.org