sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
166292 43230 1 45 1371 20th Ave 2 1 1 1 1 07/12/2000 12:00:00 AM 3   Permit Number 43018 5989871.41437878 2106041.52738456 37.7622050471688 -122.47819025383801 (37.7622050471688, -122.478190253838)
44795 122290 2 45 1750 Balboa St 1 9 1 1     1 Width 3ft   5990062.61204 2111318.0216900003 37.7767039596239 -122.47791473389799 (37.7767039596239, -122.477914733898)
36999 122289 2 45 1750 Balboa St 13 9 1 1     1 Width 3ft   5990067.41245 2111319.5030799997 37.7767083057233 -122.477898236364 (37.7767083057233, -122.477898236364)
129693 122288 2 45 1750 Balboa St 12 9 1 1     1 Width 3ft   5990072.179690001 2111319.40231 37.776708305720796 -122.477881737882 (37.7767083057208, -122.477881737882)
58619 122287 2 45 1750 Balboa St 11 9 1 1     1 Width 3ft   5990077.48759 2111319.8179099998 37.776709754904104 -122.477863406875 (37.7767097549041, -122.477863406875)
46494 122286 2 45 1750 Balboa St 10 9 1 1     1 Width 3ft   5990082.62166 2111319.5038 37.7767091904138 -122.477845623834 (37.7767091904138, -122.477845623834)
187748 122285 2 45 1750 Balboa St 9 9 1 1     1 Width 3ft   5990089.24883 2111319.7381700003 37.7767102185501 -122.477822715879 (37.7767102185501, -122.477822715879)
65759 122284 2 45 1750 Balboa St 8 9 1 1     1 Width 3ft   5990094.44484 2111319.9709799998 37.776711159339705 -122.47780475856199 (37.7767111593397, -122.477804758562)
36460 122283 2 45 1750 Balboa St 7 9 1 1     1 Width 3ft   5990098.96698 2111321.01529 37.7767142891731 -122.477789191669 (37.7767142891731, -122.477789191669)
50462 122282 2 45 1750 Balboa St 6 9 1 1     1 Width 3ft   5990106.33926 2111321.3026900003 37.7767155061466 -122.477763710061 (37.7767155061466, -122.477763710061)
30089 122281 2 45 1750 Balboa St 5 9 1 1     1 Width 3ft   5990111.6262 2111320.57885 37.7767138255075 -122.477745368245 (37.7767138255075, -122.477745368245)
135749 122280 2 45 1750 Balboa St 4 9 1 1     1 Width 3ft   5990124.518680001 2111321.36168 37.776716723141206 -122.477700827061 (37.7767167231412, -122.477700827061)
137258 122279 2 45 1750 Balboa St 3 9 1 1     1 Width 3ft   5990130.41151 2111322.13937 37.7767192004406 -122.477680499098 (37.7767192004406, -122.477680499098)
72433 122278 2 45 1750 Balboa St 2 9 1 1     1 Width 3ft   5990134.53204 2111321.8992 37.776718780123794 -122.477666227559 (37.7767187801238, -122.477666227559)
39998 122277 2 45 1750 Balboa St 1 9 1 1     1 Width 3ft   5990139.99053 2111321.69927 37.7767185479371 -122.477647330613 (37.7767185479371, -122.477647330613)
49623 43808 1 45 1420 Cabrillo St 1 1 1 1 1 07/26/2000 12:00:00 AM 1   Permit Number 43438 5991181.63114 2110671.05879 37.77499245989021 -122.473996541351 (37.7749924598902, -122.473996541351)
137254 124092 2 45 601 Funston Ave 7 9 1 1     10     5991890.07496 2111196.5227799998 37.776476251963295 -122.47158420369101 (37.7764762519633, -122.471584203691)
99254 38032 1 45 1400 Ulloa St 2 1 1 1   07/10/1998 12:00:00 AM     Permit Number 40236 5991713.73808693 2098444.67646581 37.7414528421268 -122.471264893104 (37.7414528421268, -122.471264893104)
102562 38030 1 45 1400 Ulloa St 3 1 1 1   07/10/1998 12:00:00 AM     Permit Number 40236 5991713.73808693 2098444.67646581 37.7414528421268 -122.471264893104 (37.7414528421268, -122.471264893104)
108435 38031 1 45 1400 Ulloa St 4 1 1 1   07/10/1998 12:00:00 AM     Permit Number 40236 5991713.73808693 2098444.67646581 37.7414528421268 -122.471264893104 (37.7414528421268, -122.471264893104)
114634 38033 1 45 1400 Ulloa St 1 1 1 1 1 07/10/1998 12:00:00 AM     Permit Number 40236 5991713.73808693 2098444.67646581 37.7414528421268 -122.471264893104 (37.7414528421268, -122.471264893104)
66574 214018 2 45 2464 15th Ave 1 1 1 1     6 Width 3ft   5991736.67899 2098669.28572 37.742070888761894 -122.47120193253001 (37.7420708887619, -122.47120193253)
97169 49152 1 45 2464 15th Ave 1 1 1 1 1 01/23/2003 12:00:00 AM     Permit Number 46274 5991742.04430079 2098660.96480908 37.7420483520093 -122.47118277506901 (37.7420483520093, -122.471182775069)
89712 47995 1 45 2594 15th Ave 2 1 1 1 1 10/28/2010 12:00:00 AM   3x3 Permit Number 53833 5991772.56459051 2097785.68925868 37.739646833729 -122.471013497633 (37.739646833729, -122.471013497633)
118955 47994 1 45 2594 15th Ave 1 1 1 1 1 10/28/2010 12:00:00 AM   3x3 Permit Number 53833 5991772.56459051 2097785.68925868 37.739646833729 -122.471013497633 (37.739646833729, -122.471013497633)
1553 207056 2 45 340 Vicente St 3 1 1 1     2 Width 3ft   5991811.94775 2097766.11202 37.7395953573424 -122.470875903123 (37.7395953573424, -122.470875903123)
1559 207057 2 45 340 Vicente St 2 1 1 1     2 Width 3ft   5991827.84816 2097768.2699700003 37.7396022020835 -122.47082108403099 (37.7396022020835, -122.470821084031)
78673 40783 1 45 410 Monticello St 1 1 1 1 1 08/16/1999 12:00:00 AM     Permit Number 41739 5991762.23808711 2091284.45671221 37.7217954779898 -122.470575817994 (37.7217954779898, -122.470575817994)
89337 40785 1 45 410 Monticello St 3 1 1 1 1 08/16/1999 12:00:00 AM     Permit Number 41739 5991762.23808711 2091284.45671221 37.7217954779898 -122.470575817994 (37.7217954779898, -122.470575817994)
96644 40784 1 45 410 Monticello St 2 1 1 1 1 08/16/1999 12:00:00 AM     Permit Number 41739 5991762.23808711 2091284.45671221 37.7217954779898 -122.470575817994 (37.7217954779898, -122.470575817994)
122873 40786 1 45 410 Monticello St 4 1 1 1 1 08/16/1999 12:00:00 AM     Permit Number 41739 5991762.23808711 2091284.45671221 37.7217954779898 -122.470575817994 (37.7217954779898, -122.470575817994)
32460 214016 2 45 1310 Funston Ave 1 1 1 1     4 Width 3ft   5992104.55451 2106488.0935299997 37.7635605748926 -122.47049926614099 (37.7635605748926, -122.470499266141)
172827 214015 2 45 1326 Funston Ave 1 1 1 1     13 Width 3ft   5992108.78084 2106403.01661 37.763327220596 -122.470478452218 (37.763327220596, -122.470478452218)
28149 214012 2 45 1479 Funston Ave 2 1 1 1     2 Width 2ft   5992097.0420699995 2105377.93896 37.7605119495939 -122.47044439308998 (37.7605119495939, -122.47044439309)
129970 214013 2 45 1483 Funston Ave 1 1 1 1     2 Width 2ft   5992099.86454 2105356.08672 37.760452112299795 -122.47043304005899 (37.7604521122998, -122.470433040059)
174298 214014 2 45 1462 Funston Ave 1 1 1 1     4 Width 3ft   5992138.117459999 2105483.85764 37.7608051492715 -122.47031004699 (37.7608051492715, -122.47031004699)
141966 69085 1 45 1462 Funston Ave 1 1 1 1 1 01/10/1994 12:00:00 AM     Permit Number 33095 5992142.99696903 2105491.66018597 37.7608268551195 -122.470293739312 (37.7608268551195, -122.470293739312)
90488 57281 1 45 2469 14th Ave 1 1 1 1 1 10/14/1995 12:00:00 AM     Permit Number 14578 5992015.46997478 2098642.50003897 37.7420134642029 -122.470236020298 (37.7420134642029, -122.470236020298)
99110 38000 1 45 2454 14th Ave 1 1 1 1 1 07/08/1998 12:00:00 AM     Permit Number 40212 5992064.31245936 2098735.51233127 37.742271675931896 -122.47007391125601 (37.7422716759319, -122.470073911256)
106143 87075 1 45 395 Byxbee St 6 8 1 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
111937 87074 1 45 395 Byxbee St 5 8 1 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
157585 37646 1 45 1001 Balboa St 2 1 1 1   06/26/1998 12:00:00 AM 2   Permit Number 40060 5992418.62314 2111328.39102 37.7768688906569 -122.46976542425399 (37.7768688906569, -122.469765424254)
73555 37647 1 45 1001 Balboa St 3 1 1 1   06/26/1998 12:00:00 AM 2   Permit Number 40060 5992426.792 2111328.0458 37.7768684149352 -122.469737140808 (37.7768684149352, -122.469737140808)
54318 37648 1 45 1001 Balboa St 4 1 1 1   06/26/1998 12:00:00 AM 2   Permit Number 40060 5992433.05565 2111328.08721 37.776868890669206 -122.46971547615499 (37.7768688906692, -122.469715476155)
75103 124546 2 45 1001 Balboa St 6 1 1 1     2 Width 2ft   5992441.4203 2111328.77742 37.7768712692618 -122.469686590816 (37.7768712692618, -122.469686590816)
80857 38028 1 45 2490X 14th Ave 2 1 1 1   07/10/1998 12:00:00 AM     Permit Number 40235 5992179.14418088 2098457.94829189 37.7415161934278 -122.46965666006399 (37.7415161934278, -122.469656660064)
128574 38029 1 45 2490X 14th Ave 1 1 1 1 1 07/10/1998 12:00:00 AM     Permit Number 40235 5992179.14418088 2098457.94829189 37.7415161934278 -122.46965666006399 (37.7415161934278, -122.469656660064)
161297 124545 2 45 1001 Balboa St 7 1 1 1     2 Width 2ft   5992450.310319999 2111329.62958 37.776874122883 -122.46965589986999 (37.776874122883, -122.46965589987)
27483 124544 2 45 1001 Balboa St 9 1 1 1     2 Width 2ft   5992459.19305 2111330.13563 37.7768760257506 -122.46962520893801 (37.7768760257506, -122.469625208938)
35338 124543 2 45 1001 Balboa St 11 1 1 1     2 Width 2ft   5992464.59444 2111330.54171 37.776877452914206 -122.46960655362801 (37.7768774529142, -122.469606553628)
169776 124542 2 45 1001 Balboa St 12 1 1 1     2 Width 2ft   5992469.9646 2111331.12947 37.776879377114 -122.46958801958 (37.776879377114, -122.46958801958)
37135 124541 2 45 1001 Balboa St 13 1 1 1     2 Width 2ft   5992474.53157 2111331.5451 37.7768807822685 -122.46957225145 (37.7768807822685, -122.46957225145)
116845 48626 1 45 1648 12th Ave 1 1 1 1 1 08/30/2002 12:00:00 AM     Permit Number 45923 5992496.87532412 2104233.57360814 37.757392932598 -122.468978283216 (37.757392932598, -122.468978283216)
177864 214036 2 45 262 Ralston St 1 4 1 1     7 Width 3ft   5992219.26388 2089623.39625 37.7172610279406 -122.46887519663 (37.7172610279406, -122.46887519663)
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)
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)
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)
17788 18608 1 45 550 Randolph St 1 1 1 1   01/03/1997 12:00:00 AM 6 3X3   5992502.2173 2088557.38 37.7143503484358 -122.467819678694 (37.7143503484358, -122.467819678694)
21649 18607 1 45 530 Randolph St 1 1 1 1   07/26/1996 12:00:00 AM 6 3x3   5992558.0676 2088557.0731 37.7143527306111 -122.467626617395 (37.7143527306111, -122.467626617395)
188758 217581 2 45 500 Randolph St 2 1 1 1     4 Width 0ft   5992611.7697 2088555.8456 37.714352460703104 -122.467440914144 (37.7143524607031, -122.467440914144)
113563 18603 3 45 520 Randolph St 1 1 1 2   07/25/1996 12:00:00 AM 6 3X3   5992619.61154 2088559.40218 37.7143626789426 -122.467414068351 (37.7143626789426, -122.467414068351)
110717 93721 1 45 1434 Portola Dr 1 1 1 1   03/24/2010 12:00:00 AM   3x3 Permit Number 53312 5992899.8 2097399.6 37.73865186152071 -122.467087971441 (37.7386518615207, -122.467087971441)
143761 93722 1 45 1434 Portola Dr 2 1 1 1   03/24/2010 12:00:00 AM   3x3 Permit Number 53312 5992899.8 2097399.6 37.73865186152071 -122.467087971441 (37.7386518615207, -122.467087971441)
18385 25468 3 45 437 Randolph St 1 1 1 2   07/26/1996 12:00:00 AM 6 3X3   5992774.4094 2088493.0908 37.7141895393891 -122.466874212626 (37.7141895393891, -122.466874212626)
17486 18596 1 45 409 Randolph St 1 1 1 1   07/26/1996 12:00:00 AM 6 3X3   5992903.2652 2088492.7734 37.7141961040887 -122.46642881780501 (37.7141961040887, -122.466428817805)
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)
170758 207053 2 45 1266 09th Ave 3 1 1 1     2 Width 2ft   5993333.09346 2106842.13123 37.76460362927371 -122.46627590500499 (37.7646036292737, -122.466275905005)
66593 207054 2 45 1266 09th Ave 4 1 1 1     2 Width 2ft   5993334.80991 2106859.56975 37.7646516098981 -122.466271235742 (37.7646516098981, -122.466271235742)
34981 207052 2 45 1266 09th Ave 2 1 1 1     2 Width 2ft   5993336.085580001 2106823.92199 37.7645538041289 -122.46626423270901 (37.7645538041289, -122.466264232709)
135936 214037 2 45 510 Ramsell St 1 9 1 1     8 Width 5ft   5993017.248790001 2090566.81293 37.719897493047704 -122.466185481793 (37.7198974930477, -122.466185481793)
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)
74280 217578 2 45 308 Randolph St 1 1 1 1     6 Width 0ft   5993138.4427 2088550.8537 37.7143691463099 -122.46562017697799 (37.7143691463099, -122.465620176978)
105407 25463 1 45 308 Randolph St 2 1 1 1   02/10/1998 12:00:00 AM 3 3X3   5993157.11936 2088546.32287 37.714357782974204 -122.46555529463001 (37.7143577829742, -122.46555529463)
129548 214017 2 45 1438 08th Ave 1 1 1 1     3 Width 3ft   5993685.58433 2105688.82171 37.761457274651605 -122.464972976223 (37.7614572746516, -122.464972976223)
109001 55144 1 45 1438 08th Ave 1 1 1 1 1 12/03/1995 12:00:00 AM     Permit Number 11048 5993686.04342696 2105701.01392221 37.7614907777587 -122.46497227391501 (37.7614907777587, -122.464972273915)
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)
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)
121149 84942 1 45 1315 07th Ave 2 1 1 1   06/06/2007 12:00:00 AM     Permit Number 49348 5993891.7 2106504.6 37.7637090714706 -122.46431934241699 (37.7637090714706, -122.464319342417)
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)
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)
19205 17244 1 45 10X Randolph St 2 1 1 1   03/08/2005 12:00:00 AM 6 3X3   5993945.3779 2088542.9193 37.7143938707274 -122.462830535838 (37.7143938707274, -122.462830535838)
126722 34910 1 45 234 Orizaba Ave 1 1 1 1   09/23/1997 12:00:00 AM     Permit Number 38511 5994034.02525385 2087990.46611796 37.712882070912 -122.462484089909 (37.712882070912, -122.462484089909)
17804 26068 1 45 282 Orizaba Ave 1 1 1 1   02/27/2003 12:00:00 AM 3 2X3   5994051.2236 2088339.7969 37.7138422407476 -122.46244996961 (37.7138422407476, -122.46244996961)
18943 26157 1 45 260 Orizaba Ave 1 1 1 1   06/27/1997 12:00:00 AM 3 3X3   5994051.6997 2088243.7899 37.713578655736 -122.462441364614 (37.713578655736, -122.462441364614)
95726 23598 3 45 200X Vasquez Ave 10 11 1 2     12 60   5994426.954874 2098963.765109 37.7430347013579 -122.46192122709499 (37.7430347013579, -122.461921227095)
116556 23599 3 45 200X Vasquez Ave 9 11 1 2     12 60   5994426.954874 2098963.765109 37.7430347013579 -122.46192122709499 (37.7430347013579, -122.461921227095)
171501 214019 2 45 112 Dorado Ter 1 1 1 1     4 Width 2ft   5994645.417119999 2093146.00663 37.7270731423102 -122.460744326189 (37.7270731423102, -122.460744326189)
29438 31973 1 45 100 02nd Ave 2 1 1 1 1 06/30/1995 12:00:00 AM 5   Permit Number 35372 5995224.68838 2114814.58842 37.7866028473263 -122.460311111336 (37.7866028473263, -122.460311111336)
34675 31971 1 45 100 02nd Ave 3 1 1 1 1 06/30/1995 12:00:00 AM 9   Permit Number 35372 5995225.90281 2114852.20624 37.786706205556 -122.46030963631 (37.786706205556, -122.46030963631)
29132 31972 1 45 100 02nd Ave 1 1 1 1 1 06/30/1995 12:00:00 AM 5   Permit Number 35372 5995228.46958 2114784.79077 37.786521248530995 -122.46029586964701 (37.786521248531, -122.460295869647)
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)
54142 38882 1 45 101 Commonwealth Ave 3 1 1 1 1 11/02/1998 12:00:00 AM     Permit Number 40703 5996508.72142362 2113802.71293841 37.7838982845648 -122.455795523067 (37.7838982845648, -122.455795523067)
83881 38883 1 45 101 Commonwealth Ave 4 1 1 1 1 11/02/1998 12:00:00 AM     Permit Number 40703 5996508.72142362 2113802.71293841 37.7838982845648 -122.455795523067 (37.7838982845648, -122.455795523067)
101850 38881 1 45 101 Commonwealth Ave 1 1 1 1 1 11/02/1998 12:00:00 AM     Permit Number 40703 5996508.72142362 2113802.71293841 37.7838982845648 -122.455795523067 (37.7838982845648, -122.455795523067)
77080 38895 1 45 123 Parker Ave 1 1 1 1 1 11/02/1998 12:00:00 AM 4   Permit Number 40710 5996840.66245358 2113625.05698332 37.7834295330259 -122.454634297306 (37.7834295330259, -122.454634297306)
153152 141053 2 45 196 PARKER AVE 2 1 1 1     2 Width 0ft   5996969.9558 2113061.6744 37.781890048327206 -122.45414629097999 (37.7818900483272, -122.45414629098)
168439 141052 2 45 196 PARKER AVE 1 1 1 1     1 Width 0ft   5996973.34 2113043.0612 37.7818391354491 -122.454133238512 (37.7818391354491, -122.454133238512)
159069 72309 2 45 3555 Jackson St 1 1 1 1 1 02/10/1996 12:00:00 AM 4     5997281.41005 2116017.68654 37.7900243276015 -122.45328228245701 (37.7900243276015, -122.453282282457)
Powered by Datasette · Query took 6.715ms · Data source: data.sfgov.org