sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
151681 118454 2 62 8350 Geary Blvd 1 9 1 1     7     5981044.43167 2112373.0207700003 37.7790731383894 -122.50918908645399 (37.7790731383894, -122.509189086454)
189129 182301 2 62 2537 Kirkham St 1 1 1 1     4 Width 0ft   5986893.9274 2105029.3143 37.7592525025823 -122.488413720954 (37.7592525025823, -122.488413720954)
56115 182302 2 62 2535 Kirkham St 2 1 1 1     3 Width 0ft   5986906.12 2105029.3143 37.7592532139832 -122.488371553614 (37.7592532139832, -122.488371553614)
40247 182303 2 62 2533 Kirkham St 3 1 1 1     4 Width 0ft   5986913.9581 2105029.3143 37.7592536713044 -122.488344446038 (37.7592536713044, -122.488344446038)
160391 120011 2 62 886 29th Ave 2 9 1 1     4 Width 5ft   5987003.60348 2109935.62097 37.7727302588392 -122.48839498846 (37.7727302588392, -122.48839498846)
162278 183548 2 62 2590 23rd Ave 2 1 1 1     9 Width 0ft   5989271.0961 2097748.8175 37.7394005980364 -122.479659706735 (37.7394005980364, -122.479659706735)
51194 99324 2 62 1150 Vicente St 7 1 1 1     11 3x3   5989313.9402 2097680.7708 37.739216248209 -122.479506595172 (37.739216248209, -122.479506595172)
173203 99323 2 62 1150 Vicente St 6 1 1 1     9 3x3   5989330.3766 2097681.8666 37.73922021170971 -122.479449846275 (37.7392202117097, -122.479449846275)
165203 99322 2 62 1150 Vicente St 5 1 1 1     5 3x3   5989346.812999999 2097682.9624 37.739224175183 -122.479393097373 (37.739224175183, -122.479393097373)
59050 99321 2 62 1150 Vicente St 4 1 1 1     8 3x3   5989362.5919 2097683.4007 37.7392262951159 -122.47933857369101 (37.7392262951159, -122.479338573691)
166570 99320 2 62 1150 Vicente St 3 1 1 1     3 3x3   5989380.1241 2097683.1815 37.7392267115304 -122.479277939862 (37.7392267115304, -122.479277939862)
133189 120726 2 62 450 21st Ave 1 1 1 1     4 Width 2ft   5989392.84856 2112260.68272 37.779253349203294 -122.480300629667 (37.7792533492033, -122.480300629667)
134764 99319 2 62 1150 Vicente St 2 1 1 1     8 3x3   5989394.1498 2097683.839 37.73922933145371 -122.479229493917 (37.7392293314537, -122.479229493917)
91835 99325 2 62 1150@23rd Ave Vicente St 1 1 1 1       4.5x6   5989403.0 2097682.0 37.73922479603689 -122.479198759749 (37.7392247960369, -122.479198759749)
76802 99318 2 62 1150 Vicente St 1 1 1 1     7 3x3   5989408.3581 2097684.4234 37.7392317612483 -122.47918041128 (37.7392317612483, -122.47918041128)
11928 105246 2 62 2439 22nd Ave 1 1 1 1     14 6x6   5989501.8448 2098751.2622 37.7421664525595 -122.478935190185 (37.7421664525595, -122.478935190185)
147926 121858 2 62 682 19th Ave 1 1 1 1     13 Width 3ft   5990066.45835 2110748.50952 37.7751404594463 -122.477859785758 (37.7751404594463, -122.477859785758)
23828 177148 2 62 1100 Junipero Serra Blvd 11 4 1 1     3 Width 0ft   5991345.1062 2088786.2704900003 37.7149119421181 -122.47183574413401 (37.7149119421181, -122.471835744134)
52418 177149 2 62 1100 Junipero Serra Blvd 12 4 1 1     3 Width 0ft   5991352.53535 2088761.3617099999 37.714843978538205 -122.47180825186301 (37.7148439785382, -122.471808251863)
162256 177150 2 62 1100 Junipero Serra Blvd 13 4 1 1     3 Width 0ft   5991357.8727400005 2088731.5467 37.7147624226096 -122.471787632218 (37.7147624226096, -122.471787632218)
153199 208100 2 62 2291 15th Ave 1 1 1 1     9 Width 3ft   5991679.25346 2099828.9819099996 37.7452517953444 -122.471484974349 (37.7452517953444, -122.471484974349)
26594 208099 2 62 2291 15th Ave 2 1 1 1     8 Width 3ft   5991681.99819 2099835.94672 37.745271077706704 -122.471475991035 (37.7452710777067, -122.471475991035)
186783 208098 2 62 2291 15th Ave 3 1 1 1     8 Width 3ft   5991684.149119999 2099849.94635 37.74530964152321 -122.471469573465 (37.7453096415232, -122.471469573465)
44075 124022 2 62 301 Funston Ave 4 2 1 1     18 Width 3ft   5991831.5909 2112929.38774 37.7812308417217 -122.471912840662 (37.7812308417217, -122.471912840662)
168652 218235 2 62 359 Wawona St 1 2 1 1     12 Width 2ft   5991961.59976 2097124.91171 37.73784343751829 -122.470311793456 (37.7378434375183, -122.470311793456)
153373 208112 2 62 2555 14th Ave 1 1 1 1     7 Width 3ft   5992037.32657 2098038.7861599997 37.7403570831075 -122.47011649758801 (37.7403570831075, -122.470116497588)
60879 208111 2 62 2559 14th Ave 1 1 1 1     7 Width 3ft   5992039.89052 2098021.8056099997 37.740310607054894 -122.470106396399 (37.7403106070549, -122.470106396399)
167306 208019 2 62 1256 Funston Ave 1 1 1 1     8 Width 4ft   5992092.96115 2106864.9565 37.7645946702215 -122.470566813326 (37.7645946702215, -122.470566813326)
48143 208054 2 62 1 San Fernando Way 3 2 1 1     6 Width 8ft   5992102.39322 2096463.5019599998 37.736035512423 -122.46977686683 (37.736035512423, -122.46977686683)
180850 208057 2 62 2105 Funston Ave 2 1 1 1     2 Width 3ft   5992245.259459999 2101079.6682 37.7487185865149 -122.46961886943599 (37.7487185865149, -122.469618869436)
71209 208056 2 62 2105 Funston Ave 1 1 1 1     7 Width 3ft   5992245.83027 2101094.43022 37.7487591522095 -122.46961797009399 (37.7487591522095, -122.469617970094)
67413 208058 2 62 2105 Funston Ave 3 1 1 1     6 Width 3ft   5992246.20583 2101062.80127 37.7486723289665 -122.469614369217 (37.7486723289665, -122.469614369217)
68119 208059 2 62 2105 Funston Ave 4 1 1 1     2 Width 3ft   5992246.63721 2101046.2039400004 37.7486267819054 -122.469611669441 (37.7486267819054, -122.469611669441)
29002 208061 2 62 2105 Funston Ave 6 1 1 1     6 Width 3ft   5992248.52602 2101024.65147 37.748567713538996 -122.46960356926901 (37.748567713539, -122.469603569269)
148810 208060 2 62 2105 Funston Ave 5 1 1 1     1 Width 3ft   5992248.76597 2101036.0508 37.748599027031496 -122.46960356926 (37.7485990270315, -122.46960356926)
188394 208043 2 62 1954 Funston Ave 1 1 1 1     3 Width 2ft   5992271.8581 2102134.57412 37.751616623007 -122.469603676282 (37.751616623007, -122.469603676282)
154679 208105 2 62 2339 Funston Ave 1 2 1 1     4 Width 3ft   5992296.97523 2099528.1746 37.7444615718506 -122.469327124863 (37.7444615718506, -122.469327124863)
159073 208104 2 62 2349 Funston Ave 1 2 1 1     7 Width 3ft   5992300.54287 2099449.8007799997 37.7442465835224 -122.469309085355 (37.7442465835224, -122.469309085355)
129860 208103 2 62 2353 Funston Ave 1 2 1 1     8 Width 3ft   5992301.035730001 2099420.10379 37.7441650716512 -122.469305220056 (37.7441650716512, -122.469305220056)
57153 208102 2 62 2357 Funston Ave 1 2 1 1     8 Width 3ft   5992303.47716 2099394.44752 37.7440947671662 -122.46929491115401 (37.7440947671662, -122.469294911154)
74489 208101 2 62 2357 Funston Ave 2 1 1 1     8 Width 3ft   5992303.56626 2099363.27465 37.7440091795707 -122.469292334575 (37.7440091795707, -122.469292334575)
152821 208062 2 62 2192 Funston Ave 1 1 1 1     15 Width 2ft   5992310.81526 2100558.61038 37.7472916843786 -122.469354258319 (37.7472916843786, -122.469354258319)
72962 208050 2 62 2338 Funston Ave 1 1 1 1     6 Width 4ft   5992343.816769999 2099531.60984 37.7444737108967 -122.46916540785601 (37.7444737108967, -122.469165407856)
158220 208049 2 62 2340 Funston Ave 2 1 1 1     5 Width 4ft   5992344.1762 2099503.1223 37.744395512154796 -122.46916209207899 (37.7443955121548, -122.469162092079)
25465 208048 2 62 2344 Funston Ave 1 1 1 1     4 Width 4ft   5992344.38135 2099463.27392 37.74428611053071 -122.469158483081 (37.7442861105307, -122.469158483081)
73671 208047 2 62 2356 Funston Ave 2 1 1 1     7 Width 4ft   5992346.98246 2099405.01198 37.744126288412396 -122.46914524958 (37.7441262884124, -122.46914524958)
56459 208046 2 62 2356 Funston Ave 1 2 1 1     7 Width 4ft   5992347.94359 2099384.54976 37.744070159913996 -122.469140437284 (37.744070159914, -122.469140437284)
78079 107066 2 62 1758 12th Ave 1 7 1 1   07/24/2014 12:00:00 AM     Permit Number 773344 5992506.32742 2103625.79831 37.7557246862805 -122.468901366602 (37.7557246862805, -122.468901366602)
72595 208109 2 62 2325 12th Ave 1 1 1 1     12 Width 3ft   5992602.58698 2099633.7724 37.7447691723617 -122.468278072002 (37.7447691723617, -122.468278072002)
158225 208108 2 62 2325 12th Ave 2 1 1 1     11 Width 3ft   5992604.0801800005 2099624.3028 37.7447432574969 -122.468272220082 (37.7447432574969, -122.468272220082)
58305 208107 2 62 2325 12th Ave 3 1 1 1     17 Width 3ft   5992604.896919999 2099614.84743 37.7447173426335 -122.468268708247 (37.7447173426335, -122.468268708247)
76625 208106 2 62 2367 12th Ave 1 1 1 1     10 Width 3ft   5992612.0223 2099358.1816 37.744013015182 -122.46822540229999 (37.744013015182, -122.4682254023)
180818 208044 2 62 25 Forest Side Ave 1 1 1 1     10 Width 3ft   5992692.13842 2098948.0132400002 37.7428914239144 -122.467918553594 (37.7428914239144, -122.467918553594)
172894 208045 2 62 25 Forest Side Ave 2 1 1 1     9 Width 3ft   5992699.77164 2098959.9602799998 37.7429246682415 -122.46789302904399 (37.7429246682415, -122.467893029044)
76968 208097 2 62 1578 11th Ave 1 1 1 1     8 Width 3ft   5992786.16766 2104723.32687 37.7587543775304 -122.468013427586 (37.7587543775304, -122.468013427586)
179943 208052 2 62 225 San Benito Way 4 1 1 1     3 Width 3ft   5992910.68234 2095197.7097 37.732606649283106 -122.466890318243 (37.7326066492831, -122.466890318243)
135110 208051 2 62 225 San Benito Way 3 1 1 1     1 Width 3ft   5992912.8595 2095175.00787 37.7325444413573 -122.466881141568 (37.7325444413573, -122.466881141568)
164304 218332 2 62 490 Castenada Ave 1 2 1 1     13 Width 0ft   5992960.68129 2099942.11399 37.7456364758511 -122.46706227402001 (37.7456364758511, -122.46706227402)
36958 218331 2 62 480 Castenada Ave 3 2 1 1     12 Width 0ft   5992969.5872 2099943.88935 37.745641864594 -122.46703160803601 (37.745641864594, -122.467031608036)
77020 218330 2 62 480 Castenada Ave 2 2 1 1     16 Width 0ft   5992991.749009999 2099943.42348 37.7456418645961 -122.46695494261499 (37.7456418645961, -122.466954942615)
70183 218329 2 62 480 Castenada Ave 1 2 1 1     10 Width 0ft   5993003.09698 2099944.16622 37.745644558947895 -122.466915757358 (37.7456445589479, -122.466915757358)
74832 208034 2 62 335 Lawton St 2 1 1 1     10 Width 4ft   5993191.52104 2104559.2790099997 37.7583273452475 -122.46659961690001 (37.7583273452475, -122.4665996169)
40839 208110 2 62 500 Cortes Ave 1 2 1 1     27 Width 3ft   5993194.87968 2099514.9753099997 37.744477176897504 -122.466221422307 (37.7444771768975, -122.466221422307)
162228 208033 2 62 335 Lawton St 1 1 1 1     13 Width 4ft   5993206.76196 2104560.12177 37.7583305387516 -122.466546968789 (37.7583305387516, -122.466546968789)
170340 218321 2 62 414 Castenada Ave 1 2 1 1     6 Width 0ft   5993266.671709999 2099966.5931 37.7457213466715 -122.466005992402 (37.7457213466715, -122.466005992402)
128383 106785 2 62 335 Lawton St 2 1 1 1     10 6x8   5993281.0 2104569.0 37.7583591997637 -122.466290868324 (37.7583591997637, -122.466290868324)
50220 218320 2 62 400 Castenada Ave 1 2 1 1     6 Width 0ft   5993320.26177 2099984.60198 37.7457738859626 -122.465821995605 (37.7457738859626, -122.465821995605)
137384 208053 2 62 111 Westgate Dr 1 1 1 1     17 Width 3ft   5993326.69721 2093754.23227 37.7286672184966 -122.465347248004 (37.7286672184966, -122.465347248004)
44840 208096 2 62 1504 09th Ave 1 1 1 1     3 Width 3ft   5993391.51426 2105173.9377900003 37.760026577386206 -122.465952620345 (37.7600265773862, -122.465952620345)
167431 208095 2 62 1506 09th Ave 1 1 1 1     4 Width 3ft   5993392.85982 2105153.99383 37.759971894093596 -122.465946517542 (37.7599718940936, -122.465946517542)
89696 111418 2 62 200x SAN MARCOS AVE 3 3 1 1     5     5993395.0 2100395.0 37.746905045660796 -122.465593373526 (37.7469050456608, -122.465593373526)
103771 111426 2 62 200x SAN MARCOS AVE 11 3 1 1     6     5993395.0 2100395.0 37.746905045660796 -122.465593373526 (37.7469050456608, -122.465593373526)
123711 208032 2 62 245 Lawton St 6 1 1 1     5 Width 2ft   5993439.73777 2104571.93456 37.7583764149554 -122.46574210073601 (37.7583764149554, -122.465742100736)
178079 122999 2 62 42 07th Ave 1 2 1 1     10 Width 4ft   5993659.38134 2115213.58534 37.787608218531794 -122.46575564845699 (37.7876082185318, -122.465755648457)
72798 208031 2 62 1639 08th Ave 1 2 1 1     7 Width 4ft   5993679.7904900005 2104335.94155 37.7577422831841 -122.46489476039801 (37.7577422831841, -122.464894760398)
33653 208029 2 62 1635 08th Ave 1 2 1 1     16 Width 4ft   5993680.14998 2104375.72277 37.7578515328401 -122.464896406148 (37.7578515328401, -122.464896406148)
170254 208030 2 62 1635 08th Ave 2 2 1 1     17 Width 4ft   5993680.60393 2104352.02929 37.7577865028534 -122.464893115536 (37.7577865028534, -122.464893115536)
130544 208028 2 62 1616 08th Ave 1 1 1 1     10 Width 4ft   5993726.3852 2104458.9958200003 37.7580828447759 -122.46474255373 (37.7580828447759, -122.46474255373)
167660 208024 2 62 1652 08th Ave 1 1 1 1     1 Width 2ft   5993734.6687900005 2104236.25735 37.7574717401585 -122.464697731525 (37.7574717401585, -122.464697731525)
179894 208025 2 62 1652 08th Ave 2 1 1 1     7 Width 4ft   5993735.965559999 2104244.11909 37.7574934012238 -122.464693817688 (37.7574934012238, -122.464693817688)
37797 208027 2 62 1648 08th Ave 2 1 1 1     10 Width 4ft   5993736.02678 2104273.98394 37.7575754059053 -122.464695774593 (37.7575754059053, -122.464695774593)
151047 208022 2 62 1670 08th Ave 1 1 1 1     8 Width 4ft   5993736.11126 2104143.24753 37.7572164424068 -122.46468598908301 (37.7572164424068, -122.464685989083)
54384 208026 2 62 1648 08th Ave 1 1 1 1     7 Width 4ft   5993736.35584 2104262.7066 37.7575444602181 -122.464693817678 (37.7575444602181, -122.464693817678)
66953 208023 2 62 1662 08th Ave 1 1 1 1     7 Width 4ft   5993736.46788 2104187.19404 37.7573371287194 -122.46468794689899 (37.7573371287194, -122.464687946899)
43808 208021 2 62 1684 08th Ave 1 1 1 1     10 Width 4ft   5993741.97238 2104049.76533 37.7569601023484 -122.464658931187 (37.7569601023484, -122.464658931187)
52402 208035 2 62 1722 08th Ave 1 1 1 1     1 Width 3ft   5993749.1972900005 2103750.68638 37.7561393252901 -122.464612228482 (37.7561393252901, -122.464612228482)
51342 208037 2 62 1794 08th Ave 1 1 1 1     5 Width 2ft   5993763.2785 2103312.19081 37.7549361412039 -122.46453169330299 (37.7549361412039, -122.464531693303)
36852 208036 2 62 1780 08th Ave 2 1 1 1     5 Width 2ft   5993763.84013 2103377.07875 37.755114339159896 -122.46453446231199 (37.7551143391599, -122.464534462312)
172704 208038 2 62 1800 08th Ave 5 1 1 1     4 Width 2ft   5993764.599359999 2103288.67174 37.754871640034 -122.46452541781 (37.754871640034, -122.46452541781)
41944 208039 2 62 1800 08th Ave 4 1 1 1     5 Width 2ft   5993764.89188 2103262.79505 37.7548006061648 -122.464522527406 (37.7548006061648, -122.464522527406)
41985 208040 2 62 1800 08th Ave 3 1 1 1     5 Width 2ft   5993765.03944 2103252.9034 37.7547734547454 -122.464521298918 (37.7547734547454, -122.464521298918)
157634 208041 2 62 1800 08th Ave 2 1 1 1     5 Width 2ft   5993766.80604 2103235.31839 37.7547252726705 -122.46451391281299 (37.7547252726705, -122.464513912813)
178319 208042 2 62 1800 08th Ave 1 1 1 1     5 Width 2ft   5993767.09464 2103220.25366 37.7546839254342 -122.464511820986 (37.7546839254342, -122.464511820986)
167552 208137 2 62 41 Santa Rita Ave 1 2 1 1     9 Width 3ft   5993786.87978 2100730.78266 37.7478496147728 -122.464262673683 (37.7478496147728, -122.464262673683)
67084 123796 2 62 1550 Anza St 2 1 1 1     11 Width 5ft   5993793.84449 2112124.03486 37.7791329069537 -122.465065956135 (37.7791329069537, -122.465065956135)
167670 208127 2 62 1980 08th Ave 1 2 1 1     14 Width 3ft   5993803.248930001 2102010.84689 37.7513652885894 -122.46429899101801 (37.7513652885894, -122.464298991018)
36027 123795 2 62 1550 Anza St 1 1 1 1     12 Width 5ft   5993809.03734 2112124.4569200003 37.7791349418605 -122.465013428941 (37.7791349418605, -122.465013428941)
175402 208063 2 62 459 Pacheco St 4 2 1 1     9 Width 6ft   5993844.11289 2101701.56795 37.750518442888705 -122.464135229877 (37.7505184428887, -122.464135229877)
75949 208138 2 62 11 Santa Rita Ave 2 2 1 1     13 Width 3ft   5993885.92048 2100911.41075 37.748351281781 -122.463933307785 (37.748351281781, -122.463933307785)
160043 218388 2 62 50 San Marcos Ave 10 2 1 1     8 Width 0ft   5993887.93086 2100247.90665 37.7465295835701 -122.463878201824 (37.7465295835701, -122.463878201824)
78186 106660 2 62 1550X Anza St 1 1 1 1       6x12   5993905.48812 2112097.55644 37.7790666413385 -122.464677814993 (37.7790666413385, -122.464677814993)
Powered by Datasette · Query took 91.175ms · Data source: data.sfgov.org