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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
77864 34431 1 66 42 Sussex St 1 1 1 1 1 07/15/1997 12:00:00 AM     Permit Number 38175 6002613.57489862 2096408.07550267 37.736485277081705 -122.433431554421 (37.7364852770817, -122.433431554421)
155564 223055 2 66 42 Sussex St 1 1 1 1     4 Width 2ft   6002598.631 2096412.43412 37.7364963969952 -122.433483533142 (37.7364963969952, -122.433483533142)
127030 69506 1 66 401 Nevada St 1 1 1 1 1 05/24/1994 12:00:00 AM     Permit Number 33632 6008948.22977241 2096437.66011224 37.7369238689745 -122.41153197478901 (37.7369238689745, -122.411531974789)
118047 87776 1 66 333 Sussex St   1 1 1   05/30/2008 12:00:00 AM   3x3 Permit Number 50481 6001129.0 2096659.0 37.737089918679 -122.43858232139401 (37.737089918679, -122.438582321394)
146007 87775 1 66 333 Sussex St   1 1 1   05/30/2008 12:00:00 AM   3x3 Permit Number 50481 6001129.0 2096659.0 37.737089918679 -122.43858232139401 (37.737089918679, -122.438582321394)
25265 223034 2 66 578 Moultrie St 1 1 1 1     9 Width 3ft   6007664.494030001 2096661.03983 37.7374651296141 -122.41598624606199 (37.7374651296141, -122.415986246062)
79272 41698 1 66 1 Mizpah St 3 1 1 1 1 06/19/2000 12:00:00 AM     Permit Number 42148 6001073.51924875 2096662.39464483 37.7370960833617 -122.43877438618 (37.7370960833617, -122.43877438618)
117825 41697 1 66 1 Mizpah St 2 1 1 1 1 06/19/2000 12:00:00 AM     Permit Number 42148 6001073.51924875 2096662.39464483 37.7370960833617 -122.43877438618 (37.7370960833617, -122.43877438618)
120499 41696 1 66 1 Mizpah St 1 1 1 1 1 06/19/2000 12:00:00 AM     Permit Number 42148 6001073.51924875 2096662.39464483 37.7370960833617 -122.43877438618 (37.7370960833617, -122.43877438618)
121238 62920 1 66 578 Moultrie St 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23300 6007655.13385737 2096670.74814693 37.7374912602593 -122.41601929597999 (37.7374912602593, -122.41601929598)
39350 223040 2 66 567 Moultrie St 1 1 1 1     4 Width 3ft   6007699.61186 2096703.5074099998 37.7375837106174 -122.41586783322799 (37.7375837106174, -122.415867833228)
168058 223039 2 66 543 Moultrie St 1 1 1 1     9 Width 3ft   6007708.387180001 2096815.6091900002 37.7378920108046 -122.41584542843201 (37.7378920108046, -122.415845428432)
105369 62916 1 66 543 Moultrie St 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23296 6007721.5198304 2096821.74854603 37.737909606417496 -122.415800456905 (37.7379096064175, -122.415800456905)
102257 62913 1 66 503 Moultrie St 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23293 6007737.75654809 2096994.92041001 37.7383860110425 -122.41575657686 (37.7383860110425, -122.41575657686)
103775 62943 1 66 32 Ellert St 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23325 6006886.21663048 2097028.33083041 37.738429841676 -122.418703161695 (37.738429841676, -122.418703161695)
Powered by Datasette · Query took 108.819ms · Data source: data.sfgov.org