sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3497 247942 4 58 29 Joy St 5 14 1 2     3   Permit Number 775404 6010292.72224 2098904.67919 37.7437730949632 -122.40705728398399 (37.7437730949632, -122.407057283984)
3501 247943 4 22 29 Joy St 6 14 1 2     2   Permit Number 775404 6010304.2598 2098903.51059 37.7437705318851 -122.407017307297 (37.7437705318851, -122.407017307297)
3506 247939 4 180 29 Joy St 2 14 1 2     12   Permit Number 775404 6010258.299769999 2098917.5156900003 37.7438064148349 -122.40717721395 (37.7438064148349, -122.40717721395)
3510 247941 4 58 29 Joy St 4 14 1 2     5   Permit Number 775404 6010287.82636 2098909.7574 37.743786764646 -122.40707457072901 (37.743786764646, -122.407074570729)
3511 247940 4 58 29 Joy St 3 14 1 2     5   Permit Number 775404 6010280.31746 2098909.2881400003 37.7437850559498 -122.407100501782 (37.7437850559498, -122.407100501782)
3513 247938 4 16 29 Joy St 1 14 1 2     9   Permit Number 775404 6010254.90659 2098918.71089 37.7438095066969 -122.407189031056 (37.7438095066969, -122.407189031056)
2811 115532 4 106 100X Hayes St 2 10 1 1   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007293.46404 2111265.83422 37.777545665835596 -122.41830427922501 (37.7775456658356, -122.418304279225)
6140 115534 4 106 100X Hayes St 4 10 1 1   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007259.83389 2111260.26588 37.777528483399294 -122.418420222514 (37.7775284833993, -122.418420222514)
6989 115533 4 106 100X Hayes St 3 10 1 1   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007275.38703 2111262.82601 37.7775363884346 -122.418366600452 (37.7775363884346, -122.418366600452)
8241 115531 4 106 100X Hayes St 1 10 1 1   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007312.7374599995 2111269.98589 37.777558150214404 -122.41823790028 (37.7775581502144, -122.41823790028)
8494 115535 4 106 100X Hayes St 5 10 1 1   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007237.56945 2111260.60051 37.777528148837796 -122.41849726655899 (37.7775281488378, -122.418497266559)
3523 253474 4 16 134 Lunado Way 1 9 1 1       3x2   5991633.0 2092401.0 37.7248537561355 -122.471103859098 (37.7248537561355, -122.471103859098)
9629 173614 4 51 2955 20th Ave 2 9 1 1   12/12/2016 12:00:00 AM 3 3x6 Permit Number 776469 5990236.78382 2095590.4495400002 37.7335303227244 -122.476163213901 (37.7335303227244, -122.476163213901)
9631 173613 4 51 2955 20th Ave 1 9 1 1   12/12/2016 12:00:00 AM 3 3x6 Permit Number 776469 5990236.78382 2095590.4495400002 37.7335303227244 -122.476163213901 (37.7335303227244, -122.476163213901)
9719 173651 4 88 80 Entrada Ct 3 9 1 1   12/21/2016 12:00:00 AM 3 4x10   5992424.456569999 2092194.59394 37.7243327619491 -122.46835290122299 (37.7243327619491, -122.468352901223)
9723 173650 4 12 80 Entrada Ct 2 9 1 1   12/21/2016 12:00:00 AM 3 4x10   5992424.456569999 2092194.59394 37.7243327619491 -122.46835290122299 (37.7243327619491, -122.468352901223)
126630 115885 4 482 134 Lunado Way 1 9 1 1   03/01/2016 12:00:00 AM 3 10x10 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397)
2687 253164 4 17 146 Cambridge St 1 8 1 1   07/27/2017 12:00:00 AM 3 4x4   6006598.94029 2094006.4119099998 37.7301161400075 -122.419482094225 (37.7301161400075, -122.419482094225)
3318 253415 4 88 55 Stoneybrook Ave   8 1 1   08/31/2017 12:00:00 AM 3   Permit Number 779907 6005926.97731 2093972.4268599998 37.729984953042795 -122.421802746417 (37.7299849530428, -122.421802746417)
5087 150676 4 26 548 Rhode Island St 1 8 1 1   11/07/2017 12:00:00 AM 3 3x3 Permit Number 780811 6011754.983990001 2105812.52377 37.762822244976505 -122.402486741392 (37.7628222449765, -122.402486741392)
143274 122379 4 88 466 Vernon St 1 8 1 1   10/26/2016 12:00:00 AM 3 3x3   5992521.0 2090937.0 37.7208852925782 -122.46792773796801 (37.7208852925782, -122.467927737968)
113628 116851 4 41 83 Panorama Dr 3 7 1 1   05/03/2016 12:00:00 AM 3     5997625.8 2100317.8 37.7469361901044 -122.450958160054 (37.7469361901044, -122.450958160054)
117231 116850 4 41 83 Panorama Dr 2 7 1 1   05/03/2016 12:00:00 AM 3     5997625.8 2100317.8 37.7469361901044 -122.450958160054 (37.7469361901044, -122.450958160054)
122654 116267 4 183 717 PARIS ST 1 7 1 1       3x3   6001138.0 2089523.0 37.717496606347495 -122.438040195581 (37.7174966063475, -122.438040195581)
140550 116849 4 2 83 Panorama Dr 1 7 1 1   05/03/2016 12:00:00 AM 3     5997625.8 2100317.8 37.7469361901044 -122.450958160054 (37.7469361901044, -122.450958160054)
140646 121962 4 17 20 16th Ave 1 7 1 1   11/23/2016 12:00:00 AM 3 5x10 Permit Number 778592 5990850.71184 2114913.60159 37.78662213560371 -122.47545108088 (37.7866221356037, -122.47545108088)
20 251179 4 13 1043 Minna St 2 5 1 1       3x3   6007668.0 2109797.0 37.7735336727503 -122.41690453761002 (37.7735336727503, -122.41690453761)
21 251178 4 13 1043 Minna St 1 5 1 1       3x3   6007668.0 2109797.0 37.7735336727503 -122.41690453761002 (37.7735336727503, -122.41690453761)
138 72565 4 44 270 Brannan St 1 5 1 1   11/16/1996 12:00:00 AM 3 4x4 Permit Number 770847 6015158.0 2112983.0 37.782700175280794 -122.39121805332199 (37.7827001752808, -122.391218053322)
139 116640 4 44 270 Brannan St 2 5 1 1     1 4x4   6015158.0 2112983.0 37.782700175280794 -122.39121805332199 (37.7827001752808, -122.391218053322)
2759 253203 4 120 349 Mangels Ave 1 5 1 1       3x3   5999103.0 2095207.0 37.732987611392005 -122.44548271607799 (37.732987611392, -122.445482716078)
5195 253341 4 88 1935 46th Ave 1 5 1 1   08/23/2017 12:00:00 AM 3 3x3 Permit Number 769984 5981944.6810099995 2101921.14451 37.750428327874204 -122.505299944249 (37.7504283278742, -122.505299944249)
9790 104876 4 227 2478 43rd Ave   5 1 1   12/28/2016 12:00:00 AM 3   Permit Number 778928 5983068.6 2098273.8 37.740479796641296 -122.50114367627701 (37.7404797966413, -122.501143676277)
10157 173899 4 46 1762 12th Ave 2 5 1 1       3x3 Permit Number 779465 5992511.90241 2103608.89481 37.7556785957656 -122.468880856653 (37.7556785957656, -122.468880856653)
10163 173898 4 46 1762 12th Ave 1 5 1 1       3x3 Permit Number 779465 5992511.90241 2103608.89481 37.7556785957656 -122.468880856653 (37.7556785957656, -122.468880856653)
35251 121502 4 6 299 Fremont St 2 5 1 1     4 10x4   6014428.99687 2115060.94265 37.7883652457059 -122.393885614549 (37.7883652457059, -122.393885614549)
38160 121504 4 6 299 Fremont St 4 5 1 1     5 10x4   6014396.4001 2115093.29031 37.7884522533286 -122.39400066032499 (37.7884522533286, -122.394000660325)
46572 121505 4 6 299 Fremont St 5 5 1 1     5 10x4   6014377.50413 2115113.61118 37.7885069995398 -122.394067461056 (37.7885069995398, -122.394067461056)
60824 121501 4 6 299 Fremont St 1 5 1 1     4 10x4   6014441.60375 2115047.86993 37.7883300516388 -122.39384108102101 (37.7883300516388, -122.393841081021)
66090 121506 4 21 300 Folsom St 1 5 1 1     11 3x3   6012227.3168 2112699.1751 37.7817577819585 -122.40133708037901 (37.7817577819585, -122.401337080379)
81719 112974 4 12 4099x ULLOA ST 3 5 1 1   10/20/2015 12:00:00 AM   3x3 Permit Number 773327 5983385.0 2098079.0 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652)
89423 121518 4 11 300 Folsom St 13 5 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
90957 112973 4 12 4099x ULLOA ST 2 5 1 1   10/20/2015 12:00:00 AM   3x3 Permit Number 773327 5983385.0 2098079.0 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652)
91523 121514 4 11 300 Folsom St 9 5 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
96576 115405 4 168 2050 43RD AVE 1 5 1 1   01/29/2016 12:00:00 AM 3 3x3   5982969.0 2101168.0 37.7484206232379 -122.50170211889 (37.7484206232379, -122.50170211889)
99977 121510 4 11 300 Folsom St 5 5 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
100921 121512 4 11 300 Folsom St 7 5 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
101034 121516 4 11 300 Folsom St 11 5 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
101885 122625 4 141 189 Country Club Dr 1 5 1 1   11/15/2016 12:00:00 AM 3 4x5 Permit Number 774974 5984222.0 2094938.0 37.731388248087605 -122.496909587532 (37.7313882480876, -122.496909587532)
103215 116528 4 54 125 CROWN TER 1 5 1 1     3 3x3   5998841.0 2104182.0 37.7576158290564 -122.447034160915 (37.7576158290564, -122.447034160915)
105015 112975 4 12 4099x ULLOA ST 4 5 1 1   10/20/2015 12:00:00 AM   3x3 Permit Number 773327 5983385.0 2098079.0 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652)
109588 113335 4 12 2X STANFORD ST 1 5 1 1   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727.0 2112481.0 37.781297869167396 -122.392674013487 (37.7812978691674, -122.392674013487)
117679 117480 4 191 601 PACHECO ST 2 5 1 1       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982)
119781 113337 4 12 2X STANFORD ST 2 5 1 1   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727.0 2112481.0 37.781297869167396 -122.392674013487 (37.7812978691674, -122.392674013487)
120763 117479 4 191 601 PACHECO ST 1 5 1 1       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982)
127734 113338 4 12 2X STANFORD ST 3 5 1 1   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727.0 2112481.0 37.781297869167396 -122.392674013487 (37.7812978691674, -122.392674013487)
127737 112972 4 12 4099x ULLOA ST 1 5 1 1   10/20/2015 12:00:00 AM 1 3x3 Permit Number 773327 5983385.0 2098079.0 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652)
128042 117483 4 191 601 PACHECO ST 5 5 1 1       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982)
138648 122626 4 141 330 Country Club Dr 1 5 1 1   11/15/2016 12:00:00 AM 3 3x5 Permit Number 774975 5984613.0 2095517.0 37.73300093168071 -122.495600537949 (37.7330009316807, -122.495600537949)
140623 117481 4 191 601 PACHECO ST 3 5 1 1       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982)
141647 122627 4 12 34 Country Club Dr 1 5 1 1   11/15/2016 12:00:00 AM 3 3x4 Permit Number 775279 5984731.0 2094410.0 37.729968312905505 -122.49511098534401 (37.7299683129055, -122.495110985344)
142598 121520 4 11 300 Folsom St 15 5 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
143480 117482 4 191 601 PACHECO ST 4 5 1 1       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982)
151686 121503 4 6 299 Fremont St 3 5 1 1     5 10x4   6014412.49464 2115075.87435 37.7884053276005 -122.39394375569401 (37.7884053276005, -122.393943755694)
165797 121508 4 21 300 Folsom St 3 5 1 1     6 3x3   6012258.9126 2112729.3972 37.78184252759429 -122.401229897449 (37.7818425275943, -122.401229897449)
14 196590 4 9 43 Lafayette St 2 4 1 1     10 Width 3ft Permit Number 772992 6007565.6944699995 2109618.27361 37.773037177355796 -122.41724576098301 (37.7730371773558, -122.417245760983)
15 196591 4 9 43 Lafayette St 3 4 1 1     13 Width 3ft Permit Number 772992 6007555.65106 2109624.06249 37.7730525072055 -122.417280912782 (37.7730525072055, -122.417280912782)
30 196592 4 9 43 Lafayette St 4 4 1 1     8 Width 3ft Permit Number 772992 6007533.59843 2109642.31042 37.7731013709756 -122.41735848920901 (37.7731013709756, -122.417358489209)
395 249557 4 11 1450 Franklin St 3 4 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005881.27559 2115126.52616 37.788066583556706 -122.423464052238 (37.7880665835567, -122.423464052238)
404 249555 4 11 1450 Franklin St 1 4 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005893.0868 2115064.96247 37.787898211588704 -122.423418809148 (37.7878982115887, -122.423418809148)
406 249556 4 11 1450 Franklin St 2 4 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005884.0832400005 2115105.79396 37.7880098165527 -122.423452863778 (37.7880098165527, -122.423452863778)
413 249558 4 11 1450 Franklin St 4 4 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005877.98213 2115146.79048 37.7881220384566 -122.42347688825899 (37.7881220384566, -122.423476888259)
721 183636 4 108 1478 47th Ave 1 2 1 1     4 3x9   5981570.9282 2105017.3718 37.7589076903569 -122.506822015648 (37.7589076903569, -122.506822015648)
54 121137 4 26 1388x Minna St 1 1 1 1   09/08/2016 12:00:00 AM 3 3x3            
60 121139 4 26 1388x Minna St 3 1 1 1   09/08/2016 12:00:00 AM 3 3x3            
70 121138 4 26 1388x Minna St 2 1 1 1   09/08/2016 12:00:00 AM 3 3x3            
224 117019 4 2 168 Hyde St 3 1 1 1   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008121.68381 2113004.40875 37.782365960952 -122.41556230388201 (37.782365960952, -122.415562303882)
347 250073 4 26 1599X Bush St 2 1 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
350 85805 4 6 210X Shipley St 1 1 1 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011627.0 2111882.0 37.77948049775679 -122.40335640121799 (37.7794804977568, -122.403356401218)
351 251213 4 6 210X Shipley St 6 1 1 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604.0 2111950.0 37.779665925350706 -122.40344075372101 (37.7796659253507, -122.403440753721)
361 85803 4 69 923 Folsom St 1 1 1 1   04/05/2017 12:00:00 AM 3 3x3 Permit Number 778048 6011427.0378 2111936.1074 37.779617893816 -122.40405196806002 (37.779617893816, -122.40405196806)
365 251211 4 6 210X Shipley St 4 1 1 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604.0 2111950.0 37.779665925350706 -122.40344075372101 (37.7796659253507, -122.403440753721)
369 192563 4 11 33 08th St 1 1 1 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008747.97709 2111280.89227 37.777668779422896 -122.413273679445 (37.7776687794229, -122.413273679445)
372 251291 4 11 33 08th St 5 1 1 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
373 250075 4 26 1599X Bush St 4 1 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
377 250072 4 26 1599X Bush St 1 1 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
384 85806 4 6 210X Shipley St 2 1 1 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011627.0 2111882.0 37.77948049775679 -122.40335640121799 (37.7794804977568, -122.403356401218)
387 85807 4 6 210X Shipley St 3 1 1 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604.0 2111950.0 37.779665925350706 -122.40344075372101 (37.7796659253507, -122.403440753721)
394 85804 4 69 923 Folsom St 2 1 1 1   04/05/2017 12:00:00 AM 3 3x3 Permit Number 778048 6011441.4589 2111949.4191 37.7796552503769 -122.404003016031 (37.7796552503769, -122.404003016031)
396 251212 4 6 210X Shipley St 5 1 1 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604.0 2111950.0 37.779665925350706 -122.40344075372101 (37.7796659253507, -122.403440753721)
400 251289 4 11 33 08th St 3 1 1 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
403 65940 4 62 620 Eddy St 1 1 1 1 1 06/04/1990 12:00:00 AM 8   Permit Number 28961 6007431.46715 2113367.23378 37.78332336932171 -122.41797588370702 (37.7833233693217, -122.417975883707)
412 251290 4 11 33 08th St 4 1 1 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
415 250074 4 26 1599X Bush St 3 1 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
416 192564 4 11 33 08th St 2 1 1 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
425 251299 4 15 2190X Market St 3 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
431 251298 4 15 2190X Market St 4 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
432 251297 4 15 2190X Market St 5 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
446 251296 4 15 2190X Market St 2 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
451 192346 4 83 118 10th St 1 1 1 1   04/09/2014 12:00:00 AM 1 Width 3ft Permit Number 770901 6007994.19176 2110350.5452799997 37.7750719195804 -122.41581539288201 (37.7750719195804, -122.415815392882)
518 251314 4 54 1108 Diamond St 1 1 1 1       3x3   6001901.0 2100825.0 37.7485726639367 -122.43621121860001 (37.7485726639367, -122.4362112186)
Powered by Datasette · Query took 5.425ms · Data source: data.sfgov.org