sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5325 40088 1 84   1 1 1 1   03/09/1999 12:00:00 AM     Permit Number 41311          
5746 31847 1 16   2 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
7293 31848 1 16   3 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
9510 46857 1 16   1 1 1 1   04/25/2002 12:00:00 AM     Permit Number 44926          
11795 31846 1 16   1 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
11986 31849 1 35   1 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
13223 33083 1 16   2 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
14881 33084 1 16   1 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
15875 31850 1 35   2 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
15956 31845 1 35   3 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
3013 39333 1 35 0 21st St 3 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
5518 39334 1 35 0 21st St 4 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
6740 39332 1 35 0 21st St 2 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
14197 39331 1 35 0 21st St 5 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
168210 218135 2 18 0 Noriega St 1 2 1 1     3 Width 0ft   5992409.03176 2103467.31015 37.7552838973381 -122.469226308173 (37.7552838973381, -122.469226308173)
29380 196093 2 16 1 01st St 25 23 1 1     8     6014406.1146599995 2105887.9731 37.763177058994 -122.39332261913601 (37.763177058994, -122.393322619136)
132015 196092 2 16 1 01st St 24 23 1 1     10     6014425.82588 2105887.0502299997 37.7631756200823 -122.393254379501 (37.7631756200823, -122.393254379501)
152443 196094 2 16 1 01st St 26 23 1 1     8     6014400.8809 2105882.83985 37.7631626734333 -122.393340361863 (37.7631626734333, -122.393340361863)
131128 123933 2 16 1 08th Ave 2 2 1 1     11     5993312.90228 2114946.82765 37.7868557832667 -122.466934987319 (37.7868557832667, -122.466934987319)
149532 123932 2 16 1 08th Ave 1 2 1 1     12     5993304.79465 2114951.8615900003 37.7868691371328 -122.46696340370801 (37.7868691371328, -122.466963403708)
30029 196074 2 16 1 25th St 7 23 1 1     8     6014974.36324 2102149.68411 37.7529440736099 -122.391095913948 (37.7529440736099, -122.391095913948)
33649 196072 2 16 1 25th St 4 23 1 1     6     6014990.91174 2102121.65719 37.7528680359305 -122.391036726872 (37.7528680359305, -122.391036726872)
66873 196280 2 16 1 25th St 11 23 1 1     12     6015022.69172 2102195.1938 37.7530717153135 -122.39093196394501 (37.7530717153135, -122.390931963945)
74692 196073 2 16 1 25th St 5 23 1 1     9     6014983.580569999 2102134.9117099997 37.752904023218605 -122.391063005979 (37.7529040232186, -122.391063005979)
130300 196281 2 16 1 25th St 12 23 1 1     12     6015018.372359999 2102200.19302 37.7530852024401 -122.39094725063102 (37.7530852024401, -122.390947250631)
130498 196075 2 16 1 25th St 17 23 1 1     6     6014963.469190001 2102214.24517 37.753120740043705 -122.391138100256 (37.7531207400437, -122.391138100256)
132022 196279 2 16 1 25th St 6 23 1 1     5     6014984.46572 2102135.07494 37.7529045205317 -122.39105995634701 (37.7529045205317, -122.391059956347)
133863 196076 2 16 1 25th St 18 23 1 1     6     6014971.87416 2102223.03647 37.753145345506795 -122.39110964840401 (37.7531453455068, -122.391109648404)
137606 196282 2 16 1 25th St 13 23 1 1     12     6015015.25562 2102205.64875 37.75310000977571 -122.39095841029499 (37.7531000097757, -122.390958410295)
151585 196077 2 16 1 25th St 19 23 1 1     6     6014960.28506 2102234.79181 37.7531769800583 -122.391150547759 (37.7531769800583, -122.391150547759)
27679 234916 2 84 1 Albion St 5 1 1 1     5 Width 2ft   6005792.88209 2107221.84485 37.766357260514 -122.423207770616 (37.766357260514, -122.423207770616)
76634 237056 2 18 1 Albion St 3 1 1 1     9 Width 2ft   6005793.31637 2107190.9812 37.7662725407724 -122.423204074428 (37.7662725407724, -122.423204074428)
151398 237057 2 18 1 Albion St 4 1 1 1     8 Width 2ft   6005792.84324 2107206.9501900002 37.766316361124204 -122.423206846131 (37.7663163611242, -122.423206846131)
177339 237055 2 18 1 Albion St 2 1 1 1     7 Width 2ft   6005794.81287 2107159.8300900003 37.7661870916781 -122.42319668379601 (37.7661870916781, -122.423196683796)
188326 237054 2 18 1 Albion St 1 1 1 1     7 Width 2ft   6005797.6398599995 2107141.4188 37.766136698186706 -122.423185596933 (37.7661366981867, -122.423185596933)
89563 84122 1 16 1 Alpha St 3 1 1 1   06/05/2008 12:00:00 AM   3x3 Permit Number 50683 6011538.02534932 2088764.33012973 37.715999417407495 -122.402038569068 (37.7159994174075, -122.402038569068)
110550 84281 1 16 1 Alpha St 2 1 1 1   06/05/2008 12:00:00 AM   3x3 Permit Number 50683 6011538.02534932 2088764.33012973 37.715999417407495 -122.402038569068 (37.7159994174075, -122.402038569068)
122516 84282 1 16 1 Alpha St 1 1 1 1   06/05/2008 12:00:00 AM   3x3 Permit Number 50683 6011538.02534932 2088764.33012973 37.715999417407495 -122.402038569068 (37.7159994174075, -122.402038569068)
59649 236881 2 16 1 Ashbury Ter 2 1 1 1     4 Width 3ft   5999527.40106 2106977.39106 37.7653304712372 -122.44486125295099 (37.7653304712372, -122.444861252951)
42481 71284 2 16 1 Atalaya Ter 1 1 1 1 1 11/07/1981 12:00:00 AM 5     5998802.9816 2111041.8064 37.7764489521659 -122.447659448254 (37.7764489521659, -122.447659448254)
80000 35936 1 16 1 Bache St 3 1 1 1   04/24/1998 12:00:00 AM     Permit Number 39099 6007238.86373216 2095730.63225463 37.7348864958229 -122.41739193639299 (37.7348864958229, -122.417391936393)
103105 35935 1 16 1 Bache St 2 1 1 1   04/24/1998 12:00:00 AM     Permit Number 39099 6007238.86373216 2095730.63225463 37.7348864958229 -122.41739193639299 (37.7348864958229, -122.417391936393)
117049 35934 1 16 1 Bache St 1 1 1 1   04/24/1998 12:00:00 AM     Permit Number 39099 6007238.86373216 2095730.63225463 37.7348864958229 -122.41739193639299 (37.7348864958229, -122.417391936393)
68818 217865 2 16 1 Belmont Ave 4 1 1 1     7 Width 4ft   5996682.74655 2106173.09082 37.7629593142538 -122.45464207989401 (37.7629593142538, -122.454642079894)
146573 217864 2 16 1 Belmont Ave 5 1 1 1     8 Width 4ft   5996697.2006 2106163.46533 37.7629337141391 -122.454591393188 (37.7629337141391, -122.454591393188)
152247 217866 2 16 1 Belmont Ave 2 1 1 1     6 Width 4ft   5996652.66876 2106194.7988299998 37.7630171937018 -122.454747676471 (37.7630171937018, -122.454747676471)
159244 217867 2 16 1 Belmont Ave 1 1 1 1     2 Width 4ft   5996638.61304 2106204.01086 37.763041681342 -122.45479695573299 (37.763041681342, -122.454796955733)
38826 237101 2 18 1 Dearborn St 2 1 1 1     5 Width 3ft   6005826.7194 2106021.63498 37.7630636778686 -122.423005419568 (37.7630636778686, -122.423005419568)
42225 237100 2 18 1 Dearborn St 1 1 1 1     12 Width 3ft   6005826.477630001 2105998.8251400003 37.7630010337862 -122.42300463446101 (37.7630010337862, -122.423004634461)
49810 241024 2 198 1 Gold Mine Dr 1 1 1 1     15 Width 3ft   6001778.75794 2099104.0320099997 37.7438403462637 -122.436510768958 (37.7438403462637, -122.436510768958)
130419 241025 2 198 1 Gold Mine Dr 2 1 1 1     13 Width 3ft   6001786.88467 2099119.61673 37.74388360003871 -122.43648378390199 (37.7438836000387, -122.436483783902)
38273 202293 2 16 1 Issleib Ave 3 2 1 1     5 Width 2ft   6012754.8343 2093244.37958 37.7283685671459 -122.39814680025499 (37.7283685671459, -122.398146800255)
73712 202295 2 16 1 Issleib Ave 5 2 1 1     5 Width 2ft   6012780.58541 2093228.85419 37.7283273718953 -122.398056688169 (37.7283273718953, -122.398056688169)
132706 202294 2 16 1 Issleib Ave 4 2 1 1     4 Width 2ft   6012769.019119999 2093237.37262 37.7283501175462 -122.398097270977 (37.7283501175462, -122.398097270977)
147991 202291 2 16 1 Issleib Ave 1 2 1 1     5 Width 2ft   6012719.32075 2093257.8431 37.728403557061895 -122.398270517286 (37.7284035570619, -122.398270517286)
34763 196288 2 16 1 Jack Balestreri Way 19 7 1 1     5     6012383.755890001 2104753.48944 37.7599494533344 -122.40023764215799 (37.7599494533344, -122.400237642158)
35147 196292 2 16 1 Jack Balestreri Way 25 7 1 1     3     6012388.17486 2104794.0427599996 37.760061050199596 -122.400225207229 (37.7600610501996, -122.400225207229)
45385 196287 2 16 1 Jack Balestreri Way 16 7 1 1     3     6012398.9699099995 2104759.28758 37.7599662220764 -122.400185431124 (37.7599662220764, -122.400185431124)
46448 196295 2 16 1 Jack Balestreri Way 30 7 1 1     5     6012406.535130001 2104796.6998799997 37.760069369818396 -122.400161894071 (37.7600693698184, -122.400161894071)
53555 196289 2 16 1 Jack Balestreri Way 20 7 1 1     12     6012382.84954 2104763.06022 37.7599756820445 -122.400241449008 (37.7599756820445, -122.400241449008)
69480 196293 2 16 1 Jack Balestreri Way 26 7 1 1     3     6012394.755369999 2104793.13157 37.760058915200894 -122.40020238425899 (37.7600589152009, -122.400202384259)
72281 196286 2 16 1 Jack Balestreri Way 10 7 1 1     27     6012387.37414 2104738.06992 37.7599073164914 -122.40022404532301 (37.7599073164914, -122.400224045323)
132745 196291 2 16 1 Jack Balestreri Way 24 7 1 1     2     6012380.38083 2104793.15065 37.7600581660633 -122.40025210055401 (37.7600581660633, -122.400252100554)
151012 196294 2 16 1 Jack Balestreri Way 29 7 1 1     3     6012397.7351 2104775.9114900003 37.7600117988112 -122.400190869313 (37.7600117988112, -122.400190869313)
174122 196290 2 16 1 Jack Balestreri Way 23 7 1 1     2     6012385.57921 2104781.3261 37.760025988325296 -122.400233291241 (37.7600259883253, -122.400233291241)
36563 202259 2 237 1 Kalmanovitz St 51 9 1 1     9     6013218.01399 2093376.8881599999 37.7287581966316 -122.396554840154 (37.7287581966316, -122.396554840154)
150404 237804 2 16 1 Loma Vista Ter 3 2 1 1     6 Width 3ft   6000006.51649 2106939.02785 37.7652524667463 -122.443201354463 (37.7652524667463, -122.443201354463)
170839 237803 2 16 1 Loma Vista Ter 2 2 1 1     6 Width 3ft   6000002.45309 2106902.83574 37.765152860531 -122.44321280913601 (37.765152860531, -122.443212809136)
176936 237802 2 16 1 Loma Vista Ter 1 2 1 1     8 Width 3ft   6000002.6635 2106881.0655400003 37.765093096983705 -122.44321051766899 (37.7650930969837, -122.443210517669)
153474 196471 2 18 1 Middle Point Rd 5 9 1 1     6 Width 6ft   6018269.46967 2096338.3756 37.7371696942217 -122.379297066815 (37.7371696942217, -122.379297066815)
98840 42078 1 35 1 Norwich St 2 1 1 1 1 06/21/2000 12:00:00 AM     Permit Number 42388 6009309.20723614 2099453.41599437 37.7452247183965 -122.410496799342 (37.7452247183965, -122.410496799342)
121829 42077 1 35 1 Norwich St 1 1 1 1 1 06/21/2000 12:00:00 AM     Permit Number 42388 6009309.20723614 2099453.41599437 37.7452247183965 -122.410496799342 (37.7452247183965, -122.410496799342)
184483 237163 2 18 1 Norwich St 1 1 1 1     9 Width 3ft   6009249.65239 2099454.9972599996 37.7452257212815 -122.410702842362 (37.7452257212815, -122.410702842362)
136660 238536 2 84 1 Penny Ln 4 13 1 1     3 Width 2ft   6002355.478619999 2096490.80035 37.736697774076 -122.434329814067 (37.736697774076, -122.434329814067)
25491 236748 2 16 1 Romain St 2 1 1 1     6 Width 2ft   6001094.60828 2103699.72105 37.7564201071117 -122.439205717892 (37.7564201071117, -122.439205717892)
57117 236747 2 16 1 Romain St 1 1 1 1     6 Width 2ft   6001077.0051 2103698.81701 37.75641662313279 -122.439266530936 (37.7564166231328, -122.439266530936)
69786 212402 2 16 1 San Rafael Way 2 2 1 1     3 Width 6ft   5991904.19278 2095912.91043 37.734512268621295 -122.470422033273 (37.7345122686213, -122.470422033273)
172302 212403 2 16 1 San Rafael Way 3 2 1 1     2 Width 6ft   5991902.57817 2095944.2843799999 37.734598320237296 -122.470429899615 (37.7345983202373, -122.470429899615)
174012 212401 2 16 1 San Rafael Way 1 2 1 1     3 Width 6ft   5991904.4182 2095887.6067400002 37.7344428040878 -122.470419411726 (37.7344428040878, -122.470419411726)
156323 213482 2 18 1 Sola Ave 5 2 1 1     2 Width 4ft   5994974.838219999 2100674.05314 37.7477622510295 -122.460150689121 (37.7477622510295, -122.460150689121)
165527 238521 2 18 1 Sussex St 2 1 1 1     11 Width 2ft   6002789.51517 2096155.18282 37.7358008721014 -122.43280519430701 (37.7358008721014, -122.432805194307)
110198 84097 1 16 1-3 Romain St 1 1 1 1   05/29/2008 12:00:00 AM   3x3 Permit Number 50459 6001154.30534256 2103349.66248879 37.7554623279051 -122.43897417865 (37.7554623279051, -122.43897417865)
141258 84096 1 16 1-3 Romain St 2 1 1 1   05/29/2008 12:00:00 AM   3x3 Permit Number 50459 6001154.30534256 2103349.66248879 37.7554623279051 -122.43897417865 (37.7554623279051, -122.43897417865)
71627 121889 2 16 10 17th Ave 0 2 1 1     6 Width 5ft   5990520.54715 2115002.72082 37.78684768786071 -122.47659987163799 (37.7868476878607, -122.476599871638)
52991 237609 2 16 10 Caselli Ave 1 1 1 1     8 Width 3ft   6001055.552759999 2104949.38722 37.7598491636392 -122.439430361332 (37.7598491636392, -122.439430361332)
134692 237610 2 16 10 Caselli Ave 2 1 1 1     3 Width 3ft   6001029.5229400005 2104945.6197 37.759837337548 -122.439520115455 (37.759837337548, -122.439520115455)
147875 237612 2 16 10 Caselli Ave 4 1 1 1     7 Width 3ft   6001004.261469999 2104946.80592 37.7598391568788 -122.439607567343 (37.7598391568788, -122.439607567343)
186867 237611 2 16 10 Caselli Ave 3 1 1 1     6 Width 3ft   6001014.58495 2104947.25452 37.759840976186396 -122.43957189572399 (37.7598409761864, -122.439571895724)
71980 196271 2 16 10 Cashmere St 1 4 1 1     31     6017110.310380001 2095865.5402400002 37.7358073912904 -122.383271945238 (37.7358073912904, -122.383271945238)
40170 213651 2 18 10 Edgehill Way 1 2 1 1     8 Width 3ft   5994859.86261 2099088.6488 37.743402514010704 -122.460433407183 (37.7434025140107, -122.460433407183)
72974 213652 2 18 10 Edgehill Way 2 2 1 1     4 Width 3ft   5994842.29481 2099078.88139 37.743374684505206 -122.46049344413099 (37.7433746845052, -122.460493444131)
76291 213654 2 18 10 Edgehill Way 4 2 1 1     9 Width 3ft   5994824.078840001 2099066.74247 37.7433403061049 -122.460555550413 (37.7433403061049, -122.460555550413)
76930 213653 2 18 10 Edgehill Way 3 2 1 1     5 Width 3ft   5994833.218169999 2099074.30171 37.7433615876766 -122.46052449682699 (37.7433615876766, -122.460524496827)
38648 68912 1 16 10 Florence St 1 1 1 1 1 12/29/1993 12:00:00 AM 8   Permit Number 32890 6008496.870730001 2118345.67653 37.797052862167604 -122.41464241973 (37.7970528621676, -122.41464241973)
30216 196205 2 16 10 Freelon St 8 1 1 1     4 Width 2ft   6013581.78975 2111736.47585 37.77918990623971 -122.396583701171 (37.7791899062397, -122.396583701171)
46370 196203 2 16 10 Freelon St 6 1 1 1     5 Width 2ft   6013624.81706 2111774.8130099997 37.7792975658558 -122.396437538871 (37.7792975658558, -122.396437538871)
49852 196204 2 16 10 Freelon St 7 1 1 1     5 Width 2ft   6013601.37493 2111753.2604400003 37.7792370828557 -122.396517124359 (37.7792370828557, -122.396517124359)
72868 196206 2 16 10 Freelon St 9 1 1 1     6 Width 2ft   6013551.06217 2111704.71777 37.7791009956579 -122.39668777431999 (37.7791009956579, -122.39668777432)
75379 196198 2 16 10 Freelon St 1 1 1 1     9 Width 2ft   6013719.80665 2111866.7259400003 37.779555223429604 -122.39611537115 (37.7795552234296, -122.39611537115)
154401 196207 2 16 10 Freelon St 10 1 1 1     6 Width 2ft   6013520.85267 2111676.69387 37.779022367025796 -122.39679031682199 (37.7790223670258, -122.396790316822)
158933 196200 2 16 10 Freelon St 3 1 1 1     6 Width 2ft   6013682.55541 2111829.59348 37.7794511934496 -122.396241636866 (37.7794511934496, -122.396241636866)
Powered by Datasette · Query took 74.449ms · Data source: data.sfgov.org