sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
17038 115537 4 66 99X Lech Walesa St 2 1 1 1   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.502280001 2111387.72892 37.7778703965252 -122.41892509804701 (37.7778703965252, -122.418925098047)
78927 115540 4 66 99X Lech Walesa St 5 1 1 1   02/08/2016 12:00:00 AM 3 3x5 Permit Number 770842 6007116.502280001 2111387.72892 37.7778703965252 -122.41892509804701 (37.7778703965252, -122.418925098047)
89451 115539 4 66 99X Lech Walesa St 4 1 1 1   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.502280001 2111387.72892 37.7778703965252 -122.41892509804701 (37.7778703965252, -122.418925098047)
120364 115538 4 66 99X Lech Walesa St 3 1 1 1   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.502280001 2111387.72892 37.7778703965252 -122.41892509804701 (37.7778703965252, -122.418925098047)
142150 115536 4 66 99X Lech Walesa St 1 1 1 1   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.502280001 2111387.72892 37.7778703965252 -122.41892509804701 (37.7778703965252, -122.418925098047)
130622 223035 2 66 99 Manchester St 1 1 1 1     3 Width 3ft   6008263.26696 2099462.20339 37.7451901540099 -122.414114116572 (37.7451901540099, -122.414114116572)
70281 206632 2 66 99 Castenada Ave 2 1 1 1     6 Width 3ft   5994454.48924 2101216.21265 37.749220940594604 -122.46198932515 (37.7492209405946, -122.46198932515)
40226 223024 2 66 979 York St 1 1 1 1     2 Width 3ft   6009975.926030001 2103539.78877 37.756482348291996 -122.40847958248399 (37.756482348292, -122.408479582484)
137065 182595 2 66 955 Rivera St 2 2 1 1     8 Width 0ft   5990177.9035 2100379.6188 37.746676731738894 -122.4767165565 (37.7466767317389, -122.4767165565)
42406 182596 2 66 945 Rivera St 3 2 1 1     8 Width 0ft   5990197.9307 2100380.5725 37.746680511997496 -122.47664737488998 (37.7466805119975, -122.47664737489)
77698 68120 1 66 94 Tiffany Ave 1 1 1 1 1 05/20/1993 12:00:00 AM     Permit Number 31866 6006215.83488054 2099558.94321569 37.745340567320106 -122.42120066595501 (37.7453405673201, -122.421200665955)
72564 206631 2 66 89 Ventura Ave 1 2 1 1     6 Width 3ft   5994365.2652199995 2101880.85976 37.7510407556506 -122.462346061026 (37.7510407556506, -122.462346061026)
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)
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)
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)
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)
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)
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)
142340 121660 2 66 860 Teresita Blvd 1 5 1 1       3x3   5998939.0 2095554.0 37.7339310276146 -122.44607465500401 (37.7339310276146, -122.446074655004)
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)
18096 24588 3 66 820 Cortland Ave 1 1 1 2   04/10/1996 12:00:00 AM 20 3X3   6008195.26733 2097153.24719 37.7388464504963 -122.414185921141 (37.7388464504963, -122.414185921141)
154984 206629 2 66 81 Ventura Ave 2 2 1 1     5 Width 3ft   5994298.95446 2101835.26425 37.7509117433916 -122.46257206157101 (37.7509117433916, -122.462572061571)
165454 206630 2 66 81 Ventura Ave 1 2 1 1     5 Width 3ft   5994323.8061 2101846.4166200003 37.7509437961254 -122.46248693172701 (37.7509437961254, -122.462486931727)
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)
20665 24587 3 66 804 Cortland Ave 1 1 1 2   04/10/1996 12:00:00 AM 18 3X3   6008146.87115 2097150.7739799998 37.738836941075 -122.414353078142 (37.738836941075, -122.414353078142)
60482 247587 2 66 800 Tompkins Ave 8 7 1 1     6     6008949.04431 2096428.8077599998 37.7368996080238 -122.41152853331499 (37.7368996080238, -122.411528533315)
63732 247588 2 66 800 Tompkins Ave 9 7 1 1     6     6008943.011630001 2096440.0672900002 37.7369301858647 -122.411550186315 (37.7369301858647, -122.411550186315)
174439 206625 2 66 80 Ventura Ave 1 2 1 1     3 Width 3ft   5994283.13326 2101793.571 37.7507963531822 -122.46262374828999 (37.7507963531822, -122.46262374829)
185968 206624 2 66 80 Ventura Ave 2 2 1 1     2 Width 3ft   5994298.51296 2101800.2527099997 37.7508155851791 -122.46257104893 (37.7508155851791, -122.46257104893)
97694 63806 1 66 8 Putnam St 1 1 1 1 1 07/09/1987 12:00:00 AM     Permit Number 24493 6009169.73778237 2097426.78712757 37.7396522194543 -122.41083595729299 (37.7396522194543, -122.410835957293)
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)
132280 223046 2 66 77 28th St 1 1 1 1     6 Width 3ft   6005471.50149 2099604.5609999998 37.7454238329391 -122.423777694396 (37.7454238329391, -122.423777694396)
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)
124193 43803 1 66 762 23rd Ave 1 1 1 1 1 07/26/2000 12:00:00 AM     Permit Number 43433 5988853.6653409 2110130.11231626 37.7733720498685 -122.48200974609699 (37.7733720498685, -122.482009746097)
77680 63803 1 66 75 Putnam St 1 1 1 1 1 07/09/1987 12:00:00 AM     Permit Number 24490 6009186.19603238 2097034.65488427 37.7385764323817 -122.41075136529899 (37.7385764323817, -122.410751365299)
97328 62145 1 66 75 28th St 1 1 1 1 1 09/06/1985 12:00:00 AM     Permit Number 22258 6005427.84181989 2099597.4165714 37.7454017512266 -122.42392815474899 (37.7454017512266, -122.423928154749)
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)
115800 68553 1 66 724 44th Ave 1 1 1 1 1 01/20/1996 12:00:00 AM     Permit Number 32442 5982311.44586787 2110822.57803578 37.7748906946614 -122.50469113477 (37.7748906946614, -122.50469113477)
115431 223053 2 66 701 Church St 13 7 1 1     4 Width 3ft   6004342.543869999 2104435.23189 37.7586239308804 -122.42802562498998 (37.7586239308804, -122.42802562499)
187180 223054 2 66 701 Church St 15 7 1 1     5 Width 3ft   6004339.171130001 2104460.25399 37.758692444824206 -122.42803907256099 (37.7586924448242, -122.428039072561)
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)
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)
89728 82956 2 66 660X Clementina St 1 1 1 1 1 06/11/2005 12:00:00 AM 3 3x3   6009636.0 2110586.0 37.7758105844997 -122.41015262108601 (37.7758105844997, -122.410152621086)
96002 82952 2 66 660X Clementina St 5 1 1 1 1 06/11/2005 12:00:00 AM 3 3x3   6009636.0 2110586.0 37.7758105844997 -122.41015262108601 (37.7758105844997, -122.410152621086)
96209 82955 2 66 660X Clementina St 2 1 1 1 1 06/11/2005 12:00:00 AM 3 3x3   6009636.0 2110586.0 37.7758105844997 -122.41015262108601 (37.7758105844997, -122.410152621086)
100905 82953 2 66 660X Clementina St 4 1 1 1 1 06/11/2005 12:00:00 AM 3 3x3   6009636.0 2110586.0 37.7758105844997 -122.41015262108601 (37.7758105844997, -122.410152621086)
117382 82954 2 66 660X Clementina St 3 1 1 1 1 06/11/2005 12:00:00 AM 3 3x3   6009636.0 2110586.0 37.7758105844997 -122.41015262108601 (37.7758105844997, -122.410152621086)
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)
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)
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)
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)
186978 190925 2 66 651 Kansas St 1 1 1 1     1 Width 3ft   6011562.1933699995 2105343.91486 37.761524784975 -122.40312057635 (37.761524784975, -122.40312057635)
107733 84504 2 66 650X Clementina St 2 1 1 1 1 10/14/2006 12:00:00 AM 3 3x3   6009485.16866501 2110503.49163991 37.775575580460206 -122.410668559049 (37.7755755804602, -122.410668559049)
107468 84505 2 66 650 Clementina St 1 1 1 1 1 10/14/2006 12:00:00 AM 3 3x3   6009485.16866501 2110503.49163991 37.775575580460206 -122.410668559049 (37.7755755804602, -122.410668559049)
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)
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)
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)
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)
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)
164832 71420 2 66 637 Greenwich St 1 1 1 1 1 08/26/1995 12:00:00 AM 5     6009832.0273 2120182.0847 37.8021701092209 -122.410152151595 (37.8021701092209, -122.410152151595)
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)
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)
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)
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)
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)
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)
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)
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)
149027 206693 2 66 609 Rockdale Dr 1 1 1 1     3 Width 3ft   5997804.54909 2098010.1173 37.740610086694396 -122.45017375511999 (37.7406100866944, -122.45017375512)
118821 47955 1 66 59 Homestead St 1 1 1 1   06/27/2002 12:00:00 AM     Permit Number 45685 6001000.20919275 2101375.03881203 37.7500317183297 -122.439365554728 (37.7500317183297, -122.439365554728)
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)
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)
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)
107745 49836 1 66 572 Rhode Island St 1 1 1 1 1 04/28/2005 12:00:00 AM     Permit Number 46619 6011764.04798466 2105724.17808831 37.76258017347929 -122.402449179614 (37.7625801734793, -122.402449179614)
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)
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)
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)
82108 102412 2 66 55X Lyon St 4 1 1 1           6000310.8 2109142.0 37.7713186232103 -122.442307075209 (37.7713186232103, -122.442307075209)
145220 64244 1 66 554 Grove St 1 1 1 1 1 01/31/1994 12:00:00 AM     Permit Number 33284 6005149.627474099 2111313.35504132 37.7775552357395 -122.425723916077 (37.7775552357395, -122.425723916077)
139248 35403 1 66 550 30th St 1 1 1 1 1 03/16/1998 12:00:00 AM     Permit Number 38858 6003059.40190018 2098358.03858994 37.7418647106265 -122.432029345324 (37.7418647106265, -122.432029345324)
150656 247816 2 66 550 30th St 1 4 1 1     5 Width 3ft   6003030.78831 2098349.34835 37.741839226995204 -122.43212766126899 (37.7418392269952, -122.432127661269)
69957 98409 1 66 55 19th Ave 1 21 1 1           5990099.2 2106073.1 37.7623049568555 -122.477404745944 (37.7623049568555, -122.477404745944)
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)
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)
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)
24031 206557 2 66 517 Laguna Honda Blvd 2 2 1 1     4 Width 4ft   5995503.23656 2100160.4413400004 37.7463823798599 -122.458286357642 (37.7463823798599, -122.458286357642)
Powered by Datasette · Query took 7.347ms · Data source: data.sfgov.org