sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
52437 232289 2 1 0 San Jose Av Off Ramp 4 7 1 1     16 Width 9ft   6002953.30911 2095259.2744599998 37.7333502006365 -122.43217493415301 (37.7333502006365, -122.432174934153)
36763 194034 2 1 1 24th St 18 23 1 1     25     6017329.2954 2102592.85695 37.754291333594395 -122.382982871671 (37.7542913335944, -122.382982871671)
162377 194033 2 1 1 24th St 9 23 1 1     18     6017162.02159 2102667.2446 37.7544863425722 -122.383566530788 (37.7544863425722, -122.383566530788)
158947 194032 2 1 1 25th St 9 23 1 1     4     6015018.29801 2102168.6663599997 37.7529986327902 -122.39094530450599 (37.7529986327902, -122.390945304506)
32406 194091 2 1 1 Apparel Way 3 9 1 1     18     6011263.07589 2097812.25269 37.7408277801759 -122.403625166174 (37.7408277801759, -122.403625166174)
49273 194089 2 1 1 Apparel Way 1 9 1 1     13     6011234.191000001 2097831.41118 37.740878771736 -122.403726387581 (37.740878771736, -122.403726387581)
180143 194090 2 1 1 Apparel Way 2 9 1 1     14     6011245.93679 2097821.82718 37.740853112271 -122.403685100604 (37.740853112271, -122.403685100604)
177134 246704 2 1 1 Bonview St 10 2 1 1     8     6007707.12573 2099125.1145 37.7442333302171 -122.416013295873 (37.7442333302171, -122.416013295873)
883 251306 2 1 1 Cashmere St 5 13 1 1       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
885 251305 2 1 1 Cashmere St 4 13 1 1       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
891 251304 2 1 1 Cashmere St 3 13 1 1 5     3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
188301 232288 2 1 1 Day St 1 1 1 1     14 Width 3ft   6005609.575130001 2098736.17342 37.7430472314506 -122.423238540044 (37.7430472314506, -122.423238540044)
95589 119627 2 1 1 El Sereno Ct 1 1 1 1       3x3   5999504.0 2097253.0 37.738628328633396 -122.44424333392901 (37.7386283286334, -122.444243333929)
148347 194063 2 1 1 Flower St 2 9 1 1     19 Width 4ft   6010838.1657 2098339.02807 37.7422504473898 -122.40513143798599 (37.7422504473898, -122.405131437986)
107126 85498 1 1 1 Nebraska St 1 1 1 1           6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
119719 85507 1 1 1 Nebraska St 1 9 1 1         Permit Number 49678 6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
34540 177827 2 1 10 Brotherhood Way 5 4 1 1     22 Width 0ft   5993584.63921 2087685.0546799998 37.712017594599295 -122.46401514608 (37.7120175945993, -122.46401514608)
70361 177828 2 1 10 Brotherhood Way 6 4 1 1     20 Width 0ft   5993567.2586900005 2087687.58972 37.712023553524205 -122.464075401566 (37.7120235535242, -122.464075401566)
166693 194049 2 1 100 Hampshire St 6 7 1 1     8     6009981.034030001 2107543.0973799997 37.76747481202629 -122.40874433479999 (37.7674748120263, -122.4087443348)
11842 19713 3 1 100 STAIRWAY13 11 1 1 2     6 40ST            
12182 19712 3 1 100 STAIRWAY13 10 1 1 2     6 40ST            
14544 19711 3 1 100 STAIRWAY13 9 1 1 2     6 40ST            
11201 19747 3 1 100 STAIRWAY15 3 1 1 2     3 10ST            
14337 19746 3 1 100 STAIRWAY15 2 1 1 2     3 3X3            
16592 19752 3 1 100 STAIRWAY15 10 1 1 2     6 10ST            
13008 19766 3 1 100 STAIRWAY16 5 1 1 2     6 30ST            
15820 19764 3 1 100 STAIRWAY16 3 1 1 2     6 30ST            
136262 177829 2 1 100 Trumbull St 1 1 1 1     26 Width 4ft   6003826.80299 2094267.18245 37.7306756258798 -122.429084311385 (37.7306756258798, -122.429084311385)
137153 177830 2 1 100 Trumbull St 2 1 1 1     31 Width 3ft   6003869.42584 2094268.83295 37.7306825704475 -122.42893707528201 (37.7306825704475, -122.428937075282)
161127 177831 2 1 100 Trumbull St 4 1 1 1     33 Width 3ft   6003962.8397 2094273.86284 37.730701668441895 -122.428614487595 (37.7307016684419, -122.428614487595)
109844 105371 2 1 100 WESTGATE DR 1 1 1 1     24 3x3   5993373.5 2093728.3 37.7285987139119 -122.465183566455 (37.7285987139119, -122.465183566455)
867 5563 3 1 1000 Dolores St 1 1 1 2     35 3   6005047.93676 2102495.8008 37.753338590028 -122.42544803402399 (37.753338590028, -122.425448034024)
17849 26939 3 1 1000 Dolores St 3 1 1 2     35 3   6005048.52765 2102486.42553 37.7533128811044 -122.42544532345501 (37.7533128811044, -122.425445323455)
168273 232298 2 1 1000 Dolores St 10 1 1 1     12 Width 2ft   6005049.6768 2102466.11465 37.7532571770826 -122.425439904132 (37.7532571770826, -122.425439904132)
74822 194102 2 1 1000 Oakdale Ave 7 9 1 1     9     6018083.18788 2093260.00153 37.7287068084484 -122.379727324058 (37.7287068084484, -122.379727324058)
12286 97316 1 1 1000 Taraval St 1 1 1 1     16 3x3   5990092.4633 2099074.5321 37.7430883471851 -122.47691665284201 (37.7430883471851, -122.476916652842)
20958 3909 3 1 1000X 14th St 2 1 1 2     12 3X3   6002142.832230001 2107666.80115 37.7673723370035 -122.43586443430901 (37.7673723370035, -122.435864434309)
78781 121184 6 1 1000x Duncan St 5 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
79242 121190 6 1 1000x Duncan St 11 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
80352 121187 6 1 1000x Duncan St 8 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
89056 121188 6 1 1000x Duncan St 9 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
90930 121191 6 1 1000x Duncan St 12 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
91506 121193 6 1 1000x Duncan St 14 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
95270 121186 6 1 1000x Duncan St 7 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
100978 121192 6 1 1000x Duncan St 13 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
102605 121181 6 1 1000x Duncan St 2 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
104617 121185 6 1 1000x Duncan St 6 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
104788 121183 6 1 1000x Duncan St 4 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
123005 121182 6 1 1000x Duncan St 3 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
18158 96243 2 1 100X 27th St 2 1 1 1     18 3x3   6005866.5 2100251.5 37.7472224703829 -122.42245781101299 (37.7472224703829, -122.422457811013)
91357 49091 1 1 101 Athens St 2 1 1 1         Permit Number 46240 6005012.04174128 2092633.4383737 37.7262567475706 -122.424870568097 (37.7262567475706, -122.424870568097)
113123 49092 1 1 101 Athens St 3 1 1 1         Permit Number 46240 6005012.04174128 2092633.4383737 37.7262567475706 -122.424870568097 (37.7262567475706, -122.424870568097)
108771 114774 2 1 101 FREDERICK ST 1 1 1 1   03/23/2016 12:00:00 AM 3 3x3   5999527.0 2107685.0 37.7672733650738 -122.444913510993 (37.7672733650738, -122.444913510993)
114117 114775 2 1 101 FREDERICK ST 2 1 1 1     30 3x3   5999527.0 2107685.0 37.7672733650738 -122.444913510993 (37.7672733650738, -122.444913510993)
123166 105073 6 1 101 LUNDYS LN 1 8 1 1     18     6006875.0 2098969.0 37.7437578546964 -122.41887954343599 (37.7437578546964, -122.418879543436)
133646 194053 2 1 101 Patterson St 3 2 1 1     16 Width 5ft   6010891.45102 2098447.80375 37.7425521007081 -122.40495484979999 (37.7425521007081, -122.4049548498)
137102 194052 2 1 101 Patterson St 2 2 1 1     19 Width 5ft   6010878.398080001 2098425.29219 37.7424895591595 -122.404998398575 (37.7424895591595, -122.404998398575)
183762 232287 2 1 101 Webster St 1 4 1 1     18 Width 3ft   6004240.14437 2109135.1756700003 37.7715230535659 -122.42871480966801 (37.7715230535659, -122.428714809668)
158968 232309 2 1 1012 Shrader St 1 1 1 1     20 Width 3ft   5997674.44536 2107027.2087 37.7653613359944 -122.45127375459101 (37.7653613359944, -122.451273754591)
187126 142895 2 1 1015 DIVISADERO ST 1 1 1 1     26 Width 0ft   6000919.8741 2115393.3679 37.788517982728294 -122.440648735369 (37.7885179827283, -122.440648735369)
1011 232310 1 1 1018 Shrader St 1 1 1 1   08/18/2016 12:00:00 AM 26 Width 3ft Permit Number 17854 5997696.0 2107004.0 37.7652988449505 -122.451197528579 (37.7652988449505, -122.451197528579)
87521 58634 1 1 1018 Shrader St 1 1 1 1   08/18/2016 12:00:00 AM 3 4x4 Permit Number 17854 5997674.48741574 2107055.11858465 37.765437971850794 -122.45127562216999 (37.7654379718508, -122.45127562217)
92497 99770 2 1 1025x Douglass St 1 1 1 1       3x3 595 Clipper St is true property address 6001337.9 2100792.7 37.7484519666196 -122.438156093062 (37.7484519666196, -122.438156093062)
11179 97318 1 1 1026 Taraval St 1 1 1 1     15 3x3   5989977.5691 2099069.2019 37.7430670461122 -122.477313532312 (37.7430670461122, -122.477313532312)
25950 232321 2 1 1027 Douglass St 2 1 1 1     7 Width 2ft   6001337.57778 2100767.91475 37.7483838939011 -122.43815543204201 (37.7483838939011, -122.438155432042)
164341 232320 2 1 1027 Douglass St 1 1 1 1     17 Width 3ft   6001339.44236 2100715.1600200003 37.74823914801971 -122.438145205836 (37.7482391480197, -122.438145205836)
113873 61358 1 1 1029 Douglass St 1 1 1 1   03/14/1984 12:00:00 AM     Permit Number 21266 6001344.49519126 2100781.43952904 37.7484214231354 -122.438132480542 (37.7484214231354, -122.438132480542)
153525 232319 2 1 1029 Douglass St 1 1 1 1     16 Width 3ft   6001340.20421 2100694.82389 37.748183353177 -122.438141114822 (37.748183353177, -122.438141114822)
40576 177849 2 1 104 Woolsey St 1 17 1 1     21     6011561.92381 2092191.20992 37.7254102643617 -122.40219675676799 (37.7254102643617, -122.402196756768)
154276 182080 2 1 1041 Taraval St 1 1 1 1     12 Width 0ft   5989949.2263 2099002.1098 37.7428811840861 -122.477406630563 (37.7428811840861, -122.477406630563)
141137 101256 2 1 1049 Irving St 1 1 1 1   09/08/2015 12:00:00 AM   3x3   5992548.0 2106581.0 37.763841302397104 -122.46897230376699 (37.7638413023971, -122.468972303767)
142212 101257 2 1 1049 Irving St 2 1 1 1       3x3   5992548.0 2106581.0 37.763841302397104 -122.46897230376699 (37.7638413023971, -122.468972303767)
160287 248281 2 1 105 Lundy's Ln 2 9 1 1     20 Width 5ft   6006851.95643 2098931.00797 37.7436522395523 -122.418956528726 (37.7436522395523, -122.418956528726)
47816 210501 2 1 105 Upland Dr 1 1 1 1     11 Width 3ft   5993140.2263400005 2094328.28998 37.73023268367729 -122.46603358088899 (37.7302326836773, -122.466033580889)
73143 210502 2 1 105 Upland Dr 7 1 1 1     7 Width 3ft   5993378.93248 2094262.38115 37.7300654826285 -122.46520356329201 (37.7300654826285, -122.465203563292)
16910 7017 3 1 1055 Fell St 2 1 1 2     18 3X3   6002366.0432 2110180.0215 37.774285696400206 -122.435272167554 (37.7742856964002, -122.435272167554)
11098 64696 1 1 1055 Taraval St 1 1 1 1   10/13/1988 12:00:00 AM 6 3x3 Permit Number 25639 5989879.8498 2099000.4177 37.742872512219 -122.47764638889299 (37.742872512219, -122.477646388893)
158794 97321 1 1 1055 Taraval St 2 1 1 1   10/13/1988 12:00:00 AM 9 3x3   5989897.1093 2098999.7408 37.7428716552125 -122.477586661544 (37.7428716552125, -122.477586661544)
99055 98374 2 1 106 De Soto St 1 9 1 1           5993231.0 2091825.0 37.7233644995117 -122.465537980019 (37.7233644995117, -122.465537980019)
105502 98375 2 1 106 De Soto St 2 9 1 1           5993231.0 2091825.0 37.7233644995117 -122.465537980019 (37.7233644995117, -122.465537980019)
23093 26475 3 1 106 Gold Mine Dr 1 1 1 2     19 3X3   6001338.90016 2098832.9571 37.7430710337942 -122.438012277952 (37.7430710337942, -122.438012277952)
30894 200231 2 1 1079 Ingerson Ave 5 19 1 1     5 Width 0ft   6013732.1076 2090145.865 37.719915054156296 -122.39455141525299 (37.7199150541563, -122.394551415253)
138059 200229 2 1 1079 Ingerson Ave 3 19 1 1     4 Width 0ft   6013701.2545 2090170.6816 37.719981480300795 -122.39465980145201 (37.7199814803008, -122.394659801452)
154193 232299 2 1 108 Valley St 1 1 1 1     26 Width 4ft   6005119.98151 2099339.98705 37.7446775233394 -122.424974374591 (37.7446775233394, -122.424974374591)
25169 232371 2 1 109 Frederick St 3 1 1 1     8 Width 3ft   5999451.75369 2107695.0323799998 37.767296616782396 -122.44517449760001 (37.7672966167824, -122.4451744976)
92138 101902 1 1 1100 Ocean Ave 3 7 1 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
27451 232290 2 1 1100 San Jose Ave 34 9 1 1     7 Width 9ft   6004782.10663 2096684.4357 37.737366892177704 -122.425953683239 (37.7373668921777, -122.425953683239)
163978 232291 2 1 1100 San Jose Ave 35 9 1 1     9 Width 9ft   6004778.102000001 2096680.6709599998 37.737356328728104 -122.42596726120001 (37.7373563287281, -122.4259672612)
9880 3771 3 1 1100X Carolina St 1 11 1 2     18 18   6012538.0 2102781.0 37.75454202913279 -122.39956569430599 (37.7545420291328, -122.399565694306)
147673 194031 2 1 1101 25th St 7 2 1 1     22 Width 9ft   6015324.74216 2102030.33526 37.7526358040022 -122.38987589096901 (37.7526358040022, -122.389875890969)
163213 131758 2 1 1109 Jones St 4 1 1 1     12 Width 4ft   6008573.70037 2116368.91585 37.791629479864795 -122.414236639307 (37.7916294798648, -122.414236639307)
10258 173932 2 1 1109x Alemany Blvd   1 1 1       3x3   6003491.0 2094313.0 37.7307824159859 -122.430248501015 (37.7307824159859, -122.430248501015)
10036 64803 1 1 110X VALLEY ST 1 1 1 1 1 01/24/2017 12:00:00 AM 3   Permit Number 779438 6005124.0 2099350.0 37.7447052436017 -122.424961191686 (37.7447052436017, -122.424961191686)
159088 245127 2 1 112 Lyon St 1 1 1 1     10 Width 0ft   6000343.614 2109412.9845 37.772064548609706 -122.442213026376 (37.7720645486097, -122.442213026376)
72039 182081 2 1 1123 Taraval St 1 1 1 1     12 Width 0ft   5989680.5886 2098998.5521 37.742855824264204 -122.47833523450899 (37.7428558242642, -122.478335234509)
127843 97325 1 1 1123 Taraval St 1 1 1 1   10/04/2007 12:00:00 AM 15 3x3   5989733.4 2098972.0 37.7427859847726 -122.478150688587 (37.7427859847726, -122.478150688587)
123302 182084 2 1 1143 Taraval St 1 1 1 1     15 Width 0ft   5989609.7892 2098992.9724 37.7428363935584 -122.478579628348 (37.7428363935584, -122.478579628348)
88219 2210 3 1 1145 Broderick St 1 1 1 2     18 3X3   6000813.81573 2112576.3555400004 37.7807771513392 -122.44081352531 (37.7807771513392, -122.44081352531)
147756 124340 2 1 115 Palm Ave 2 1 1 1     7 Width 4ft   5995872.99304 2113646.8815099997 37.7834339079411 -122.457983613293 (37.7834339079411, -122.457983613293)
78648 112011 2 1 115 Red Rock Way   9 1 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
80283 112014 2 1 115 Red Rock Way   9 1 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
Powered by Datasette · Query took 28.355ms · Data source: data.sfgov.org