sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
20931 15064 3 75 1X Minerva St 7 11 1 2     6 11   5995989.76979 2089004.05491 37.715777580947 -122.455797663726 (37.715777580947, -122.455797663726)
19986 15072 3 75 1X Minerva St 4 11 1 2     6 11   5995966.887709999 2089005.2550700002 37.71577956305239 -122.45587684097 (37.7157795630524, -122.45587684097)
19459 15076 3 75 1 Minerva St 2 11 1 2     6 11   5995952.59829 2089005.6317099999 37.7157797770894 -122.455926258705 (37.7157797770894, -122.455926258705)
10497 28546 1 75 5125 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3x3   6000380.5163 2089281.6434 37.716790788359795 -122.440641159733 (37.7167907883598, -122.440641159733)
36034 187450 2 75 5098 Mission St 2 1 1 1     13 Width 0ft   6000319.4478 2089309.2863 37.7168632117114 -122.440854224757 (37.7168632117114, -122.440854224757)
140150 28545 1 75 5098 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3X3   6000324.7175 2089317.7589200002 37.7168867757364 -122.44083661746299 (37.7168867757364, -122.440836617463)
13149 28547 1 75 5109 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3x3   6000411.4099 2089335.4212 37.7169402093066 -122.44053823097799 (37.7169402093066, -122.440538230978)
76143 217453 2 75 296 Montana St 1 9 1 1     6 Width 10ft   5994116.14589 2089356.42812 37.7166374065639 -122.462299264809 (37.7166374065639, -122.462299264809)
10445 24508 1 75 5088 Mission St 1 1 1 1   04/26/1995 12:00:00 AM 3 3X3   6000357.2418 2089366.5868 37.717022698354604 -122.440727697577 (37.7170226983546, -122.440727697577)
10435 28548 1 75 5095 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3x3   6000516.105 2089501.9034 37.7174032930481 -122.440188283496 (37.7174032930481, -122.440188283496)
10771 28544 3 75 5060 Mission St 1 1 1 2   08/08/2003 12:00:00 AM 12 3X3   6000449.8979 2089508.0094 37.7174162891529 -122.440417567822 (37.7174162891529, -122.440417567822)
13194 28543 1 75 5050 Mission St 3 1 1 1   08/08/2003 12:00:00 AM 14 3X3   6000463.3087 2089534.8309 37.717490698541106 -122.44037313550601 (37.7174906985411, -122.440373135506)
108424 106038 6 75 230 Lakeview Ave   7 1 1         Permit Number 772456 5997013.1 2089546.6 37.7173259605404 -122.452299707743 (37.7173259605404, -122.452299707743)
11001 15823 3 75 5051 Mission St 3 1 1 2   08/08/2003 12:00:00 AM 12 3x3   6000607.6416 2089644.9294 37.717801221251 -122.439882133799 (37.717801221251, -122.439882133799)
165317 217452 2 75 248 Thrift St 2 9 1 1     19     5994521.8342699995 2089659.5838400002 37.7174931519523 -122.46091897182801 (37.7174931519523, -122.460918971828)
137787 217451 2 75 248 Thrift St 1 9 1 1     16     5994521.5845800005 2089667.4223099998 37.7175146601568 -122.460920402674 (37.7175146601568, -122.460920402674)
10709 28542 3 75 5036 Mission St 1 1 1 2   08/08/2003 12:00:00 AM 12 3X3   6000555.9648 2089678.6918 37.7178909833984 -122.44006317666401 (37.7178909833984, -122.440063176664)
74492 187444 2 75 5025 Mission St 1 1 1 1     16 Width 0ft   6000645.4005 2089706.7167 37.7179730245698 -122.43975604576299 (37.7179730245698, -122.439756045763)
66149 181268 2 75 1116 Girard St 1 1 1 1     17 Width 3ft   6011841.7145 2089718.86782 37.7186373306372 -122.401055901109 (37.7186373306372, -122.401055901109)
156730 181275 2 75 0 Gonzalez Dr 4 2 1 1     11     5988424.04089 2089826.4329400002 37.7175985174299 -122.482008206935 (37.7175985174299, -122.482008206935)
168519 181276 2 75 0 Gonzalez Dr 5 2 1 1     11     5988413.87941 2089827.13064 37.7175998421416 -122.482043381217 (37.7175998421416, -122.482043381217)
36738 181277 2 75 0 Gonzalez Dr 6 2 1 1     11     5988402.74919 2089827.8491900002 37.7176011677477 -122.482081905481 (37.7176011677477, -122.482081905481)
13075 15809 1 75 4971 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 16 3x3   6000847.9253 2090031.6718 37.7188768038041 -122.43907928418501 (37.7188768038041, -122.439079284185)
33282 217464 2 75 127 Beverly St 1 9 1 1     4 Width 10ft   5991405.11003 2090040.73714 37.7183598726973 -122.471719713607 (37.7183598726973, -122.471719713607)
83056 108808 1 75 542 Moscow St   1 1 1 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774650 6003656.47159 2090041.31767 37.7190626969286 -122.42937193832199 (37.7190626969286, -122.429371938322)
132970 181220 2 75 542 Moscow St 1 1 1 1     9 Width 3ft   6003657.268730001 2090042.27022 37.7190653575524 -122.429369250808 (37.7190653575524, -122.429369250808)
10432 28549 1 75 4963 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3x3   6000879.9631 2090072.8632 37.71899172902071 -122.438971492831 (37.7189917290207, -122.438971492831)
55472 181221 2 75 577 Vienna St 1 1 1 1     15 Width 3ft   6003118.4058300005 2090123.02436 37.719256567824104 -122.43123765172199 (37.7192565678241, -122.431237651722)
184860 181218 2 75 765 Delano Ave 10 9 1 1     26 Width 10ft   5998962.78764 2090178.0255900002 37.719171212271796 -122.445605954547 (37.7191712122718, -122.445605954547)
153281 202068 2 75 1 Hwy 101 S On Ramp 7 2 1 1     12     6013001.93809 2090218.0162799999 37.7200725469917 -122.39708043181601 (37.7200725469917, -122.397080431816)
97788 15799 3 75 4950 Mission St 5 1 1 2   08/08/2003 12:00:00 AM 12 3X3   6000922.5163 2090289.03562 37.7195877108284 -122.438839886053 (37.7195877108284, -122.438839886053)
106605 15797 3 75 4950 Mission St 2 1 1 2   08/08/2003 12:00:00 AM 12 3X3   6000922.5163 2090289.03562 37.7195877108284 -122.438839886053 (37.7195877108284, -122.438839886053)
121532 28775 3 75 4950 Mission St 3 1 1 2     12 3X3   6000922.5163 2090289.03562 37.7195877108284 -122.438839886053 (37.7195877108284, -122.438839886053)
12407 28550 1 75 4919 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3X3   6001014.7517 2090296.9851 37.7196147854688 -122.438521631633 (37.7196147854688, -122.438521631633)
131126 187462 2 75 4900 Mission St 4 1 1 1     14 Width 0ft   6000950.9727 2090300.4634 37.7196207078773 -122.438742341247 (37.7196207078773, -122.438742341247)
67120 217465 2 75 270 Byxbee St 1 9 1 1     8 Width 10ft   5991973.319019999 2090312.5132 37.719138962561395 -122.469775446797 (37.7191389625614, -122.469775446797)
137927 187461 2 75 4900 Mission St 3 1 1 1     13 Width 0ft   6000966.6486 2090329.2095 37.719700529984706 -122.438690214146 (37.7197005299847, -122.438690214146)
137624 217466 2 75 380 Ralston St 1 9 1 1     13 Width 6ft   5992234.1227 2090402.1103 37.7194000456453 -122.46888047296801 (37.7194000456453, -122.468880472968)
150476 187460 2 75 4900 Mission St 2 1 1 1     17 Width 0ft   6001022.9031 2090418.7219 37.7199495109601 -122.438502172843 (37.7199495109601, -122.438502172843)
174910 181219 2 75 519 Lisbon St 1 2 1 1     21 Width 6ft   6002044.02941 2090439.9964599998 37.720065958565 -122.434974017336 (37.720065958565, -122.434974017336)
10322 15786 3 75 4840 Mission St 6 1 1 2   03/04/2013 12:00:00 AM 12 3x3   6001077.7653 2090502.844 37.7201836118857 -122.43831855702 (37.7201836118857, -122.43831855702)
11469 28551 1 75 4885 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3X3   6001150.501 2090506.6381 37.720198166433896 -122.438067406183 (37.7201981664339, -122.438067406183)
44242 181222 2 75 578 Madrid St 1 1 1 1     22 Width 3ft   6002385.20268 2090560.3971799999 37.720415918045795 -122.43380329969101 (37.7204159180458, -122.433803299691)
85176 104920 2 75 750 Gonzalez Dr 1 3 1 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
101258 104921 2 75 750 Gonzalez Dr 2 3 1 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
111624 104922 2 75 750 Gonzalez Dr 3 3 1 1         missing? 5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
128606 104928 2 75 810 Gonzalez Dr 3 3 1 1     12     5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
143894 104927 2 75 810 Gonzalez Dr 2 3 1 1     10     5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
144760 104926 2 75 810 Gonzalez Dr 1 3 1 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
11493 15784 3 75 4840 Mission St 4 1 1 2   12/02/2015 02:53:00 PM 3 3X3   6001135.2157 2090596.8347 37.7204449566644 -122.438126700052 (37.7204449566644, -122.438126700052)
45056 217450 2 75 127 Lee Ave 1 1 1 1     16 Width 3ft   5996493.32654 2090728.3649400002 37.720541019141706 -122.454181619786 (37.7205410191417, -122.454181619786)
12884 15778 1 75 4830 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 15 3x3   6001221.4914 2090732.7596 37.7208230821415 -122.437838203744 (37.7208230821415, -122.437838203744)
10427 28552 1 75 4839 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3x3   6001308.3124 2090760.3284 37.7209037164668 -122.437540063841 (37.7209037164668, -122.437540063841)
160890 217448 2 75 1030 Plymouth Ave 1 1 1 1     15 Width 4ft   5995947.80275 2090762.8814700001 37.72060449599329 -122.456069804902 (37.7206044959933, -122.456069804902)
12148 15777 1 75 4826 Mission St 1 1 1 1   02/02/2013 12:00:00 AM 14 3X3   6001241.8395 2090763.6886 37.7209091632567 -122.43777008073401 (37.7209091632567, -122.437770080734)
103153 101530 2 75 1030 Plymouth Ave 1 1 1 1     14 4x3   5995974.8 2090771.5 37.720629710016205 -122.455977107218 (37.7206297100162, -122.455977107218)
122621 101531 2 75 1030 Plymouth Ave 2 1 1 1     14 4x3   5995974.8 2090771.5 37.720629710016205 -122.455977107218 (37.7206297100162, -122.455977107218)
51345 217449 2 75 1038 Plymouth Ave 1 1 1 1     17 Width 4ft   5995950.204940001 2090812.4665700002 37.7207407828315 -122.45606508435101 (37.7207407828315, -122.456065084351)
156331 202029 2 75 1331 Fitzgerald Ave 1 9 1 1     20 Width 7ft   6013954.19623 2091006.8516900002 37.7222914964254 -122.39384396154199 (37.7222914964254, -122.393843961542)
118654 28553 1 75 4791 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3X3   6001495.20995 2091053.11607 37.7217182698376 -122.436914966203 (37.7217182698376, -122.436914966203)
177866 187457 2 75 4787 Mission St 1 1 1 1     15 Width 0ft   6001508.6333 2091075.8490000002 37.721781452274705 -122.43687019188101 (37.7217814522747, -122.436870191881)
140763 28541 1 75 4760 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3X3   6001455.13645 2091107.7518200001 37.7218660095523 -122.437057399169 (37.7218660095523, -122.437057399169)
28270 217447 2 75 395 Faxon Ave 3 9 1 1     17 Width 2ft   5994720.00419 2091109.04775 37.721484434931796 -122.460338956771 (37.7214844349318, -122.460338956771)
33699 187438 2 75 4760 Mission St 2 1 1 1     15 Width 0ft   6001460.7844 2091113.675 37.721882594303395 -122.437038299541 (37.7218825943034, -122.437038299541)
10773 28540 1 75 4754 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3X3   6001487.6438 2091153.5571 37.7219936282262 -122.43694830738701 (37.7219936282262, -122.436948307387)
10503 15772 1 75 4769 Mission St 1 1 1 1   02/23/2007 12:00:00 AM 3 3x3   6001557.6417 2091157.3044 37.722007895755794 -122.436706610694 (37.7220078957558, -122.436706610694)
138237 217446 2 75 395 Faxon Ave 2 9 1 1     17 Width 2ft   5994720.49228 2091159.88936 37.7216240618899 -122.46034095147101 (37.7216240618899, -122.460340951471)
130191 217445 2 75 395 Faxon Ave 1 9 1 1     16 Width 2ft   5994721.42442 2091190.6109200001 37.721708469553 -122.46033995415199 (37.721708469553, -122.460339954152)
150487 217444 2 75 701 Holloway Ave 3 9 1 1     17 Width 2ft   5994706.40918 2091208.56862 37.721756913341295 -122.46039315802601 (37.7217569133413, -122.460393158026)
10447 28554 1 75 4753 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3x3   6001590.7646 2091209.3547 37.722152696500004 -122.436595837081 (37.7221526965, -122.436595837081)
11802 28539 1 75 4734 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3x3   6001578.802999999 2091300.8769999999 37.7224033163499 -122.436643733228 (37.7224033163499, -122.436643733228)
11123 28555 1 75 4743 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3X3   6001652.2787 2091307.3716 37.722425324335 -122.436390209739 (37.722425324335, -122.436390209739)
11110 28537 1 75 4716 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3X3   6001661.0091 2091431.1044 37.7227655627881 -122.436368881923 (37.7227655627881, -122.436368881923)
11198 28556 1 75 4717 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3X3   6001738.1279 2091443.2433 37.7228032751332 -122.436103167424 (37.7228032751332, -122.436103167424)
134322 181287 2 75 363 Naples St 1 1 1 1     15 Width 2ft   6003634.21177 2091450.06481 37.7229295456509 -122.429549295987 (37.7229295456509, -122.429549295987)
120258 28637 1 75 955 Ocean Ave 2 1 1 1   04/03/2003 12:00:00 AM 24 5XX5   5996975.36021 2091606.08521 37.7229786625948 -122.452578702244 (37.7229786625948, -122.452578702244)
129269 28636 1 75 955 Ocean Ave 1 1 1 1   04/03/2003 12:00:00 AM 20 5X5   5996968.04232 2091607.5946900002 37.7229823879791 -122.452604107446 (37.7229823879791, -122.452604107446)
127972 28557 1 75 4681 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3X3   6001872.38004 2091652.00525 37.7233841148131 -122.43565401519 (37.7233841148131, -122.43565401519)
171883 187455 2 75 4779 Mission St 1 1 1 1     17 Width 0ft   6001879.4074 2091666.3162 37.7234238086089 -122.435630746292 (37.7234238086089, -122.435630746292)
105609 28635 3 75 1001 Ocean Ave 2 1 1 2   04/03/2003 12:00:00 AM 21 5X5   5996764.463409999 2091686.23626 37.723186652559 -122.45331350914 (37.723186652559, -122.45331350914)
80612 28634 3 75 1001 Ocean Ave 1 1 1 2   04/03/2003 12:00:00 AM 25 5X5   5996752.18528 2091690.06821 37.7231964704228 -122.453356228535 (37.7231964704228, -122.453356228535)
103090 15755 3 75 4669 Mission St 2 1 1 2   01/01/2006 12:00:00 AM 12 3x3   6001907.5344845 2091721.0874415 37.7235757956571 -122.43553743265801 (37.7235757956571, -122.435537432658)
82761 28581 1 75 1100 Ocean Ave 2 1 1 1   04/03/2003 12:00:00 AM 18 4X4   5996838.9416251 2091728.3014296002 37.7233064222609 -122.453059088902 (37.7233064222609, -122.453059088902)
87014 28580 1 75 1100 Ocean Ave 1 1 1 1   04/03/2003 12:00:00 AM 18 4X4   5996838.9416251 2091728.3014296002 37.7233064222609 -122.453059088902 (37.7233064222609, -122.453059088902)
89453 28583 3 75 1100 Ocean Ave 4 1 1 2   06/29/2007 12:00:00 AM 18 4X4   5996838.9416251 2091728.3014296002 37.7233064222609 -122.453059088902 (37.7233064222609, -122.453059088902)
102619 28582 3 75 1100 Ocean Ave 3 1 1 2   04/03/2003 12:00:00 AM 18 4X4   5996838.9416251 2091728.3014296002 37.7233064222609 -122.453059088902 (37.7233064222609, -122.453059088902)
139974 28632 1 75 1051 Ocean Ave 2 1 1 1   04/03/2003 12:00:00 AM 18 5X5   5996612.56003 2091733.27597 37.723307104505295 -122.453842001957 (37.7233071045053, -122.453842001957)
119225 28631 1 75 1051 Ocean Ave 1 1 1 1   04/03/2003 12:00:00 AM 18 5x5   5996604.51775 2091735.3595900002 37.7233123645372 -122.45386995284099 (37.7233123645372, -122.453869952841)
11137 28558 1 75 4667 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3X3   6001923.346 2091737.9699 37.723623049111296 -122.435483982262 (37.7236230491113, -122.435483982262)
78467 115494 4 75 1199X OCEAN AVE 2 1 1 1   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
84834 115491 4 75 280 BRIGHTON AVE 2 1 1 1   02/10/2016 12:00:00 AM 3 4x12 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
88750 115493 4 75 280 BRIGHTON AVE 4 1 1 1   02/10/2016 12:00:00 AM 3 4x12 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
116577 106315 4 75 1199X OCEAN AVE 1 1 1 1   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
126990 115495 4 75 1199X OCEAN AVE 3 1 1 1   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
129261 115492 4 75 280 BRIGHTON AVE 3 1 1 1   02/10/2016 12:00:00 AM 3 4x12 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
143786 115490 4 75 280 BRIGHTON AVE 1 1 1 1   02/10/2016 12:00:00 AM 3 4x12 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
128162 28610 3 75 1107 Ocean Ave 1 1 1 2   06/29/2007 12:00:00 AM 18 5X5   5996451.82773 2091748.4966099998 37.7233396801105 -122.45439871889799 (37.7233396801105, -122.454398718898)
117717 28609 1 75 1117 Ocean Ave 4 1 1 1   04/03/2003 12:00:00 AM 18 5X5   5996444.46775 2091779.60617 37.723424677500205 -122.454426406995 (37.7234246775002, -122.454426406995)
80955 28559 1 75 4647 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3X3   6002004.69492 2091867.26763 37.7239826914316 -122.435212017462 (37.7239826914316, -122.435212017462)
13119 28560 1 75 4631 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3x3   6002010.8853 2091868.7717 37.7239871728 -122.43519072585501 (37.7239871728, -122.435190725855)
83918 28625 1 75 1299 Ocean Ave 5 1 1 1   06/29/2007 12:00:00 AM 18 3X3   5996025.31382 2091881.53932 37.7236805140054 -122.455882701682 (37.7236805140054, -122.455882701682)
Powered by Datasette · Query took 13.581ms · Data source: data.sfgov.org