sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
89600 103266 2 1 2365 UNION ST 2 1 1 1       3x3   6001713.0 2118319.0 37.796596142729896 -122.43811430510799 (37.7965961427299, -122.438114305108)
90341 52736 1 1 475@ STILLMAN 04th St 6 1 1 1   04/26/2006 12:00:00 AM     Permit Number 48788 6013076.05424861 2112001.40957779 37.7798891948269 -122.39835185397301 (37.7798891948269, -122.398351853973)
90642 108476 2 1 1201X 19th Ave 2 5 1 1         Permit Number 774311 5990125.2811900005 2107203.87819 37.7654112822972 -122.477397189068 (37.7654112822972, -122.477397189068)
90877 109386 2 1 300X BAKER ST 1 1 1 1       3x3   6000704.0 2110147.0 37.7741005029649 -122.441019094263 (37.7741005029649, -122.441019094263)
90890 44755 1 1 256 Pennsylvania Ave 1 1 1 1   04/06/2001 12:00:00 AM     Permit Number 43869 6014282.34232981 2105939.88092695 37.7633127092766 -122.39375434301 (37.7633127092766, -122.39375434301)
90930 121191 6 1 1000x Duncan St 12 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
91286 94498 1 1 1600X Page St 3 1 1 1   12/30/2015 12:00:00 AM   7x7   5998899.3 2109049.0 37.770982719767794 -122.44718280302601 (37.7709827197678, -122.447182803026)
91357 49091 1 1 101 Athens St 2 1 1 1         Permit Number 46240 6005012.04174128 2092633.4383737 37.7262567475706 -122.424870568097 (37.7262567475706, -122.424870568097)
91506 121193 6 1 1000x Duncan St 14 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
91613 88453 6 1 2801 Oakdale Ave 2 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
91621 110056 1 1 490 Jamestown Ave   1 1 1       3x3   6016119.9 2086810.2 37.7108884169699 -122.38606516043899 (37.7108884169699, -122.386065160439)
91684 32012 1 1 196 Casitas Ave 2 1 1 1         Permit Number 35406 5994862.5482333 2097095.53050341 37.7379300603176 -122.460279744028 (37.7379300603176, -122.460279744028)
91834 117602 2 1 3749 CLEMENT ST 1 1 1 1       3x3   5983838.0 2113090.0 37.781206058559704 -122.499578155566 (37.7812060585597, -122.499578155566)
92083 38475 1 1 162 Concord St 1 1 1 1 1 08/21/1998 12:00:00 AM     Permit Number 40476 5999822.84916102 2087316.82231241 37.7113640595721 -122.44242775396002 (37.7113640595721, -122.44242775396)
92138 101902 1 1 1100 Ocean Ave 3 7 1 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
92220 116215 2 1 3801 SACRAMENTO ST 7 1 1 1       3x3   5996623.0 2114922.0 37.7869781063352 -122.45548108802099 (37.7869781063352, -122.455481088021)
92242 33912 1 1 665 Alvarado St 1 1 1 1 1 11/02/2002 12:00:00 AM     Permit Number 37882 6002076.88418057 2102621.6953038997 37.753515953271496 -122.435731542402 (37.7535159532715, -122.435731542402)
92497 99770 2 1 1025x Douglass St 1 1 1 1       3x3 595 Clipper St is true property address 6001337.9 2100792.7 37.7484519666196 -122.438156093062 (37.7484519666196, -122.438156093062)
93052 107928 1 1 495 09th Ave 11 1 1 1       3x3 Permit Number 774012 5993087.78951 2112168.6283400003 37.7792146104853 -122.467511711649 (37.7792146104853, -122.467511711649)
93067 122490 2 1 69x Bonview St 6 1 1 2       3x3   6007716.0 2099172.0 37.7443625662885 -122.415985930063 (37.7443625662885, -122.415985930063)
93201 113412 2 1 1672 16TH AVE 1 1 1 1       3x3   5991218.0 2103997.0 37.7566693908752 -122.47338384272499 (37.7566693908752, -122.473383842725)
93352 112398 6 1 246 CRESCENT AVE 1 2 1 1           6006552.0 2095759.0 37.7349257177289 -122.419768681192 (37.7349257177289, -122.419768681192)
93516 121154 2 1 50X Trumbull St 3 1 1 1       3x3 Permit Number 778630 6003754.0 2094198.0 37.730481544978794 -122.429331070998 (37.7304815449788, -122.429331070998)
93562 110425 2 1 81 DORMAN AVE 1 1 1 1       27x18   6011518.0 2097294.0 37.7394190054764 -122.402707291584 (37.7394190054764, -122.402707291584)
93687 112450 2 1 254 CENTRAL AVE 6 1 1 1       3x3   5999892.0 2109423.0 37.772066299939205 -122.443775909671 (37.7720662999392, -122.443775909671)
94216 100680 2 1 387 Beacon St   8 1 1         7' wide public RoW 6002378.0 2098199.0 37.7413893731095 -122.434374040118 (37.7413893731095, -122.434374040118)
94344 114062 2 1 898x ELIZABETH ST 1 1 1 1   01/11/2016 12:00:00 AM   3x3 Permit Number 777118 6000938.0 2102006.0 37.751760645744206 -122.439625904919 (37.7517606457442, -122.439625904919)
94621 118324 2 1 200x TARAVAL ST 2 1 1 1       3x3   5992604.0 2099181.0 37.7435260562612 -122.4682402545 (37.7435260562612, -122.4682402545)
94966 113130 2 1 1x TOMASO CT 18 9 1 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
95231 113127 2 1 1x TOMASO CT 15 9 1 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
95270 121186 6 1 1000x Duncan St 7 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
95589 119627 2 1 1 El Sereno Ct 1 1 1 1       3x3   5999504.0 2097253.0 37.738628328633396 -122.44424333392901 (37.7386283286334, -122.444243333929)
95654 112156 2 1 501 SANCHEZ ST 3 1 1 1           6003633.0 2105226.0 37.7607550226872 -122.43053597282899 (37.7607550226872, -122.430535972829)
95751 110523 2 1 57 DOUGLASS ST 1 1 1 1       3x3 Permit Number 775559 6001085.0 2106026.0 37.762806954373104 -122.439405692132 (37.7628069543731, -122.439405692132)
95894 107924 1 1 495 09th Ave 7 1 1 1       3x3 Permit Number 774012 5993087.78951 2112168.6283400003 37.7792146104853 -122.467511711649 (37.7792146104853, -122.467511711649)
95978 38435 1 1 950 Noe St 1 1 1 1   08/19/1998 12:00:00 AM     Permit Number 40462 6003103.32448359 2102701.71275072 37.7537939125694 -122.43218760661101 (37.7537939125694, -122.432187606611)
96239 115665 2 1 601x PERU AVE 3 14 1 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
96471 56770 1 1 249 Hoffman Ave 1 1 1 1   01/11/2016 12:00:00 AM     Permit Number 777118 6000646.04543173 2102139.76865728 37.752111320918495 -122.440645114373 (37.7521113209185, -122.440645114373)
96661 110424 2 1 65 DORMAN AVE 1 1 1 1       27x18   6011494.0 2097294.0 37.739417665451604 -122.402790273501 (37.7394176654516, -122.402790273501)
96875 113665 2 1 1435 17TH ST 1 1 1 1       3x3   6013045.0 2106578.0 37.7649960058226 -122.39807870262501 (37.7649960058226, -122.398078702625)
96955 41426 1 1 3901 19th St 2 1 1 1 1 11/02/2002 12:00:00 AM     Permit Number 42033 6003639.60917921 2104762.31302618 37.759482223502395 -122.430480029002 (37.7594822235024, -122.430480029002)
97056 89006 1 1 2200 Webster St 1 1 1 1       3x3 Permit Number 51758 6003287.9 2116231.2 37.7909530209385 -122.432515604779 (37.7909530209385, -122.432515604779)
97479 111154 2 1 201x EUGENIA AVE 1 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
98353 106558 2 1 1606 12th Ave 1 1 1 1       4x4   5992507.7 2104492.6 37.7581047767682 -122.468959697438 (37.7581047767682, -122.468959697438)
98436 110381 2 1 2235 PALOU AVE 1 1 1 1       27x18   6011689.0 2097713.0 37.740579036374 -122.402145495204 (37.740579036374, -122.402145495204)
98529 99778 2 1 492x Jersey St 3 1 1 1       3x3 492-494x Jersey corner property at 845-849 Diamond St 6001966.3 2101499.0 37.7504270178067 -122.43603363507799 (37.7504270178067, -122.436033635078)
98601 101269 2 1 2240 Irving St 3 1 1 1       3x3   5988822.0 2106507.0 37.763422136616 -122.48185383449301 (37.763422136616, -122.481853834493)
98813 106448 2 1 999 Fell St 2 1 1 1           6002658.0 2110219.0 37.7744092970816 -122.43426502395701 (37.7744092970816, -122.434265023957)
98878 121566 2 1 740 Church St 2 1 1 1       3x3   6004294.0 2104553.0 37.7589445476691 -122.42820190474801 (37.7589445476691, -122.428201904748)
99055 98374 2 1 106 De Soto St 1 9 1 1           5993231.0 2091825.0 37.7233644995117 -122.465537980019 (37.7233644995117, -122.465537980019)
100025 121675 1 1 365 San Leandro Way 2 1 1 1           5992325.42312898 2094471.30725357 37.7305783328736 -122.46886084210199 (37.7305783328736, -122.468860842102)
100041 113128 2 1 1x TOMASO CT 16 9 1 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
100068 111158 2 1 201x EUGENIA AVE 5 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
100581 108317 2 1 1795 Lincoln Way 2 5 1 1           5990313.88148 2107203.45347 37.765421057721795 -122.476744840008 (37.7654210577218, -122.476744840008)
100877 34518 1 1 201 Stillings Ave 3 1 1 1   07/17/1997 12:00:00 AM     Permit Number 38229 5999437.15230869 2095745.6775321 37.7344857636851 -122.44436616674601 (37.7344857636851, -122.444366166746)
100978 121192 6 1 1000x Duncan St 13 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
101670 121384 2 1 825 Lincoln Way 4 1 1 1       3x3   5993159.0 2107262.0 37.7657464318194 -122.466908568463 (37.7657464318194, -122.466908568463)
101700 86749 1 1 81 Parker Ave   1 1 1         Permit Number 49713 5996801.8 2114038.7 37.7845630578844 -122.454798641129 (37.7845630578844, -122.454798641129)
102210 100310 1 1 3899 Washington St 2 1 1 1           5996194.7 2115482.8 37.7884933268854 -122.457003479054 (37.7884933268854, -122.457003479054)
102326 104898 6 1 310 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
102337 122407 2 1 801X Detroit St 1 1 1 1       3x3   5999408.0 2095548.0 37.7339413243955 -122.444452753551 (37.7339413243955, -122.444452753551)
102571 101276 2 1 2350 Irving St 3 1 1 1       3x3   5988480.0 2106495.0 37.763369292926996 -122.483035808211 (37.763369292927, -122.483035808211)
102605 121181 6 1 1000x Duncan St 2 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
102722 95195 1 1 254 29th Ave 1 2 1 1   01/14/2011 12:00:00 AM     Permit Number 767109 5986864.6 2114238.7 37.7845371806063 -122.489192237355 (37.7845371806063, -122.489192237355)
102848 115367 2 1 81 ELSIE ST 1 1 1 1       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
103613 34289 1 1 2715 Lake St 1 1 1 1 1 07/14/1997 12:00:00 AM     Permit Number 38080 5987074.67438797 2114433.79174181 37.7850851064396 -122.488479804204 (37.7850851064396, -122.488479804204)
103706 34223 1 1 4353 25th St 1 1 1 1   06/19/1997 12:00:00 AM     Permit Number 38036 6001597.05586573 2101140.27274833 37.7494210542971 -122.43728482259199 (37.7494210542971, -122.437284822592)
104063 110422 2 1 50 DORMAN AVE 1 1 1 1       27x18   6011337.0 2097400.0 37.739699951422 -122.403340568471 (37.739699951422, -122.403340568471)
104139 87677 1 1 651 Upland Dr 2 1 1 1   05/23/2008 12:00:00 AM   3x3 Permit Number 50398 5992947.0 2094378.0 37.7303580257382 -122.46670519643499 (37.7303580257382, -122.466705196435)
104451 44044 1 1 15 Prospect Ave 1 1 1 1   10/11/2000 12:00:00 AM   3x3 Permit Number 52166 6007300.39530105 2099500.4637239 37.7452410789231 -122.417446281159 (37.7452410789231, -122.417446281159)
104528 39968 1 1 20 Rosewood Dr 1 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41229 5994642.74946915 2095844.31987513 37.7344818986137 -122.460949031683 (37.7344818986137, -122.460949031683)
104617 121185 6 1 1000x Duncan St 6 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
104770 108475 2 1 1201X 19th Ave 1 5 1 1         Permit Number 774311 5990125.2811900005 2107203.87819 37.7654112822972 -122.477397189068 (37.7654112822972, -122.477397189068)
104788 121183 6 1 1000x Duncan St 4 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
105114 113094 2 1 5725 DIAMOND HEIGHTS BLVD 1 1 1 1   12/02/2015 12:00:00 AM   3x3 Permit Number 776952 6000738.0 2097078.0 37.7382181444182 -122.43996421610001 (37.7382181444182, -122.4399642161)
105330 118323 2 1 200x TARAVAL ST 1 1 1 1       3x3   5992604.0 2099181.0 37.7435260562612 -122.4682402545 (37.7435260562612, -122.4682402545)
105502 98375 2 1 106 De Soto St 2 9 1 1           5993231.0 2091825.0 37.7233644995117 -122.465537980019 (37.7233644995117, -122.465537980019)
105777 101272 2 1 2300 Irving St 1 1 1 1       3x3   5988629.58103 2106495.44667 37.763379222306106 -122.482518495008 (37.7633792223061, -122.482518495008)
105906 121628 2 1 371 Staples Ave 1 1 1 1       3x3   5997638.0 2093763.0 37.7289389875261 -122.450443518449 (37.7289389875261, -122.450443518449)
106252 121596 2 1 998X Elizabeth St 1 1 1 1       3x3   6000144.0 2102038.0 37.7518032865281 -122.44237395255101 (37.7518032865281, -122.442373952551)
106407 88454 6 1 2801 Oakdale Ave 3 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
106527 93736 2 1 201 Central Ave 1 1 1 1           5999812.1 2109210.9 37.771479369328205 -122.44403704657 (37.7714793693282, -122.44403704657)
106634 121195 6 1 255x Red Rock Way 2 7 1 1       3x3 Permit Number 775289 5999917.0 2099808.0 37.7456673038035 -122.442998816589 (37.7456673038035, -122.442998816589)
106681 97654 1 1 2331 47th Ave 1 9 1 1           5981707.8 2099208.6 37.7429664967596 -122.505917998204 (37.7429664967596, -122.505917998204)
106817 55765 1 1 1932 Irving St 1 1 1 1   02/28/1973 12:00:00 AM     Permit Number 11801 5989775.56943078 2106540.70455177 37.7635700889575 -122.478558247096 (37.7635700889575, -122.478558247096)
107126 85498 1 1 1 Nebraska St 1 1 1 1           6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
107866 112769 6 1 1X HOWTH ST 1 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
108027 54458 1 1 4235 24th St 1 1 1 1   06/26/1972 12:00:00 AM     Permit Number 10249 6001672.30868862 2101726.83398167 37.751035889282 -122.437066586385 (37.751035889282, -122.437066586385)
108137 110383 2 1 2280 PALOU AVE 1 1 1 1       27x18   6011419.0 2097963.0 37.741250408777205 -122.40309663685801 (37.7412504087772, -122.403096636858)
108150 52738 1 1 475@ STILLMAN 04th St 4 1 1 1   04/26/2006 12:00:00 AM     Permit Number 48788 6013076.05424861 2112001.40957779 37.7798891948269 -122.39835185397301 (37.7798891948269, -122.398351853973)
108732 121383 2 1 825 Lincoln Way 3 1 1 1       3x3   5993159.0 2107262.0 37.7657464318194 -122.466908568463 (37.7657464318194, -122.466908568463)
108792 52088 1 1 533 Noe St 1 1 1 1         Permit Number 48285 6003018.90245389 2105154.15611633 37.7605229492534 -122.432654727925 (37.7605229492534, -122.432654727925)
109051 33491 1 1 29 Coleridge St 1 1 1 1   08/22/2007 12:00:00 AM     Permit Number 49655 6006996.29665496 2099574.0262700003 37.7454259501675 -122.418503020578 (37.7454259501675, -122.418503020578)
109172 101186 2 1 333 Irving St 1 1 1 1       3x3   5994765.0 2106657.0 37.764177821135995 -122.46130993803499 (37.764177821136, -122.461309938035)
109300 97998 2 1 1450 Mariposa St 4 1 1 1       3x3   6012865.0 2106120.0 37.7637284123596 -122.39866913856501 (37.7637284123596, -122.398669138565)
109409 32427 1 1 1901 Webster St 1 1 1 1   10/09/1996 12:00:00 AM     Permit Number 36954 6003387.68416895 2115217.90617727 37.7881764318356 -122.432097963893 (37.7881764318356, -122.432097963893)
109527 41271 1 1 229 De Montfort Ave 1 1 1 1   12/07/1999 12:00:00 AM     Permit Number 41954 5994679.37055115 2091871.07942789 37.723574453453494 -122.460534605902 (37.7235744534535, -122.460534605902)
109657 98303 6 1 6 Locksley Ave 3 7 1 1           5994194.0 2104902.7 37.7593280901784 -122.463157548093 (37.7593280901784, -122.463157548093)
109788 113131 2 1 1x TOMASO CT 19 9 1 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
109839 113123 2 1 1x TOMASO CT 11 9 1 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
110181 104309 5 1 3747 23RD ST 2 1 1 1       5x5   6004798.0 2102451.0 37.7532014528284 -122.426309178314 (37.7532014528284, -122.426309178314)
Powered by Datasette · Query took 8.802ms · Data source: data.sfgov.org