sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
100775 107342 6 227 110 JULIAN AVE 1 13 1 1     100     6006340.8 2107214.1 37.7663669011591 -122.421312071366 (37.7663669011591, -122.421312071366)
118710 105850 6 47 44 MENDOSA AVE 1 9 1 1     100 6x15   5993395.1 2101192.7 37.7490953323683 -122.465650972372 (37.7490953323683, -122.465650972372)
106826 107037 6 3 1060 Clayton St 1 7 1 1     99     5998985.0 2106259.0 37.7633269800406 -122.446685590868 (37.7633269800406, -122.446685590868)
108351 106363 6 47 101 URBANO DR 1 7 1 1     80     5993535.8 2092458.1 37.7251204132224 -122.464530299025 (37.7251204132224, -122.464530299025)
98176 105497 6 47 3929 19TH ST 1 7 1 1     60     6003450.9 2104734.8 37.7593959875427 -122.431130714429 (37.7593959875427, -122.431130714429)
139589 109576 6 116 21X STILLINGS AVE 1 13 1 1     60     6000417.0 2095694.0 37.7343997262189 -122.44097481223999 (37.7343997262189, -122.44097481224)
90772 106612 6 138 1189 TENNESSEE ST   7 1 1     55     6015654.1 2103577.3 37.7569017014681 -122.388844893024 (37.7569017014681, -122.388844893024)
113606 111093 6 3 100x FONT BLVD 1 1 1 1   06/04/2015 12:00:00 AM 50 3x3 Permit Number 775594 5990916.0 2088996.0 37.715462969911 -122.473334188491 (37.715462969911, -122.473334188491)
142961 104761 6 277 1665 18TH AVE   7 1 1     50 9x9   5990543.2 2104073.0 37.756838968238 -122.475723071248 (37.756838968238, -122.475723071248)
144810 104762 6 277 1665 18TH AVE   7 1 1     50 9x9   5990543.2 2104073.0 37.756838968238 -122.475723071248 (37.756838968238, -122.475723071248)
105245 114225 6 60 99x FONT BLVD 1 2 1 1     48     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
108375 111357 6 3 600x MANSELL ST 1 8 1 2     48 3x3   6010142.0 2090267.0 37.720047423695505 -122.40696976451099 (37.7200474236955, -122.406969764511)
117755 107142 6 338 2694 MCALLISTER ST 2 7 1 1     48     5996297.4 2110789.6 37.7756129427938 -122.45630867288999 (37.7756129427938, -122.45630867289)
140312 115391 6 47 21X BELMONT AVE 1 7 1 1     48     5996611.0 2106266.0 37.7632103037359 -122.45489693849501 (37.7632103037359, -122.454896938495)
84668 116500 6 3 71X PARKRIDGE DR 1 3 1 1     45 3x3   5999012.0 2102131.0 37.751994056327 -122.446295237287 (37.751994056327, -122.446295237287)
112832 108978 6 3 1 MIGUEL ST 1 7 1 1     44     6003334.2 2097391.9 37.739227491928894 -122.431010244874 (37.7392274919289, -122.431010244874)
484 205880 6 47 44 Mendosa Ave 1 1 1 1     43 Width 3ft   5993348.04769 2101170.42115 37.7490314462559 -122.46581205990499 (37.7490314462559, -122.465812059905)
94007 112375 6 36 801 ULLOA ST 1 1 1 6     42     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
9657 114153 6 3 1200x JUNIPERO SERRA BLVD 12 7 1 1     40     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
79568 116501 6 3 71X PARKRIDGE DR 2 3 1 1     40 3x3   5999012.0 2102131.0 37.751994056327 -122.446295237287 (37.751994056327, -122.446295237287)
83189 104146 6 3 1710-1738 Diamond St 1 7 1 1     40     6001979.7 2099047.6 37.743696813668706 -122.43581192261101 (37.7436968136687, -122.435811922611)
94747 114034 6 53 198x FONT BLVD 1 1 1 1     40 3x3   5990818.0 2089012.0 37.7155012267577 -122.473674083302 (37.7155012267577, -122.473674083302)
106535 113163 6 116 1300X STANYAN ST 2 7 1 1     40 3x3   5997565.0 2104877.0 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349)
112251 113162 6 116 1300X STANYAN ST 1 7 1 1     40 3x3   5997565.0 2104877.0 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349)
141435 104808 6 277 1665 08th Ave   7 1 1     40     5993673.5 2104163.7 37.7572689897716 -122.46490400670099 (37.7572689897716, -122.464904006701)
3811 177743 6 2 401 Ocean Ave 4 9 1 6     37     5998700.41574 2091522.98281 37.722849171448395 -122.446609585371 (37.7228491714484, -122.446609585371)
105112 95242 6 3 2620 Larkin St   7 1 1     37   Permit Number 56959 6006630.0 2120172.0 37.801962421987 -122.421232011572 (37.801962421987, -122.421232011572)
83893 110583 6 100 46 COOK ST 5 1 1 1     36     5997534.0 2113434.0 37.782944683725 -122.45222184269899 (37.782944683725, -122.452221842699)
89406 114379 6 5 443X ARBALLO DR 1 7 1 1     36     5988110.0 2090275.0 37.718811899837206 -122.483126550771 (37.7188118998372, -122.483126550771)
101621 104406 6 3 290 Stonecrest Dr 1 13 1 1     36   Permit Number 770927 5990725.0 2092655.0 37.7254986161427 -122.474261202586 (37.7254986161427, -122.474261202586)
103031 120596 6 3 499x Ocean Ave 1 1 1 6     36 3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
105499 121242 6 3 701 16th Ave 1 16 1 1     36     5990933.0 2110561.0 37.7746758635803 -122.474848566269 (37.7746758635803, -122.474848566269)
123839 114250 6 60 131 FONT BLVD 1 7 1 1     36     5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
124990 107541 6 3 2 GARFIELD ST 4 13 1 1     36     5993976.6 2090624.3 37.7201106425596 -122.46287353180901 (37.7201106425596, -122.462873531809)
125238 105422 6 3 5827 DIAMOND HEIGHTS BLVD 1 7 1 1     36     6000844.1 2096795.2 37.7374476811542 -122.439577108095 (37.7374476811542, -122.439577108095)
128022 121414 6 3 150 Raccoon Dr 1 16 1 1     36 3x3   5998776.0 2103987.0 37.7570766935068 -122.44724492231701 (37.7570766935068, -122.447244922317)
144388 114393 6 253 118x TAPIA DR 1 7 1 1     36     5988638.0 2090878.0 37.72049829773871 -122.48134562114099 (37.7204982977387, -122.481345621141)
87085 113937 6 3 800 EL CAMINO DEL MAR 1 7 1 1     35     5985966.0 2115003.0 37.7865832348262 -122.49235734524099 (37.7865832348262, -122.492357345241)
96972 120593 6 2 499x Ocean Ave 4 1 1 6     34 3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
3803 178335 6 3 401 Ocean Ave 1 9 1 6     33 Width 8ft   5998656.04486 2091523.1214700001 37.72284701755029 -122.44676297552601 (37.7228470175503, -122.446762975526)
9641 114157 6 3 1200x JUNIPERO SERRA BLVD 18 7 1 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9651 114156 6 3 1200x JUNIPERO SERRA BLVD 17 7 1 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
11071 113042 6 62 500 Raymond Ave 1 8 1 1   10/06/2015 12:00:00 AM 30 3x3   6008233.879509999 2088473.9314700002 37.715017072864796 -122.413438766187 (37.7150170728648, -122.413438766187)
44089 109772 6 211 2200x SAN JOSE AVE 11 1 1 1     30 3x3   5998886.0 2091075.0 37.7216297132481 -122.44593585753599 (37.7216297132481, -122.445935857536)
80719 116576 6 40 2500x OCEAN AVE 1 9 1 6 4   30 10X10   5991377.0 2094742.0 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256)
82925 112725 6 47 40x BERNAL HEIGHTS BLVD 1 1 1 1     30 3x3   6009324.0 2098099.0 37.7415066181332 -122.41035003366801 (37.7415066181332, -122.410350033668)
88665 109838 6 143 200x MONTCALM ST 1 1 1 1     30 3x3   6009924.0 2099647.0 37.745790704819704 -122.408384592716 (37.7457907048197, -122.408384592716)
96939 113833 6 43 932 SHOTWELL ST 1 1 1 1     30     6007966.0 2102301.0 37.752968150444204 -122.415342945464 (37.7529681504442, -122.415342945464)
97021 106360 6 116 1820 POST ST 1 7 1 1     30     6003351.1 2114201.6 37.785383838011 -122.43215193232099 (37.785383838011, -122.432151932321)
98560 114194 6 11 555x SAN JOSE AVE 2 7 1 1   11/23/2015 12:00:00 AM 30 3x3 Permit Number 777057 6006305.0 2100249.0 37.747240333103 -122.420941331562 (37.747240333103, -122.420941331562)
102075 109040 6 19 654 Precita Ave   7 1 1     30     6009911.5 2100416.7 37.7479034320272 -122.408482100152 (37.7479034320272, -122.408482100152)
105010 114230 6 140 99x FONT BLVD 6 2 1 1     30     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
106195 116091 6 86 300x EXECUTIVE PARK BLVD 1 1 1 1     30 3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
109984 116585 6 19 2100 22ND ST 1 1 1 1     30 3x3   6011843.0 2103815.0 37.757342401329105 -122.402041888427 (37.7573424013291, -122.402041888427)
115263 97894 6 17 2927 Folsom St   7 1 1   02/29/2012 12:00:00 AM 30   Permit Number 768566 6008395.0 2101384.0 37.7504743768844 -122.413794517972 (37.7504743768844, -122.413794517972)
121718 107408 6 183 10 PEMBERTON PL 1 7 1 1     30     5998956.5 2104566.5 37.7586781689727 -122.446662380642 (37.7586781689727, -122.446662380642)
125242 111094 6 3 150x FONT BLVD   1 1 1   06/04/2015 12:00:00 AM 30 3x3 Permit Number 775594 5990976.0 2089133.0 37.715842612516106 -122.473136789074 (37.7158426125161, -122.473136789074)
125828 112726 6 47 40x BERNAL HEIGHTS BLVD 2 1 1 1     30 3x3   6009324.0 2098099.0 37.7415066181332 -122.41035003366801 (37.7415066181332, -122.410350033668)
125999 106361 6 116 1645 WEBSTER ST 2 7 1 1     30     6003301.2 2114333.7 37.7857437219688 -122.432334009178 (37.7857437219688, -122.432334009178)
126456 116577 6 98 3000x 19TH AVE 1 5 1 6 4   30 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
129097 101041 6 17 3750 18th St 1 7 1 4   03/15/2012 12:00:00 AM 30   Permit Number 769376 6005230.0 2105481.0 37.761545532196706 -122.42503080268699 (37.7615455321967, -122.425030802687)
138293 102019 6 50 3028 Market St 1 7 1 1     30 4x14   6000376.7 2105451.5 37.7611891846044 -122.44181421161001 (37.7611891846044, -122.44181421161)
142848 108144 6 3 140x TOPAZ WAY 2 7 1 1     30   Permit Number 775551 6001767.0 2098265.0 37.741535893008106 -122.436491384585 (37.7415358930081, -122.436491384585)
3799 178336 6 3 401 Ocean Ave 2 9 1 6     29 Width 8ft   5998664.9682 2091522.93582 37.722847017548204 -122.44673211618999 (37.7228470175482, -122.44673211619)
3818 178337 6 3 401 Ocean Ave 3 9 1 6     29     5998676.28102 2091524.0079700002 37.7228506076618 -122.44669308741301 (37.7228506076618, -122.446693087413)
77671 107413 6 231 276 Yerba Buena Ave 1 7 1 1     28     5995080.66446 2095640.15746 37.733946507354396 -122.459420244296 (37.7339465073544, -122.459420244296)
99779 114394 6 253 134x TAPIA DR 1 7 1 1     28     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
101535 116502 6 3 71X PARKRIDGE DR 3 3 1 1     28 3x3   5999012.0 2102131.0 37.751994056327 -122.446295237287 (37.751994056327, -122.446295237287)
125158 116956 6 143 380 SAN JOSE AVE 1 8 1 1     28 3x3   6006172.0 2100967.0 37.7492042995658 -122.421452219126 (37.7492042995658, -122.421452219126)
125954 114239 6 140 1300x JUNIPERO SERRA BLVD 1 2 1 1     28     5991168.0 2088425.0 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074)
95808 95230 6 3 1@Carl Irving St 6 7 1 1   11/16/2010 12:00:00 AM 27     5995817.2 2106753.3 37.7645027364821 -122.45767767256001 (37.7645027364821, -122.45767767256)
87470 102106 6 116 50X Noe St 8 7 1 1   12/19/2012 12:00:00 AM 25   Permit Number 769282 6002816.1 2107996.5 37.7683158318555 -122.433559261751 (37.7683158318555, -122.433559261751)
115088 117438 6 19 230 AMBER DR 1 5 1 1     25 3X3   5999593.0 2099199.0 37.7439766577846 -122.444075405191 (37.7439766577846, -122.444075405191)
120773 115697 6 60 1425x LAGUNA ST 1 7 1 1     25     6004559.0 2113815.0 37.7843907406582 -122.4279454018 (37.7843907406582, -122.4279454018)
171221 112905 6 5 2401 Keith St 1 7 1 1     25     6014331.87009 2092225.76664 37.725659374776605 -122.39262364628901 (37.7256593747766, -122.392623646289)
88441 114094 6 55 239x VIDAL DR 1 7 1 1     24     5987668.0 2090475.0 37.7193353179991 -122.484669012602 (37.7193353179991, -122.484669012602)
94649 112577 6 21 3326 23RD ST 2 1 1 1     24   Permit Number 775776 6006851.0 2102663.4 37.753900487576296 -122.419224541208 (37.7539004875763, -122.419224541208)
101747 113695 6 5 907 FLORIDA ST 1 1 1 1     24 3x3   6009441.0 2103786.0 37.7571284172194 -122.41034693748101 (37.7571284172194, -122.410346937481)
107199 112376 6 36 801 ULLOA ST 2 1 1 6     24     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
112205 114404 6 203 500X ARBALLO DR 1 1 1 1     24 3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
116329 112363 6 304 540 10th Ave 3 7 1 1     24 6x6   5992860.82014 2111778.58973 37.778130563709 -122.468268503132 (37.778130563709, -122.468268503132)
2003 127110 6 32 3201 Laguna St 1 9 1 1     23 Width 6ft   6003718.35126 2119752.0994 37.8006449063974 -122.431277695812 (37.8006449063974, -122.431277695812)
42991 105168 6 60 4755X 03RD ST 2 8 1 19     23 3x3 Permit Number 770204 6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
106566 108177 6 3 201 PANORAMA DR 1 7 1 1     22 3x3   5997273.1 2100946.6 37.7486425219839 -122.452223122411 (37.7486425219839, -122.452223122411)
110973 106962 6 47 218 SADOWA ST 3 5 1 1     22     5994814.0 2087793.9 37.7123872323548 -122.459774032106 (37.7123872323548, -122.459774032106)
139478 114236 6 140 99x FONT BLVD 12 2 1 1     22     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
4549 226945 6 19 998 Chenery St 4 9 1 1     21 Width 1ft   6001140.61217 2096125.6115299999 37.735626018710896 -122.438503967885 (37.7356260187109, -122.438503967885)
50166 95953 6 17 499 Buena Vista East Ave   7 1 1   03/18/2011 12:00:00 AM 21   Permit Number 57015 6000177.0 2107098.0 37.7656986843565 -122.442623109531 (37.7656986843565, -122.442623109531)
5478 121205 6 234 930 Chestnut St 1 7 1 1     20 3x3   6007386.5238 2120591.4348299997 37.8031567047665 -122.418643837145 (37.8031567047665, -122.418643837145)
9677 114154 6 5 1200x JUNIPERO SERRA BLVD 13 7 1 1     20     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9948 114067 6 62 6 Higuera Ave 1 8 1 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
11055 116459 6 267 777 Brotherhood Way 2 2 1 1     20 10x20 Permit Number 777772 5989848.42836 2088633.8329099999 37.7144066723949 -122.476997704287 (37.7144066723949, -122.476997704287)
18877 82435 6 3 51 Peralta Ave 1 7 1 1   04/02/2005 12:00:00 AM 20     6010636.52703341 2100363.58782589 37.7477981742678 -122.405971235802 (37.7477981742678, -122.405971235802)
49231 114226 6 140 99x FONT BLVD 2 2 1 1     20     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
80662 110904 6 17 203 CORBETT AVE 1 7 1 1     20 3x3   6000094.0 2105620.0 37.7616357315689 -122.442804047122 (37.7616357315689, -122.442804047122)
81797 115888 6 41 811 TREAT AVE 1 8 1 1     20 3x3   6008597.0 2103712.0 37.7568778816719 -122.413260590978 (37.7568778816719, -122.413260590978)
83367 115940 6 41 3401x 17TH ST 1 1 1 18     20 3x3   6006069.0 2106010.0 37.7630453994978 -122.42216662533801 (37.7630453994978, -122.422166625338)
84223 108244 6 46 150 Conrad St 1 16 1 1     20     6001768.8 2096480.0 37.7366348009068 -122.43635744032801 (37.7366348009068, -122.436357440328)
102666 121415 6 75 366 San Carlos St 1 1 1 1     20 3x3   6006692.0 2103986.0 37.757523086513096 -122.419868246156 (37.7575230865131, -122.419868246156)
113595 114068 6 62 8 HIGUERA AVE 1 7 1 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
119513 121133 6 3 1050 North Point St 1 7 1 1     20 3x10   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
Powered by Datasette · Query took 11.83ms · Data source: data.sfgov.org