sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
102043 41729 1 45 99X 14th St 3 1 1 1 1 06/19/2000 12:00:00 AM     Permit Number 42172 6008031.27943269 2107943.20653569 37.7684640195804 -122.415516624702 (37.7684640195804, -122.415516624702)
143280 41725 1 45 99X 14th St 4 1 1 1 1 06/19/2000 12:00:00 AM     Permit Number 42172 6008031.27943269 2107943.20653569 37.7684640195804 -122.415516624702 (37.7684640195804, -122.415516624702)
144874 41728 1 45 99X 14th St 2 1 1 1 1 06/19/2000 12:00:00 AM     Permit Number 42172 6008031.27943269 2107943.20653569 37.7684640195804 -122.415516624702 (37.7684640195804, -122.415516624702)
145443 41726 1 45 99X 14th St 1 1 1 1 1 06/19/2000 12:00:00 AM     Permit Number 42172 6008031.27943269 2107943.20653569 37.7684640195804 -122.415516624702 (37.7684640195804, -122.415516624702)
46279 240375 2 45 99 Ramona Ave 2 1 1 1     3 Width 3ft   6005227.26292 2107315.18034 37.7665816008793 -122.425170785627 (37.7665816008793, -122.425170785627)
74323 240374 2 45 99 Ramona Ave 1 1 1 1     10 Width 3ft   6005228.2825 2107285.15785 37.7664992238917 -122.425165122599 (37.7664992238917, -122.425165122599)
149725 136320 2 45 99 North Point St 21 9 1 1     6 Width 4ft   6010568.43745 2122006.8054400003 37.8072215900736 -122.40773254351801 (37.8072215900736, -122.407732543518)
165341 136319 2 45 99 North Point St 20 9 1 1     4 Width 4ft   6010537.589980001 2122003.14861 37.8072098224406 -122.40783904035901 (37.8072098224406, -122.407839040359)
174144 240381 2 45 98 14th St 2 1 1 1     9 Width 3ft   6008070.808569999 2107998.41684 37.7686178359612 -122.415383805538 (37.7686178359612, -122.415383805538)
167275 136317 2 45 954 Vallejo St 3 9 1 1     6 Width 5ft   6008931.36114 2118725.70113 37.798120717152294 -122.413165857925 (37.7981207171523, -122.413165857925)
167372 40008 1 45 950 Innes Ave 1 1 1 1 1 02/03/1999 12:00:00 AM 8   Permit Number 41261 6018990.20826 2094681.6711099998 37.7326604269313 -122.376690235261 (37.7326604269313, -122.376690235261)
155347 179374 2 45 906 Madrid St 2 1 1 1     6 Width 2ft   6001350.07755 2088911.8778 37.71583065984 -122.437263408906 (37.71583065984, -122.437263408906)
53789 32019 1 45 900 07th St 2 1 1 1   07/24/1995 12:00:00 AM     Permit Number 35412 6012513.40810989 2108571.960758 37.7704413522571 -122.40005739994601 (37.7704413522571, -122.400057399946)
97529 42941 1 45 90 14TH ST 2 1 1 1   07/05/2000 12:00:00 AM 10   Permit Number 42835 6008035.0 2107992.0 37.768598204141995 -122.415507210488 (37.768598204142, -122.415507210488)
103731 42939 1 45 90 14TH ST 4 1 1 1   07/05/2000 12:00:00 AM     Permit Number 42835 6008035.0 2107992.0 37.768598204141995 -122.415507210488 (37.768598204142, -122.415507210488)
155782 179379 2 45 899 Mansell St 9 1 1 1     4 Width 3ft   6009540.44789 2090000.72733 37.71928261398529 -122.40903035607 (37.7192826139853, -122.40903035607)
132552 136315 2 45 895 Green St 1 1 1 1     6 Width 4ft   6009067.06929 2119033.92208 37.7989746333364 -122.41271806751001 (37.7989746333364, -122.41271806751)
149302 136316 2 45 895 Green St 2 1 1 1     3 Width 4ft   6009084.75499 2119036.14381 37.798981726274 -122.41265702602502 (37.798981726274, -122.412657026025)
23996 240380 2 45 87 14th St 4 1 1 1     10 Width 3ft   6008113.4152 2107953.3802 37.768496570485794 -122.41523324373199 (37.7684965704858, -122.415233243732)
67968 240378 2 45 87 14th St 2 1 1 1     6 Width 3ft   6008072.764690001 2107952.79864 37.768492689 -122.41537380956899 (37.768492689, -122.415373809569)
68004 240379 2 45 87 14th St 3 1 1 1     7 Width 3ft   6008087.13667 2107952.681 37.7684931737476 -122.41532408966002 (37.7684931737476, -122.41532408966)
180886 240377 2 45 87 14th St 1 1 1 1     9 Width 3ft   6008059.81094 2107952.1886400003 37.768490286015 -122.415418572409 (37.768490286015, -122.415418572409)
68843 32524 1 45 862 Moultrie St 1 1 1 1 1 10/15/1996 12:00:00 AM 4   Permit Number 37026 6007537.57048 2095302.13495 37.733726737790796 -122.416328859904 (37.7337267377908, -122.416328859904)
60527 32523 1 45 861 Moultrie St 1 1 1 1 1 10/15/1996 12:00:00 AM 8   Permit Number 37025 6007568.6691 2095324.89508 37.7337909808565 -122.416222953925 (37.7337909808565, -122.416222953925)
183550 32520 1 45 848 Moultrie St 1 1 1 1 1 10/15/1996 12:00:00 AM 6   Permit Number 37022 6007545.9989 2095398.0670900003 37.7339906204551 -122.416306512649 (37.7339906204551, -122.416306512649)
40556 32518 1 45 842 Moultrie St 1 1 1 1 1 08/23/2007 12:00:00 AM 9   Permit Number 49664 6007548.7449 2095423.3131 37.7340600948986 -122.41629880637 (37.7340600948986, -122.41629880637)
48290 67377 1 45 841 Balboa St 1 1 1 1 1 12/22/2015 12:00:00 AM 1   Permit Number 776566 5992946.95858 2111357.65552 37.776979766827104 -122.467939896695 (37.7769797668271, -122.467939896695)
113170 88439 1 45 837 Moultrie St   1 1 1   07/11/2008 12:00:00 AM   3x3 Permit Number 51403 6007580.0 2095463.0 37.7341708239465 -122.416193557304 (37.7341708239465, -122.416193557304)
147065 32517 1 45 837 Moultrie St 1 1 1 1 1 05/18/1998 12:00:00 AM 5   Permit Number 39421 6007583.92915 2095468.81341 37.734187007231796 -122.41618038453998 (37.7341870072318, -122.41618038454)
41529 73403 2 45 81 Lyell St 1 1 1 1 1 08/27/1994 12:00:00 AM 4     6003121.9233099995 2094558.5911 37.7314358416937 -122.43154198316999 (37.7314358416937, -122.43154198317)
142202 70387 2 45 81 Lyell St 2 1 1 1 1 08/27/1994 12:00:00 AM 4     6003118.96111 2094567.6101799998 37.7314604381496 -122.431552867694 (37.7314604381496, -122.431552867694)
41992 118563 2 45 8000 Geary Blvd 1 1 1 1     11 Width 3ft   5982185.81739 2112405.54556 37.7792296683273 -122.50524304882099 (37.7792296683273, -122.505243048821)
150597 94725 1 45 79 Manzanita Ave 1 1 1 1 1 10/28/2010 12:00:00 AM 4 3x3 Permit Number 53859 5997862.3449099995 2114019.18294 37.7845702460701 -122.451128124682 (37.7845702460701, -122.451128124682)
162778 179375 2 45 778 Edinburgh St 1 1 1 1     2 Width 2ft   6001912.74857 2089301.2462099998 37.7169317492882 -122.435346396016 (37.7169317492882, -122.435346396016)
93817 35102 1 45 778 Edinburg St 1 1 1 1 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767512 6001912.66160072 2089308.81779253 37.716952534231794 -122.435347237927 (37.7169525342318, -122.435347237927)
142203 197348 2 45 776 Tehama St 1 1 1 1     5 Width 2ft   6009001.8467 2110254.60923 37.7748650979682 -122.412322898178 (37.7748650979682, -122.412322898178)
157856 197349 2 45 776 Tehama St 2 1 1 1     5 Width 2ft   6008993.795609999 2110246.5783 37.7748425951336 -122.412350180929 (37.7748425951336, -122.412350180929)
96974 112589 2 45 776 TEHAMA ST   1 1 1       3x3   6009004.0 2110266.0 37.7748964951756 -122.41231625471 (37.7748964951756, -122.41231625471)
105477 112588 2 45 776 TEHAMA ST   1 1 1       3x3   6009004.0 2110266.0 37.7748964951756 -122.41231625471 (37.7748964951756, -122.41231625471)
101774 8103 1 45 775 Fulton St 2 1 1 1   04/14/1998 12:00:00 AM 8 3X3   6004110.63243 2111457.69852 37.7778928009026 -122.42932844351601 (37.7778928009026, -122.429328443516)
58725 82802 1 45 770 40th Ave 1 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52410 5983565.30013547 2110567.26400669 37.7742633542941 -122.500334977362 (37.7742633542941, -122.500334977362)
108701 72276 1 45 770 40th Ave 1 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52410 5983565.30013547 2110567.26400669 37.7742633542941 -122.500334977362 (37.7742633542941, -122.500334977362)
131206 179380 2 45 77 Santa Cruz Ave 1 9 1 1     9 Width 3ft   5993077.06779 2086425.7469099998 37.7085305695939 -122.46567800964199 (37.7085305695939, -122.465678009642)
93271 8100 1 45 765 Fulton St 3 1 1 1   04/14/1998 12:00:00 AM 6 3X3   6004193.95704 2111472.64562 37.7779385589247 -122.429041260431 (37.7779385589247, -122.429041260431)
18331 34 3 45 759 14th St 1 1 1 2     18 3X3   6003742.09963 2107707.8799900003 37.767575847275204 -122.430335723414 (37.7675758472752, -122.430335723414)
20666 33 3 45 755 14th St 1 1 1 2   02/17/1998 12:00:00 AM 3 3X3   6003762.7674 2107707.98129 37.7675772960935 -122.43026424352199 (37.7675772960935, -122.430264243522)
19634 31 3 45 753 14th St 1 1 1 2   06/08/2016 06:04:00 AM 3 3X3   6003785.60824 2107710.67637 37.7675859898405 -122.430185432325 (37.7675859898405, -122.430185432325)
97182 32 3 45 753 14th St 2 1 1 2   06/08/2016 06:10:00 AM 3 3X3   6003820.6216400005 2107707.01694 37.7675779249973 -122.43006406443999 (37.7675779249973, -122.43006406444)
50859 240415 2 45 751 14th St 1 1 1 1     1 Width 2ft   6003800.46059 2107711.4253 37.7675888874331 -122.43013411340901 (37.7675888874331, -122.430134113409)
40581 214021 2 45 75 Fairfield Way 5 1 1 1     2 Width 2ft   5993799.03412 2093427.92907 37.727798498601295 -122.463690690492 (37.7277984986013, -122.463690690492)
188052 214020 2 45 75 Fairfield Way 4 1 1 1     2 Width 2ft   5993790.82197 2093445.17793 37.727845386546605 -122.46372033123501 (37.7278453865466, -122.463720331235)
21370 22 3 45 725 14th St 1 1 1 2   01/18/2017 08:22:00 AM 3 3X3   6003898.66598 2107719.95316 37.7676178644975 -122.429795042015 (37.7676178644975, -122.429795042015)
25229 197350 2 45 719 Tehama St 2 1 1 1     3 Width 2ft   6009290.40599 2110497.98819 37.7755495477154 -122.411341904202 (37.7755495477154, -122.411341904202)
99913 38034 1 45 71 Wawona St 1 1 1 1 1 07/10/1998 12:00:00 AM     Permit Number 40237 5993126.63617522 2098605.576855 37.7419762612493 -122.466391311334 (37.7419762612493, -122.466391311334)
90205 67457 1 45 709 Scott St 1 1 1 1   06/30/2009 12:00:00 AM   3x3 Permit Number 52276 6002046.91633096 2110893.18552424 37.7762257387634 -122.43642713667299 (37.7762257387634, -122.436427136673)
80692 100236 2 45 701X 39th Ave 9 1 1 1     6 3x3   5983814.22353 2110811.1524900002 37.7749476096575 -122.499491947241 (37.7749476096575, -122.499491947241)
91393 100238 2 45 701X 39th Ave 11 1 1 1     3 3x3   5983814.58777 2110777.43528 37.774855053302495 -122.499488194975 (37.7748550533025, -122.499488194975)
104373 100234 2 45 701X 39th Ave 7 1 1 1     10 3x3   5983811.49615 2110876.46915 37.7751267903243 -122.499506209788 (37.7751267903243, -122.499506209788)
126645 44207 1 45 701 Sutter St 1 1 1 1 1 12/28/2000 12:00:00 AM     Permit Number 43655 6009221.06713893 2115299.96241651 37.7887307349007 -122.411921176175 (37.7887307349007, -122.411921176175)
142043 51741 1 45 700 Crescent Ave 1 1 1 1   06/27/2005 12:00:00 AM     Permit Number 48018 6007951.80914494 2095656.00646211 37.73472167706821 -122.414921747465 (37.7347216770682, -122.414921747465)
31206 246759 2 45 70 Waltham St 3 7 1 1     8     6009196.74806 2098886.80636 37.7436626276403 -122.410845655606 (37.7436626276403, -122.410845655606)
38193 246761 2 45 70 Waltham St 5 7 1 1     16     6009235.422669999 2098888.8268 37.7436703438078 -122.410712070303 (37.7436703438078, -122.410712070303)
43322 246767 2 45 70 Waltham St 11 7 1 1     13     6009322.267109999 2098890.11567 37.743678751571295 -122.410411873024 (37.7436787515713, -122.410411873024)
113357 18570 1 45 698X Randolph St 1 1 1 1   04/21/1997 12:00:00 AM 6 3X3   5992368.005846401 2088553.4079402 37.7143316913291 -122.46828327353701 (37.7143316913291, -122.468283273537)
38403 197339 2 45 696 Amador St 1 7 1 1     24     6016827.1128 2099574.92506 37.745976956489294 -122.384509368331 (37.7459769564893, -122.384509368331)
157777 197340 2 45 696 Amador St 2 7 1 1     18     6016813.36643 2099575.53369 37.745977867490204 -122.384556944272 (37.7459778674902, -122.384556944272)
185231 197341 2 45 696 Amador St 3 7 1 1     21     6016796.90554 2099573.89089 37.745972446388 -122.384613749949 (37.745972446388, -122.384613749949)
47391 197344 2 45 670 Howard St 5 1 1 1     5 Width 4ft   6012519.5716699995 2113947.09446 37.785200579973605 -122.40041369075199 (37.7852005799736, -122.400413690752)
176461 103083 2 45 670 Howard St 2 1 1 1     4 3x3   6012579.2635 2114003.58062 37.785359006363 -122.40021114274599 (37.785359006363, -122.400211142746)
183385 197342 2 45 670 Howard St 3 1 1 1     4 Width 4ft   6012547.8789099995 2113973.86639 37.785275667977 -122.400317636871 (37.785275667977, -122.400317636871)
188741 197343 2 45 670 Howard St 4 1 1 1     4 Width 4ft   6012532.19574 2113959.45979 37.7852352362655 -122.40037088392799 (37.7852352362655, -122.400370883928)
43641 179373 2 45 670 Brunswick St 17 10 1 1     7     5998557.70629 2086647.36142 37.709453678716706 -122.446752254708 (37.7094536787167, -122.446752254708)
169354 117837 3 45 660x 39th Ave 2 11 1 2     7 Width 6ft   5983820.01458 2111273.2343900003 37.776216692790705 -122.49950607144899 (37.7762166927907, -122.499506071449)
86432 117228 2 45 66 POTOMAC ST 1 1 1 1     3 3x3   6003144.0 2108708.0 37.7702880357607 -122.43247591327801 (37.7702880357607, -122.432475913278)
106034 41818 1 45 66 Encanto Ave 1 1 1 1 1 06/20/2000 12:00:00 AM     Permit Number 42204 6000020.46726166 2112594.97224476 37.7807830542731 -122.44355943151699 (37.7807830542731, -122.443559431517)
128479 41874 1 45 66 Belcher St 3 1 1 1 1 06/20/2000 12:00:00 AM     Permit Number 42253 6003778.26782897 2107952.91484982 37.768250702181504 -122.430228105724 (37.7682507021815, -122.430228105724)
139989 41876 1 45 66 Belcher St 2 1 1 1 1 06/20/2000 12:00:00 AM     Permit Number 42253 6003778.26782897 2107952.91484982 37.768250702181504 -122.430228105724 (37.7682507021815, -122.430228105724)
144346 41875 1 45 66 Belcher St 1 1 1 1 1 06/20/2000 12:00:00 AM     Permit Number 42253 6003778.26782897 2107952.91484982 37.768250702181504 -122.430228105724 (37.7682507021815, -122.430228105724)
134645 214022 2 45 659 Hearst Ave 1 1 1 1     5 Width 2ft   5997050.53703 2094389.3323099997 37.7306251064676 -122.45251959171101 (37.7306251064676, -122.452519591711)
48473 92109 1 45 654 46th Ave 1 1 1 1   07/02/2009 12:00:00 AM 3 3x3 Permit Number 52365 5981669.51861 2111284.19832 37.7761203861627 -122.506945906937 (37.7761203861627, -122.506945906937)
158949 197336 2 45 651 Missouri St 2 9 1 1     18     6013643.57223 2103811.4939599996 37.757433106182 -122.39581450923201 (37.757433106182, -122.395814509232)
185623 78275 2 45 65 Pomona St 1 1 1 1 1 07/15/2000 12:00:00 AM 7     6014137.61661 2094337.2388799998 37.7314462603177 -122.39344287108901 (37.7314462603177, -122.393442871089)
1152 240384 2 45 65 Hermann St 2 1 1 1   05/04/2017 12:00:00 AM 3 Width 2ft Permit Number 779910 6004983.769180001 2108813.08838 37.7706807377627 -122.426119636009 (37.7706807377627, -122.426119636009)
33363 240383 2 45 65 Hermann St 1 1 1 1     6 Width 2ft   6004954.4402 2108809.15318 37.770668274943205 -122.426220805247 (37.7706682749432, -122.426220805247)
143527 42777 1 45 65 Hermann St 1 1 1 1 1 08/17/2004 12:00:00 AM     Permit Number 47615 6004966.00219495 2108807.30598956 37.7706638565131 -122.42618068058701 (37.7706638565131, -122.426180680587)
71181 240388 2 45 65 Gates St 1 1 1 1     5 Width 3ft   6008348.72479 2098315.88712 37.742047422761296 -122.413737549756 (37.7420474227613, -122.413737549756)
188506 84809 1 45 648 27th Ave 1 1 1 1   04/03/2007 12:00:00 AM 3   Permit No. 49264 5987557.75332 2111531.90689 37.7771455293989 -122.486595377302 (37.7771455293989, -122.486595377302)
99237 48566 1 45 638 Head St 1 1 1 1 1 09/23/2002 12:00:00 AM     Permit Number 45985 5993535.88564574 2090091.48019383 37.7186222534444 -122.464358255955 (37.7186222534444, -122.464358255955)
171047 214038 2 45 638 Head St 1 4 1 1     5 Width 3ft   5993525.3619099995 2090091.0611400001 37.718620496206796 -122.46439460152901 (37.7186204962068, -122.464394601529)
53292 217579 2 45 636 Randolph St 1 1 1 1     4 Width 0ft   5992273.5996 2088560.7555 37.714346412845295 -122.46861011007299 (37.7143464128453, -122.468610110073)
25175 34531 1 45 635 24th Ave 1 1 1 1   07/22/1997 12:00:00 AM 5   Permit Number 38240 5988437.8449 2111647.649 37.7775145896121 -122.483559386935 (37.7775145896121, -122.483559386935)
66397 140854 2 45 623 Euclid Ave 1 1 1 1     4 Width 0ft   5996411.3906 2113796.8958 37.783876725924294 -122.456131829019 (37.7838767259243, -122.456131829019)
54123 140855 2 45 621 Euclid Ave 2 1 1 1     4 Width 0ft   5996425.9427 2113796.2189 37.7838757026194 -122.45608143549101 (37.7838757026194, -122.456081435491)
187983 140856 2 45 619 Euclid Ave 3 1 1 1     3 Width 0ft   5996442.8638 2113795.8805 37.783875744697596 -122.456022870631 (37.7838757446976, -122.456022870631)
26373 140857 2 45 617 Euclid Ave 4 1 1 1     2 Width 0ft   5996458.4312 2113796.5573 37.7838784965198 -122.45596906246 (37.7838784965198, -122.45596906246)
137156 118182 2 45 615 33rd Ave 1 1 1 1     1 Width 3ft   5985646.494109999 2111667.23632 37.7774055049593 -122.493216904169 (37.7774055049593, -122.493216904169)
33870 95740 1 45 61 Ina Ct 1 1 1 1 1 09/07/2011 12:00:00 AM 4 3x3 Permit Number 767486 6004943.22126 2091523.89765 37.7232063048111 -122.42502956775499 (37.7232063048111, -122.425029567755)
137254 124092 2 45 601 Funston Ave 7 9 1 1     10     5991890.07496 2111196.5227799998 37.776476251963295 -122.47158420369101 (37.7764762519633, -122.471584203691)
36052 240426 2 45 60 Brady St 2 1 1 1     3 Width 3ft   6006672.38997 2109529.27096 37.772742500096705 -122.42032950031499 (37.7727425000967, -122.420329500315)
7100 106210 1 45 585X Bush St 6 1 1 1   11/06/2014 12:00:00 AM 3 3x3 Permit Number 774310 6010773.37918 2115862.1930299997 37.7903614528559 -122.406590009715 (37.7903614528559, -122.406590009715)
137888 214039 2 45 57 Nordhoff St 1 9 1 1     7 Width 2ft   6000414.26094 2095519.5651200002 37.7339206127394 -122.440971772322 (37.7339206127394, -122.440971772322)
Powered by Datasette · Query took 9.023ms · Data source: data.sfgov.org