sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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            
8002 19938 3 103 100 STAIRWAY38 7 1 1 2     18 10ST            
8496 20017 3 103 100 STAIRWAY48 1 1 1 2     18 10ST            
12003 20316 3 103 101X Sunset Blvd 5 1 1 2     42 60            
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            
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)
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)
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)
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)
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)
112606 105901 3 103 11X ELLIOT ST 2 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
122561 105900 3 103 11X ELLIOT ST 1 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
138343 105902 3 103 11X ELLIOT ST 3 14 1 2     40     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
89080 106004 2 103 695X CAMPBELL AVE   19 1 3           6009136.9 2088912.4 37.716271678506 -122.41034847162202 (37.716271678506, -122.410348471622)
109893 114409 6 103 500X ARBALLO DR 6 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
102874 111513 3 103 800x BOSWORTH ST 8 7 1 2     16     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
111260 111511 3 103 800x BOSWORTH ST 6 7 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
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)
Powered by Datasette · Query took 7.373ms · Data source: data.sfgov.org