sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
62736 92146 1 191 728 Jamestown Ave 3 5 1 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52458 6015302.1 2088427.9 37.715285014192204 -122.389004565667 (37.7152850141922, -122.389004565667)
77696 50501 1 191 731 Naples St 2 1 1 1 1 10/30/2003 12:00:00 AM     Permit Number 47137 6002346.93991516 2089394.75729347 37.717213158613895 -122.43385228911998 (37.7172131586139, -122.43385228912)
86400 50500 1 191 731 Naples St 1 1 1 1 1 10/30/2003 12:00:00 AM     Permit Number 47137 6002346.93991516 2089394.75729347 37.717213158613895 -122.43385228911998 (37.7172131586139, -122.43385228912)
92183 94872 1 191 3229 Jennings St   1 1 1 1 11/23/2010 12:00:00 AM   3x3 Permit Number 53942 6013605.0 2090171.0 37.7199770026118 -122.394992544907 (37.7199770026118, -122.394992544907)
111009 94873 1 191 3229 Jennings St   1 1 1 1 11/23/2010 12:00:00 AM   3x3 Permit Number 53942 6013605.0 2090171.0 37.7199770026118 -122.394992544907 (37.7199770026118, -122.394992544907)
110959 82675 1 191 1175 Gilman Ave 1 1 1 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52488 6014632.30522662 2090165.00558289 37.7200176149462 -122.39144105640699 (37.7200176149462, -122.391441056407)
86701 95732 1 191 483 Edinburg St 1 1 1 1 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767479 6003045.8 2090902.6 37.7213929950365 -122.43154424747 (37.7213929950365, -122.43154424747)
118357 50425 1 191 26 Holloway Ave 1 1 1 1 1 10/06/2003 12:00:00 AM     Permit Number 47078 5996739.2697017 2091227.18329804 37.7219247572556 -122.45336747188999 (37.7219247572556, -122.45336747189)
53607 94429 1 191 5800 03rd St 11 1 1 1   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849.0 2092184.0 37.72551786281171 -122.39428997927601 (37.7255178628117, -122.394289979276)
89867 94427 1 191 5800 03rd St 7 1 1 1   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849.0 2092184.0 37.72551786281171 -122.39428997927601 (37.7255178628117, -122.394289979276)
99001 94426 1 191 5800 03rd St 5 1 1 1   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849.0 2092184.0 37.72551786281171 -122.39428997927601 (37.7255178628117, -122.394289979276)
111568 94421 1 191 5800 03rd St 6 5 1 1   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849.0 2092184.0 37.72551786281171 -122.39428997927601 (37.7255178628117, -122.394289979276)
112536 94430 1 191 5800 03rd St 14 1 1 1   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849.0 2092184.0 37.72551786281171 -122.39428997927601 (37.7255178628117, -122.394289979276)
119473 94422 1 191 5800 03rd St 10 5 1 1   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849.0 2092184.0 37.72551786281171 -122.39428997927601 (37.7255178628117, -122.394289979276)
119718 94425 1 191 5800 03rd St 15 5 1 1   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849.0 2092184.0 37.72551786281171 -122.39428997927601 (37.7255178628117, -122.394289979276)
119810 94428 1 191 5800 03rd St 9 1 1 1   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849.0 2092184.0 37.72551786281171 -122.39428997927601 (37.7255178628117, -122.394289979276)
128487 94424 1 191 5800 03rd St 13 5 1 1   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849.0 2092184.0 37.72551786281171 -122.39428997927601 (37.7255178628117, -122.394289979276)
144754 94431 1 191 5800 03rd St 16 1 1 1   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849.0 2092184.0 37.72551786281171 -122.39428997927601 (37.7255178628117, -122.394289979276)
91846 116189 2 191 1751 CARROLL AVE 9 1 1 1     1 3x3   6013485.0 2092424.0 37.72615661412179 -122.395565112125 (37.7261566141218, -122.395565112125)
139654 116183 2 191 1751 CARROLL AVE 1 1 1 1     1 3x15   6013485.0 2092424.0 37.72615661412179 -122.395565112125 (37.7261566141218, -122.395565112125)
77471 100428 1 191 200X Stonecrest Dr 5 1 1 1       2.5x4   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264)
88537 100426 1 191 200X Stonecrest Dr 3 1 1 1       2.5x4   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264)
93522 100427 1 191 200X Stonecrest Dr 4 1 1 1       2.5x4   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264)
93898 100429 1 191 200X Stonecrest Dr 7 1 1 1       2.5x4   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264)
120201 100430 1 191 200X Stonecrest Dr 6 1 1 1       2.5x4   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264)
83782 91399 1 191 76 Keystone Way 1 1 1 1   03/31/2009 12:00:00 AM   3x3 Permit Number 52095 5994157.0 2093252.7 37.7273379826423 -122.46244050013 (37.7273379826423, -122.46244050013)
118692 60397 1 191 1445 Quesada Ave 1 1 1 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52466 6016065.49318693 2093986.4863783 37.730590090931294 -122.38675332477 (37.7305900909313, -122.38675332477)
94230 72891 1 191 143 Valdez Ave 1 9 1 1   09/01/2011 12:00:00 AM     Permit Number 768196 5996238.58765499 2094412.40177524 37.7306418958229 -122.455328273496 (37.7306418958229, -122.455328273496)
117301 72691 1 191 143 Valdez Ave 1 9 1 1   09/01/2011 12:00:00 AM     Permit Number 768196 5996238.58765499 2094412.40177524 37.7306418958229 -122.455328273496 (37.7306418958229, -122.455328273496)
139412 82676 1 191 1621 Revere Ave 1 1 1 1   07/09/2009 12:00:00 AM   3x3 Permit Number 52504 6014985.81451712 2094439.95411177 37.7317753861847 -122.390517640406 (37.7317753861847, -122.390517640406)
110837 97422 1 191 130 San Rafael Way 2 1 1 1   10/06/2011 12:00:00 AM   2x2 Permit Number 768262 5991847.6 2095285.1 37.7327851865934 -122.470571981031 (37.7327851865934, -122.470571981031)
90072 54092 1 191 130 San Rafael Way 1 1 1 1   10/06/2011 12:00:00 AM     Permit Number 768262 5991854.42006361 2095289.1308882 37.7327966487645 -122.47054869605 (37.7327966487645, -122.47054869605)
82587 50396 1 191 62 Springfield Dr 1 1 1 1 1 02/18/2006 12:00:00 AM     Permit Number 47047 5986810.92291605 2095425.7307643 37.7328787927022 -122.48799514007798 (37.7328787927022, -122.487995140078)
91796 42591 1 191 121 Junipero Serra Blvd 4 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42664 5991652.84779157 2095347.0788301998 37.7329441015396 -122.471249796136 (37.7329441015396, -122.471249796136)
117694 106552 1 191 207 Los Palmos Dr   1 1 1   05/08/2014 12:00:00 AM   3X3 Permit Number 768265 5998005.6 2096224.8 37.7357195377121 -122.44935000292601 (37.7357195377121, -122.449350002926)
123565 47958 1 191 300 Los Palmos Dr 1 1 1 1 1 07/05/2002 12:00:00 AM     Permit Number 45688 5997800.77741149 2096297.42452827 37.7359072289386 -122.450063383576 (37.7359072289386, -122.450063383576)
140251 83377 1 191 390 Arlington St 1 1 1 1   05/29/2008 12:00:00 AM   3x3 Permit Number 50471 6004079.008179099 2096201.47422294 37.7360010286865 -122.42835020948999 (37.7360010286865, -122.42835020949)
144532 56773 1 191 1590X McKinnon Ave 2 1 1 1 1 11/23/2010 12:00:00 AM   3x3 Permit Number 53948 6015510.638170599 2096034.20336208 37.736181973612 -122.38881445867901 (37.736181973612, -122.388814458679)
80947 73875 2 191 450X Banks St 2 1 1 4 2 06/18/1994 12:00:00 AM 8 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
89668 52872 1 191 379@ TOMPKIN Nevada St 1 5 1 1   06/30/2009 12:00:00 AM   3x3 Permit Number 52289 6008958.88978629 2096550.85337252 37.7372352710538 -122.411503113021 (37.7372352710538, -122.411503113021)
139398 108932 1 191 418 Anderson St 1 1 1 1 1 01/12/2015 12:00:00 AM 3 3x3 Permit Number 772806 6007857.4 2096898.0 37.738126614046294 -122.415336047656 (37.7381266140463, -122.415336047656)
108785 63832 1 191 331 Ellsworth St 1 1 1 1 1 10/22/2012 12:00:00 AM     Permit Number 769403 6008107.39821454 2097107.9451308998 37.73871712498921 -122.414486527778 (37.7387171249892, -122.414486527778)
82507 96165 1 191 42 Putnam St 2 1 1 1 1 09/08/2011 12:00:00 AM   3x3 Permit Number 767796 6009164.0 2097229.0 37.7391088173015 -122.41084183088999 (37.7391088173015, -122.41084183089)
82616 96164 1 191 42 Putnam St 1 1 1 1 1 09/08/2011 12:00:00 AM   3x3 Permit Number 767796 6009164.0 2097229.0 37.7391088173015 -122.41084183088999 (37.7391088173015, -122.41084183089)
119160 87771 1 191 173 Laidley St   1 1 1   05/30/2008 12:00:00 AM   3x3 Permit Number 50476 6004033.0 2097383.0 37.7392426262863 -122.42859347367599 (37.7392426262863, -122.428593473676)
108109 84473 1 191 173 Laidley St 1 1 1 1   05/30/2008 12:00:00 AM   3x3 Permit Number 50476 6004035.61598466 2097396.11275514 37.7392787789652 -122.428585363223 (37.7392787789652, -122.428585363223)
128836 50699 1 191 315 Elsie St 1 1 1 1   01/16/2004 12:00:00 AM 12 6x8 Permit Number 47261 6006595.62338541 2097346.13779241 37.7392861034365 -122.419730437543 (37.7392861034365, -122.419730437543)
103087 94510 1 191 2531 28th Ave   1 1 1   08/25/2010 12:00:00 AM   3x3 Permit Number 53695 5987646.3 2098052.0 37.7401385375939 -122.485299705684 (37.7401385375939, -122.485299705684)
37395 94780 1 191 200X Loomis St 13 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
65797 94769 1 191 200X Loomis St 2 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
78215 94783 1 191 200X Loomis St 16 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
79142 94774 1 191 200X Loomis St 7 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
85720 94770 1 191 200X Loomis St 3 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
88907 94777 1 191 200X Loomis St 10 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
89454 94775 1 191 200X Loomis St 8 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
97928 94778 1 191 200X Loomis St 11 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
111308 94779 1 191 200X Loomis St 12 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
111502 94776 1 191 200X Loomis St 9 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
112591 94773 1 191 200X Loomis St 6 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
112764 94782 1 191 200X Loomis St 15 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
140573 94768 1 191 200X Loomis St 1 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
141209 94781 1 191 200X Loomis St 14 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
142271 94772 1 191 200X Loomis St 5 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
142655 94771 1 191 200X Loomis St 4 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
120652 52398 1 191 28@ MISSION Santa Marina St 1 1 1 1 1 12/15/2005 12:00:00 AM     Permit Number 48519 6005791.37113066 2097745.41692411 37.7403370957557 -122.422539551549 (37.7403370957557, -122.422539551549)
143239 47980 1 191 2558 14th Ave 1 1 1 1 1 07/05/2002 12:00:00 AM     Permit Number 45714 5992088.46801551 2098030.76622139 37.7403380187937 -122.46993908856399 (37.7403380187937, -122.469939088564)
82052 47978 1 191 2551 14th Ave 1 1 1 1 1 07/05/2002 12:00:00 AM     Permit Number 45712 5992034.71482162 2098081.02537392 37.7404729102685 -122.470128602855 (37.7404729102685, -122.470128602855)
106996 33815 1 191 200 Elsie St 1 1 1 1   03/29/2004 12:00:00 AM 12 3x3 Permit Number 47361 6006849.4113767 2097983.16030049 37.7410495186328 -122.418898117948 (37.7410495186328, -122.418898117948)
95825 113796 8 191 331 TERESITA BLVD 2 29 1 1       3x3   5997873.0 2098382.0 37.741635103508294 -122.44996387489401 (37.7416351035083, -122.449963874894)
103998 50125 1 191 70 Wawona St 1 1 1 1 1 07/29/2003 12:00:00 AM     Permit Number 46848 5993079.36799121 2098627.78111817 37.7420345009836 -122.46655636172301 (37.7420345009836, -122.466556361723)
108229 57204 1 191 2450 14th Ave 1 1 1 1   07/24/2009 12:00:00 AM   3x3 Permit Number 52710 5992063.41903222 2098761.57831598 37.7423431948322 -122.470078897994 (37.7423431948322, -122.470078897994)
17988 87809 1 191 3388 Mission St 2 1 1 1   06/02/2008 12:00:00 AM   3x3 Permit Number 50586 6005908.6 2098553.3 37.7425619734414 -122.422191602046 (37.7425619734414, -122.422191602046)
139839 87808 1 191 3388 Mission St 1 1 1 1   06/02/2008 12:00:00 AM   3x3 Permit Number 50586 6005908.6 2098553.3 37.7425619734414 -122.422191602046 (37.7425619734414, -122.422191602046)
101001 117071 2 191 10 JOY ST 1 20 1 1       3x3   6010420.0 2098909.0 37.7437920807055 -122.406617489968 (37.7437920807055, -122.406617489968)
82633 109310 1 191 99 Coleridge St 1 1 1 1 1 02/10/2015 12:00:00 AM 3 3x3 Permit Number 772820 6006724.0 2099085.0 37.7440678610189 -122.41940989424101 (37.7440678610189, -122.419409894241)
145852 95542 1 191 537 28th St 1 1 1 1 1 03/02/2011 12:00:00 AM   3x3 Permit Number 767329 6002431.0 2099434.0 37.7447834031825 -122.43427905661301 (37.7447834031825, -122.434279056613)
112806 102995 2 191 533 28th St 1 1 1 1   06/06/2013 12:00:00 AM 12 3x3 Permit Number 770096 6002456.0 2099436.0 37.7447903136679 -122.434192754421 (37.7447903136679, -122.434192754421)
138837 102996 2 191 533 28th St 2 1 1 1   06/06/2013 12:00:00 AM   3x3 Permit Number 770096 6002456.0 2099436.0 37.7447903136679 -122.434192754421 (37.7447903136679, -122.434192754421)
112098 100401 2 191 91 Manchester St 1 1 1 1     5 6x4.5   6008260.0 2099484.0 37.7452498191594 -122.414126954963 (37.7452498191594, -122.414126954963)
108809 100402 2 191 70 Manchester St 1 1 1 1     11 8.5x4.5   6008217.0 2099607.0 37.7455851344824 -122.414284343223 (37.7455851344824, -122.414284343223)
98446 99934 2 191 63 Manchester St 2 1 1 1       3x3 Permit Number 768712 6008250.0 2099654.0 37.7457160396744 -122.41417355851002 (37.7457160396744, -122.41417355851)
98719 102227 2 191 621 27th St 1 1 1 1     3 2x2   6002457.0 2100031.0 37.746424100900995 -122.43423182524401 (37.746424100901, -122.434231825244)
123199 102228 2 191 621 27th St 2 1 1 1   03/25/2013 12:00:00 AM 10 2x2 Permit Number 769631 6002457.0 2100031.0 37.746424100900995 -122.43423182524401 (37.746424100901, -122.434231825244)
20474 45183 1 191 90 Montcalm St 3 1 1 1 1 05/23/2001 12:00:00 AM     Permit Number 44029 6010481.84262238 2099977.43671259 37.7467292351784 -122.406478923454 (37.7467292351784, -122.406478923454)
86276 45184 1 191 90 Montcalm St 4 1 1 1 1 05/23/2001 12:00:00 AM     Permit Number 44029 6010481.84262238 2099977.43671259 37.7467292351784 -122.406478923454 (37.7467292351784, -122.406478923454)
101944 45186 1 191 90 Montcalm St 1 1 1 1 1 05/23/2001 12:00:00 AM     Permit Number 44029 6010481.84262238 2099977.43671259 37.7467292351784 -122.406478923454 (37.7467292351784, -122.406478923454)
112424 45185 1 191 90 Montcalm St 2 1 1 1 1 05/23/2001 12:00:00 AM     Permit Number 44029 6010481.84262238 2099977.43671259 37.7467292351784 -122.406478923454 (37.7467292351784, -122.406478923454)
96064 111890 1 191 176X PERALTA AVE 1 1 1 1 1   25 3x3   6009847.0 2100071.0 37.7469506034955 -122.408680755084 (37.7469506034955, -122.408680755084)
93603 37154 1 191 175 27th St 1 1 1 1   08/12/2010 12:00:00 AM   3x3 Permit Number 53678 6005395.05541488 2100179.52375956 37.7469982334442 -122.424082914114 (37.7469982334442, -122.424082914114)
129151 108927 1 191 1612 York St 1 1 1 1 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 773055 6010381.6 2100196.5 37.7473251266072 -122.406840990737 (37.7473251266072, -122.406840990737)
113596 50935 1 191 2140 15th Ave 1 1 1 1 1 03/07/2011 12:00:00 AM   3x3 Permit Number 767415 5991665.93715326 2100855.12914226 37.7480685606743 -122.471605782529 (37.7480685606743, -122.471605782529)
88932 96056 1 191 1532 Florida St 1 1 1 1 1 08/03/2011 12:00:00 AM   3x3 Permit Number 767684 6009571.0 2100485.0 37.7480718940124 -122.40966435882099 (37.7480718940124, -122.409664358821)
106469 50885 1 191 2127 16th Ave 1 1 1 1 1 04/26/2004 12:00:00 AM     Permit Number 47394 5991285.70524254 2100933.45919482 37.7482616292065 -122.472926308365 (37.7482616292065, -122.472926308365)
125600 99742 2 191 511 Clipper St 1 1 1 1       3x3   6001875.0 2100872.0 37.7487002375378 -122.436304489265 (37.7487002375378, -122.436304489265)
108987 94168 1 191 900 Quintara St 1 1 1 1   06/15/2010 12:00:00 AM   3x3 Permit Number 53525 5990680.0 2101127.0 37.7487579569011 -122.475034924429 (37.7487579569011, -122.475034924429)
115007 94169 1 191 900 Quintara St 2 1 1 1   06/15/2010 12:00:00 AM   3x3 Permit Number 53525 5990680.0 2101127.0 37.7487579569011 -122.475034924429 (37.7487579569011, -122.475034924429)
142173 94170 1 191 900 Quintara St 3 1 1 1   06/15/2010 12:00:00 AM   3x3 Permit Number 53525 5990680.0 2101127.0 37.7487579569011 -122.475034924429 (37.7487579569011, -122.475034924429)
143468 94171 1 191 900 Quintara St 4 1 1 1   06/15/2010 12:00:00 AM   3x3 Permit Number 53525 5990680.0 2101127.0 37.7487579569011 -122.475034924429 (37.7487579569011, -122.475034924429)
87026 94152 1 191 2075 16th Ave 1 1 1 1   06/15/2010 12:00:00 AM   3x3 Permit Number 53545 5991258.5 2101318.0 37.7493159033344 -122.47304842091499 (37.7493159033344, -122.473048420915)
94887 107079 1 191 92 Homestead St   1 1 1   07/25/2014 12:00:00 AM   3x3 Permit Number 773562 6000948.33481 2101213.46128 37.7495851129185 -122.439533357227 (37.7495851129185, -122.439533357227)
144338 78046 1 191 4278 25th St 1 1 1 1   12/03/2010 12:00:00 AM   3x3 Permit Number 53968 6002070.11098959 2101218.55986767 37.749662892833 -122.435654588507 (37.749662892833, -122.435654588507)
Powered by Datasette · Query took 3.475ms · Data source: data.sfgov.org