sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
109122 117509 2 66 300x HANOVER ST 1 1 1 1       3x3   5999715.0 2086521.0 37.7091727618039 -122.442743399736 (37.7091727618039, -122.442743399736)
185534 176074 2 66 786 Edinburgh St 1 1 1 1     4 Width 2ft   6001892.13578 2089268.05693 37.7168394482606 -122.435415271495 (37.7168394482606, -122.435415271495)
77159 176073 2 66 774 Edinburgh St 1 1 1 1     3 Width 2ft   6001923.16259 2089317.3719 37.7169766182659 -122.43531155267999 (37.7169766182659, -122.43531155268)
99678 35101 1 66 774 Edinburg St 1 1 1 1 1 01/28/1998 12:00:00 AM     Permit Number 38642 6001926.16682464 2089330.25640032 37.71701216685 -122.435302089615 (37.71701216685, -122.435302089615)
123867 32734 1 66 808 Capitol Ave 3 1 1 1 1 10/29/1996 12:00:00 AM     Permit Number 37117 5995081.95862964 2089664.82981262 37.71753977051271 -122.45898327191601 (37.7175397705127, -122.458983271916)
3387 161273 2 66 566 Naples St 1 1 1 1 1   0 Width 0ft   6002889.180369999 2090346.5289900003 37.719857269085104 -122.432045948864 (37.7198572690851, -122.432045948864)
42989 39658 1 66 311 Grafton Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41051 5995887.27205834 2090529.96858098 37.7199614976995 -122.45626220721901 (37.7199614976995, -122.456262207219)
107937 39659 1 66 311 Grafton Ave 2 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41051 5995887.27205834 2090529.96858098 37.7199614976995 -122.45626220721901 (37.7199614976995, -122.456262207219)
86251 39660 1 66 316 Grafton Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41052 5995871.10695115 2090582.25350935 37.7201041317861 -122.456321862645 (37.7201041317861, -122.456321862645)
138305 39661 1 66 316 Grafton Ave 2 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41052 5995871.10695115 2090582.25350935 37.7201041317861 -122.456321862645 (37.7201041317861, -122.456321862645)
88498 35377 1 66 767 San Bruno Ave 1 1 1 1 1 02/23/1998 12:00:00 AM     Permit Number 38834 6011637.61839103 2091581.433538 37.7237401685956 -122.401892240977 (37.7237401685956, -122.401892240977)
84031 40752 1 66 54 Cerritos Ave 2 1 1 1 1 08/13/1999 12:00:00 AM     Permit Number 41722 5992568.54395141 2093000.42735623 37.726553703659995 -122.46791340088001 (37.72655370366, -122.46791340088)
84739 40751 1 66 54 Cerritos Ave 1 1 1 1 1 08/13/1999 12:00:00 AM     Permit Number 41722 5992568.54395141 2093000.42735623 37.726553703659995 -122.46791340088001 (37.72655370366, -122.46791340088)
185933 47492 1 66 657 Cayuga Ave 1 1 1 1 1 05/14/2002 12:00:00 AM 5   Permit Number 45386 6001676.19021 2093232.03842 37.7277113821718 -122.43644523806499 (37.7277113821718, -122.436445238065)
151022 95110 1 66 649 Cayuga Ave 1 1 1 1 1 12/28/2010 12:00:00 AM 2 3x3 Permit Number 54039 6001693.52474 2093271.82828 37.7278216210543 -122.436388158988 (37.7278216210543, -122.436388158988)
66433 95111 1 66 649 Cayuga Ave 2 1 1 1 1 12/28/2010 12:00:00 AM 3 3x3 Permit Number 54039 6001701.74477 2093288.67335 37.727868340851295 -122.43636094730101 (37.7278683408513, -122.436360947301)
42780 200073 2 66 1500 Van Dyke Ave 1 1 1 1     3 Width 0ft   6014933.989 2093151.8218 37.7282355589188 -122.390606833955 (37.7282355589188, -122.390606833955)
175342 200074 2 66 1500 Van Dyke Ave 2 1 1 1     3 Width 0ft   6014921.0644 2093162.4986 37.728264158228896 -122.39065226097 (37.7282641582289, -122.39065226097)
116485 200075 2 66 1500 Van Dyke Ave 3 1 1 1     3 Width 0ft   6014900.2728 2093175.985 37.7283000356482 -122.390725081061 (37.7283000356482, -122.390725081061)
36442 200076 2 66 1500 Van Dyke Ave 4 1 1 1     4 Width 0ft   6014887.9102 2093187.7857 37.728331752097795 -122.390768643797 (37.7283317520978, -122.390768643797)
96011 53145 1 66 1498@ KEITH Underwood Ave 7 1 1 1 1 11/02/2006 12:00:00 AM     Permit Number 49074 6015150.01654287 2093336.52012549 37.7287546860169 -122.389872907792 (37.7287546860169, -122.389872907792)
135298 176075 2 66 100 Capistrano Ave 3 1 1 1     1 Width 4ft   6001444.800340001 2093622.381 37.7287700227166 -122.43727309280001 (37.7287700227166, -122.4372730928)
33049 206535 2 66 665 Miramar Ave 3 1 1 1     5 Width 2ft   5995362.41808 2093767.65006 37.7288212525964 -122.458310655534 (37.7288212525964, -122.458310655534)
171923 206534 2 66 665 Miramar Ave 2 1 1 1     6 Width 2ft   5995362.10243 2093779.40423 37.7288535085691 -122.45831259717501 (37.7288535085691, -122.458312597175)
25122 206533 2 66 665 Miramar Ave 1 1 1 1     6 Width 2ft   5995361.50595 2093791.16395 37.7288857636427 -122.45831551006201 (37.7288857636427, -122.458315510062)
161050 199671 2 66 1905 Keith St 6 1 1 1     2 Width 0ft   6015210.0019 2093419.3228 37.728985371993396 -122.389671313679 (37.7289853719934, -122.389671313679)
101018 33392 1 66 161 Pinehurst Way 1 1 1 1 1 11/19/1996 12:00:00 AM     Permit Number 37511 5993609.77804843 2093900.82209008 37.729086039701 -122.464379267011 (37.729086039701, -122.464379267011)
179097 30759 1 66 1563 Thomas Ave 1 1 1 1 1 10/31/2005 12:00:00 AM 5   Permit Number 48354 6014932.9973 2093776.0212 37.7299494300904 -122.39065386327499 (37.7299494300904, -122.390653863275)
166442 206532 2 66 160 San Aleso Ave 2 1 1 1     1 Width 3ft   5993345.963169999 2094536.94274 37.730817459756 -122.46533747775 (37.730817459756, -122.46533747775)
70255 206531 2 66 160 San Aleso Ave 1 1 1 1     4 Width 3ft   5993348.57217 2094559.38972 37.730879244086296 -122.46533008801399 (37.7308792440863, -122.465330088014)
16408 78332 3 66 50 Pomona St 15 1 1 4 2 07/01/2009 12:00:00 AM 3 3x3 Permit Number 52305 6014106.86245 2094390.7581099998 37.73159150443121 -122.393552939125 (37.7315915044312, -122.393552939125)
14652 51358 3 66 50 Pomona St 14 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014110.4538 2094404.7193099998 37.7316300385939 -122.393541499766 (37.7316300385939, -122.393541499766)
13409 51359 3 66 50 Pomona St 13 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014112.78564 2094416.99761 37.73166388187129 -122.393534297068 (37.7316638818713, -122.393534297068)
16162 51360 3 66 50 Pomona St 12 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014114.6767 2094431.72556 37.7317044268964 -122.39352878961999 (37.7317044268964, -122.39352878962)
138325 72340 1 66 230 Baden St 1 1 1 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51610 6000779.3756349 2094751.92568258 37.7318336416051 -122.43965444861999 (37.7318336416051, -122.43965444862)
35567 206696 2 66 230 Baden St 1 1 1 1     4 Width 2ft   6000774.6257 2094855.9884099998 37.7321191034008 -122.439678327791 (37.7321191034008, -122.439678327791)
163888 38590 1 66 1614 Quesada Ave 1 1 1 1 1 09/17/1998 12:00:00 AM 2   Permit Number 40545 6015168.4288 2094722.1342 37.732560324707705 -122.38990600380698 (37.7325603247077, -122.389906003807)
176558 38592 1 66 1618 Quesada Ave 1 1 1 1 1 09/17/1998 12:00:00 AM 2   Permit Number 40547 6015152.7308 2094735.8699 37.7325971695789 -122.389961235194 (37.7325971695789, -122.389961235194)
61039 206671 2 66 370 Yerba Buena Ave 3 1 1 1     3 Width 3ft   5995266.43425 2095204.88442 37.732762033223 -122.45874648408899 (37.732762033223, -122.458746484089)
119316 206672 2 66 370 Yerba Buena Ave 2 1 1 1     3 Width 3ft   5995263.98331 2095214.4393900002 37.732788127968995 -122.458755649049 (37.732788127969, -122.458755649049)
181759 206559 2 66 355 Yerba Buena Ave 1 9 1 1     7 Width 3ft   5995306.63453 2095221.10602 37.7328088843117 -122.458608676455 (37.7328088843117, -122.458608676455)
29986 206673 2 66 370 Yerba Buena Ave 1 1 1 1     2 Width 3ft   5995261.57654 2095226.1050200001 37.7328200206111 -122.45876481406201 (37.7328200206111, -122.458764814062)
30299 206560 2 66 355 Yerba Buena Ave 2 9 1 1     4 Width 3ft   5995304.48103 2095229.25095 37.7328311245367 -122.458616711016 (37.7328311245367, -122.458616711016)
30345 206561 2 66 355 Yerba Buena Ave 3 9 1 1     8 Width 3ft   5995302.34368 2095238.1668900002 37.732855482695 -122.458624745542 (37.732855482695, -122.458624745542)
19410 42456 1 66 570 Mangels Ave 1 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42599 5997659.71395367 2095289.95204904 37.733132877616896 -122.45047848670099 (37.7331328776169, -122.450478486701)
84074 66157 1 66 1765 Newhall St 1 1 1 1 1 09/04/1990 12:00:00 AM     Permit Number 29228 6013882.21689766 2094959.68148484 37.733141166757896 -122.39436940843201 (37.7331411667579, -122.394369408432)
165652 206674 2 66 300 Yerba Buena Ave 2 1 1 1     5 Width 3ft   5995208.64941 2095407.77696 37.7333158051714 -122.458960944512 (37.7333158051714, -122.458960944512)
188288 206675 2 66 300 Yerba Buena Ave 1 1 1 1     4 Width 3ft   5995199.651459999 2095433.83543 37.733386838132 -122.458993938825 (37.733386838132, -122.458993938825)
183187 206695 2 66 140 Hamerton Ave 1 1 1 1     3 Width 3ft   6001321.914580001 2095363.51303 37.7335437842173 -122.437822570471 (37.7335437842173, -122.437822570471)
157023 206694 2 66 125 Chilton Ave 1 1 1 1     3 Width 3ft   6001630.15209 2095380.35715 37.733607556928 -122.43675811218999 (37.733607556928, -122.43675811219)
51664 206697 2 66 860 Teresita Blvd 1 9 1 1     4 Width 10ft   5998934.9538199995 2095541.69667 37.733897014518206 -122.446087759167 (37.7338970145182, -122.446087759167)
36687 206698 2 66 860 Teresita Blvd 2 9 1 1     4 Width 10ft   5998920.6207 2095542.64427 37.7338987978865 -122.446137381059 (37.7338987978865, -122.446137381059)
33508 206699 2 66 860 Teresita Blvd 3 9 1 1     4 Width 10ft   5998907.63682 2095545.7294400001 37.7339065275492 -122.44618249194599 (37.7339065275492, -122.446182491946)
160923 206700 2 66 860 Teresita Blvd 4 9 1 1     4 Width 10ft   5998900.2822900005 2095547.61505 37.7339112849776 -122.446208054284 (37.7339112849776, -122.446208054284)
87649 121661 2 66 860 Teresita Blvd 2 5 1 1       3x3   5998939.0 2095554.0 37.7339310276146 -122.44607465500401 (37.7339310276146, -122.446074655004)
96465 121662 2 66 860 Teresita Blvd 3 5 1 1       3x3   5998939.0 2095554.0 37.7339310276146 -122.44607465500401 (37.7339310276146, -122.446074655004)
118078 121664 2 66 860 Teresita Blvd 5 5 1 1       3x3   5998939.0 2095554.0 37.7339310276146 -122.44607465500401 (37.7339310276146, -122.446074655004)
126565 121663 2 66 860 Teresita Blvd 4 5 1 1       3x3   5998939.0 2095554.0 37.7339310276146 -122.44607465500401 (37.7339310276146, -122.446074655004)
142340 121660 2 66 860 Teresita Blvd 1 5 1 1       3x3   5998939.0 2095554.0 37.7339310276146 -122.44607465500401 (37.7339310276146, -122.446074655004)
40516 206701 2 66 860 Teresita Blvd 5 9 1 1     4 Width 10ft   5998876.80466 2095558.4978900002 37.733939825858606 -122.446290005877 (37.7339398258586, -122.446290005877)
134815 206702 2 66 860 Teresita Blvd 6 9 1 1     3 Width 10ft   5998869.22619 2095565.73707 37.733959270110795 -122.446316727449 (37.7339592701108, -122.446316727449)
72707 190928 2 66 1778 Quesada Ave 1 4 1 1     4 Width 3ft   6014320.53257 2095360.07162 37.73426491189 -122.39288202418301 (37.73426491189, -122.392882024183)
96973 43489 1 66 731 Banks St 2 1 1 1 1 07/19/2000 12:00:00 AM     Permit Number 43170 6008504.61569086 2095547.09041526 37.734453664768296 -122.413002801242 (37.7344536647683, -122.413002801242)
111195 43490 1 66 731 Banks St 1 1 1 1 1 07/19/2000 12:00:00 AM     Permit Number 43170 6008504.61569086 2095547.09041526 37.734453664768296 -122.413002801242 (37.7344536647683, -122.413002801242)
179932 206676 2 66 240 Yerba Buena Ave 1 1 1 1     5 Width 3ft   5994971.50428 2095856.22795 37.7345335069973 -122.459813287749 (37.7345335069973, -122.459813287749)
105285 65685 1 66 265 Yerba Buena Ave 1 1 1 1 1 04/13/1990 12:00:00 AM     Permit Number 28609 5995018.52111157 2095862.6409490001 37.734553819285296 -122.45965120036101 (37.7345538192853, -122.459651200361)
139837 65683 1 66 234 Yerba Buena Ave 1 1 1 1 1 04/13/1990 12:00:00 AM     Permit Number 28607 5994926.44798675 2095898.35261594 37.7346465797712 -122.459972111851 (37.7346465797712, -122.459972111851)
66473 206691 2 66 582 Los Palmos Dr 1 1 1 1     2 Width 3ft   5996439.41867 2095873.6949599998 37.734665775709296 -122.45473950971599 (37.7346657757093, -122.454739509716)
151039 206692 2 66 582 Los Palmos Dr 2 1 1 1     3 Width 3ft   5996416.06092 2095880.8714400001 37.7346841407625 -122.45482078325199 (37.7346841407625, -122.454820783252)
177940 206677 2 66 228 Yerba Buena Ave 1 1 1 1     6 Width 3ft   5994904.4684 2095946.32835 37.7347770452256 -122.46005157662901 (37.7347770452256, -122.460051576629)
51326 94076 1 66 629 Los Palmos Dr 2 1 1 1   06/02/2010 12:00:00 AM   2x4 Permit Number 53465 5996116.0 2095941.0 37.734832022473 -122.45586253488399 (37.734832022473, -122.455862534884)
80515 94075 1 66 629 Los Palmos Dr 1 1 1 1   06/02/2010 12:00:00 AM   2x4 Permit Number 53465 5996116.0 2095941.0 37.734832022473 -122.45586253488399 (37.734832022473, -122.455862534884)
81479 94078 1 66 629 Los Palmos Dr 4 1 1 1   06/02/2010 12:00:00 AM   2x4 Permit Number 53465 5996116.0 2095941.0 37.734832022473 -122.45586253488399 (37.734832022473, -122.455862534884)
99770 94077 1 66 629 Los Palmos Dr 3 1 1 1   06/02/2010 12:00:00 AM   2x4 Permit Number 53465 5996116.0 2095941.0 37.734832022473 -122.45586253488399 (37.734832022473, -122.455862534884)
165826 206688 2 66 629 Los Palmos Dr 3 1 1 1     3 Width 3ft   5996101.05251 2095948.39142 37.7348514596286 -122.455914747394 (37.7348514596286, -122.455914747394)
58097 206689 2 66 616 Los Palmos Dr 1 1 1 1     3 Width 3ft   5996145.20311 2095954.15677 37.734869823774 -122.45576252094901 (37.734869823774, -122.455762520949)
151724 206687 2 66 629 Los Palmos Dr 2 1 1 1     4 Width 3ft   5996087.4467400005 2095957.96527 37.7348769661929 -122.45596247889 (37.7348769661929, -122.45596247889)
146174 40167 1 66 216 Yerba Buena Ave 1 1 1 1 1 04/26/1999 12:00:00 AM     Permit Number 41360 5994849.72626239 2095987.73496493 37.7348875889443 -122.46024383672199 (37.7348875889443, -122.460243836722)
72284 206690 2 66 616 Los Palmos Dr 2 1 1 1     3 Width 3ft   5996131.5818 2095962.98776 37.7348932897948 -122.45581025245001 (37.7348932897948, -122.45581025245)
188155 206686 2 66 629 Los Palmos Dr 1 1 1 1     4 Width 3ft   5996075.5527099995 2095969.20127 37.7349071348466 -122.456004412496 (37.7349071348466, -122.456004412496)
42708 206685 2 66 641 Los Palmos Dr 1 1 1 1     4 Width 3ft   5996053.59921 2095980.96691 37.734938180348 -122.45608116333099 (37.734938180348, -122.456081163331)
121936 94070 1 66 616 Los Palmos Dr 1 1 1 1   06/02/2010 12:00:00 AM   2x4 Permit Number 53462 5996098.0 2095984.0 37.734949056945204 -122.455927874303 (37.7349490569452, -122.455927874303)
129441 94071 1 66 616 Los Palmos Dr 2 1 1 1   06/02/2010 12:00:00 AM   2x4 Permit Number 53462 5996098.0 2095984.0 37.734949056945204 -122.455927874303 (37.7349490569452, -122.455927874303)
50876 206684 2 66 647 Los Palmos Dr 3 1 1 1     5 Width 3ft   5996011.49185 2096001.54035 37.7349922529962 -122.456228229446 (37.7349922529962, -122.456228229446)
66495 206683 2 66 647 Los Palmos Dr 2 1 1 1     5 Width 3ft   5995995.17419 2096006.3401799998 37.7350044954584 -122.45628499197399 (37.7350044954584, -122.456284991974)
34880 206682 2 66 647 Los Palmos Dr 1 1 1 1     4 Width 3ft   5995986.285069999 2096009.4987 37.7350126577011 -122.45631595293699 (37.7350126577011, -122.456315952937)
160214 206681 2 66 657 Los Palmos Dr 4 1 1 1     5 Width 3ft   5995960.60425 2096012.63655 37.735019799206 -122.45640496693399 (37.735019799206, -122.456404966934)
167831 206678 2 66 657 Los Palmos Dr 1 1 1 1     2 Width 3ft   5995925.9256 2096013.7330599998 37.7350208190394 -122.456524941888 (37.7350208190394, -122.456524941888)
155591 206679 2 66 657 Los Palmos Dr 2 1 1 1     5 Width 3ft   5995939.36036 2096013.8239 37.7350218397738 -122.456478499997 (37.7350218397738, -122.456478499997)
66828 206680 2 66 657 Los Palmos Dr 3 1 1 1     5 Width 3ft   5995948.68471 2096013.6289400002 37.73502183977529 -122.456446248507 (37.7350218397753, -122.456446248507)
142674 94074 1 66 628 Los Palmos Dr 1 1 1 1   06/02/2010 12:00:00 AM   2x4 Permit Number 53464 5996021.0 2096021.0 37.7350462302618 -122.456196763121 (37.7350462302618, -122.456196763121)
118978 60133 1 66 214 Roanoke St 1 1 1 1 1 06/29/2012 12:00:00 AM     Permit Number 768747 6003532.52706643 2096003.65082334 37.7354269125656 -122.43022550454201 (37.7354269125656, -122.430225504542)
63545 223038 2 66 10 Lippard Ave 1 1 1 1     4 Width 3ft   6002089.19721 2096067.16423 37.7355194490575 -122.435220170783 (37.7355194490575, -122.435220170783)
81114 41708 1 66 203 Surrey St 2 1 1 1 1 06/19/2000 12:00:00 AM     Permit Number 42156 6002096.90165519 2096076.31860804 37.7355450223799 -122.43519418820401 (37.7355450223799, -122.435194188204)
121951 41707 1 66 203 Surrey St 1 1 1 1 1 06/19/2000 12:00:00 AM     Permit Number 42156 6002096.90165519 2096076.31860804 37.7355450223799 -122.43519418820401 (37.7355450223799, -122.435194188204)
158004 223037 2 66 203 Surrey St 2 1 1 1     6 Width 3ft   6002071.560219999 2096098.27883 37.7356038810064 -122.435283373351 (37.7356038810064, -122.435283373351)
168083 32398 1 66 244 Richland Ave 1 1 1 1 1 10/03/1996 12:00:00 AM 8   Permit Number 36939 6005971.23324 2096091.5920900002 37.7358062077876 -122.42180021560199 (37.7358062077876, -122.421800215602)
126743 223043 2 66 4107 Ogden Ave 2 1 1 1     6 Width 3ft   6008381.78974 2096055.8705400003 37.735843768863795 -122.413463422917 (37.7358437688638, -122.413463422917)
174269 223032 2 66 281 Richland Ave 1 1 1 1     5 Width 3ft   6006256.18709 2096109.4549 37.735871320489395 -122.42081628443898 (37.7358713204894, -122.420816284439)
162977 223033 2 66 281 Richland Ave 2 1 1 1     6 Width 3ft   6006248.27078 2096110.4955099998 37.735873731571395 -122.420843728155 (37.7358737315714, -122.420843728155)
69745 223042 2 66 330 Park St 1 1 1 1     7 Width 4ft   6006921.22556 2096271.82147 37.736354605390204 -122.418528488295 (37.7363546053902, -122.418528488295)
Powered by Datasette · Query took 7.78ms · Data source: data.sfgov.org