sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
11534 17549 3 46 600 Persia Ave 1 1 1 2     14 3X3   6003191.593230001 2090648.1169 37.7207025031963 -122.431022127369 (37.7207025031963, -122.431022127369)
11538 17585 3 46 801X Persia Ave 9 1 1 2     18 3x3   6003724.8526 2090366.56287 37.71995962001 -122.429158750084 (37.71995962001, -122.429158750084)
11540 17520 3 46 300X Persia Ave 4 1 1 2   01/20/1998 12:00:00 AM 18 3x3   6002494.3085199995 2091085.91322 37.721865058601296 -122.433463691421 (37.7218650586013, -122.433463691421)
11558 17522 3 46 307 Persia Ave 1 1 1 2     14 3x3   6002546.66743 2091098.28956 37.7219020117492 -122.433283584179 (37.7219020117492, -122.433283584179)
11596 17497 3 46 101 Persia Ave 2 1 1 2     50 2X2   6002079.41309 2091392.13948 37.7226823390961 -122.43491976573401 (37.7226823390961, -122.434919765734)
11600 17581 3 46 801X Persia Ave 5 1 1 2     18 3x3   6003766.7866400005 2090331.9281799998 37.7198668945342 -122.429011330508 (37.7198668945342, -122.429011330508)
11611 17597 3 46 844 Persia Ave 1 1 1 2     18 3x3   6003772.37846 2090279.5258799999 37.71972332585371 -122.428988267402 (37.7197233258537, -122.428988267402)
11682 17519 3 46 300X Persia Ave 3 1 1 2     19 3x3   6002513.47081 2091072.78557 37.721830100172504 -122.433396514735 (37.7218301001725, -122.433396514735)
11871 17518 3 46 300X Persia Ave 2 1 1 2     18 3x3   6002537.724219999 2091058.53445 37.72179234573429 -122.433311659211 (37.7217923457343, -122.433311659211)
11883 17495 3 46 100 Persia Ave 1 1 1 2     20 3X3   6002027.05349 2091378.7208900002 37.722642521627996 -122.43509980193001 (37.722642521628, -122.43509980193)
11929 17621 3 46 1100 Persia Ave 1 1 1 2     10 3X3   6004336.281690001 2089926.3148400001 37.7187853887157 -122.42701391015899 (37.7187853887157, -122.427013910159)
11996 17591 3 46 801X Persia Ave 15 5 1 2     30 3x3   6003659.63671 2090407.2266799998 37.7200675818369 -122.42938707716299 (37.7200675818369, -122.429387077163)
12017 17554 3 46 620 Persia Ave 1 1 1 2     30 3X3   6003227.93089 2090625.05216 37.7206412314956 -122.43089487419901 (37.7206412314956, -122.430894874199)
12027 17535 3 46 501X Persia Ave 1 1 1 2     50 3x3   6003034.530590001 2090798.32089 37.721106028988295 -122.431575761713 (37.7211060289883, -122.431575761713)
12076 17583 3 46 801X Persia Ave 7 1 1 2     12 3x3   6003749.1517199995 2090342.6567099998 37.7198953544779 -122.429073052804 (37.7198953544779, -122.429073052804)
12120 17542 3 46 525 Persia Ave 1 1 1 2   04/29/2011 12:00:00 AM 3 3x3   6003053.24569 2090786.85001 37.7210755932558 -122.43151025062099 (37.7210755932558, -122.431510250621)
12133 17594 3 46 808 Persia Ave 1 1 1 2     35 3x3   6003660.5889 2090352.7029799998 37.719917925661 -122.42937989966002 (37.719917925661, -122.42937989966)
12305 17584 3 46 801X Persia Ave 8 5 1 2     18 3x3   6003740.32149 2090358.06458 37.7199371612464 -122.42910467385201 (37.7199371612464, -122.429104673852)
12309 17496 3 46 101 Persia Ave 1 1 1 2   04/23/2003 12:00:00 AM 3 2X2   6002048.59392 2091411.2062099997 37.7227329421421 -122.43502766371401 (37.7227329421421, -122.435027663714)
12432 17625 3 46 1132 Persia Ave 1 1 1 2     45 3x3   6004425.094930001 2089870.4961599999 37.7186371444562 -122.426702945308 (37.7186371444562, -122.426702945308)
12439 17499 3 46 106 Persia Ave 1 1 1 2   02/21/2008 12:00:00 AM 3 3X3   6002048.76612 2091365.2856599998 37.722606864403296 -122.435023785838 (37.7226068644033, -122.435023785838)
12487 17616 3 46 1030 Persia Ave 1 1 1 2     12 3x3   6004194.38835 2090014.0443400003 37.719018250172 -122.42751062553499 (37.719018250172, -122.427510625535)
12573 17588 3 46 801X Persia Ave 12 1 1 2     30 3x3   6003687.80932 2090380.0219599998 37.7199944786431 -122.429287755146 (37.7199944786431, -122.429287755146)
12598 17596 3 46 822 Persia Ave 1 1 1 2     22 3X3   6003747.6295300005 2090297.4937 37.719771260609996 -122.429075096066 (37.71977126061, -122.429075096066)
12681 17608 3 46 1000X Persia Ave 1 1 1 2   04/26/1999 12:00:00 AM 40 6x9   6004130.9636 2090056.2016 37.7191304172171 -122.427732862395 (37.7191304172171, -122.427732862395)
12693 17579 3 46 801X Persia Ave 3 1 1 2     18 3x3   6003783.82433 2090321.42028 37.7198390065544 -122.428951688396 (37.7198390065544, -122.428951688396)
12701 17544 3 46 537 Persia Ave 1 1 1 2     50 3X3   6003083.60804 2090766.94886 37.7210226699524 -122.431403876997 (37.7210226699524, -122.431403876997)
12769 17578 3 46 801X Persia Ave 2 5 1 2     18 3x3   6003799.63122 2090323.6743700001 37.7198460905006 -122.428897210135 (37.7198460905006, -122.428897210135)
12852 17587 3 46 801X Persia Ave 11 5 1 2     35 3X3   6003703.481380001 2090378.19842 37.7199903588363 -122.42923345225901 (37.7199903588363, -122.429233452259)
12929 17531 3 46 444 Persia Ave 1 1 1 2     18 3X3   6002851.30461 2090860.81338 37.72126723246829 -122.43221358070299 (37.7212672324683, -122.432213580703)
12993 19985 3 46 100 STAIRWAY46 5 1 1 2     3 40            
13029 17562 3 46 645 Persia Ave 1 1 1 2     50 3x3   6003332.52001 2090606.8773 37.72059725284729 -122.43053204633001 (37.7205972528473, -122.43053204633)
13058 17513 3 46 245X Persia Ave 1 1 1 2     18 3x3   6002376.23219 2091204.63173 37.7221843332317 -122.433880332025 (37.7221843332317, -122.433880332025)
13153 17626 3 46 1135 Persia Ave 1 1 1 2     50 3X3   6004454.014359999 2089904.4684 37.718732059816205 -122.42660540034099 (37.7187320598162, -122.426605400341)
13173 17514 3 46 245X Persia Ave 2 1 1 2     18 3x3   6002400.99383 2091189.1997099998 37.7221433654964 -122.433793634664 (37.7221433654964, -122.433793634664)
13231 17623 3 46 1101 Persia Ave 1 1 1 2     35 3X3   6004371.84322 2089954.8563599999 37.718865768324 -122.426893019707 (37.718865768324, -122.426893019707)
13417 85790 3 46 1125 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6010146.2096 2110708.8868 37.776176587646 -122.408396338404 (37.776176587646, -122.408396338404)
13491 85780 3 46 1301 Folsom St 3 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6009172.9261 2109780.9319 37.7735740897245 -122.41169762032699 (37.7735740897245, -122.411697620327)
13679 100568 3 46 868 Folsom St 2 1 1 2     3 3x3   6011788.1802 2112369.4793 37.780828003664 -122.40283310111 (37.780828003664, -122.40283310111)
13722 91035 3 46 1051X Folsom St 5 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6010666.0508 2111208.1223 37.7775764693736 -122.40663324749599 (37.7775764693736, -122.406633247496)
13882 85775 3 46 1501 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6008458.3046 2109095.9531 37.771653185278396 -122.41412114139999 (37.7716531852784, -122.4141211414)
13974 97229 3 46 1301X Newcomb Ave 9 11 1 2     28 15x200   6016636.9425099995 2094930.8404400002 37.7332147213866 -122.38484348356701 (37.7332147213866, -122.384843483567)
14093 97435 3 46 1300x Newcomb Ave 4 11 1 2   09/30/2011 12:00:00 AM 3     6016490.8874 2094837.7533 37.732951043415206 -122.385341956131 (37.7329510434152, -122.385341956131)
14176 49606 3 46 1245 Folsom St 1 1 1 2   05/13/2003 12:00:00 AM 3 3x3 Permit Number 46474 6009457.5009 2110055.1245 37.7743429180698 -122.410732597335 (37.7743429180698, -122.410732597335)
14203 85766 3 46 1400X Folsom St 1 1 1 2   01/11/2012 12:00:00 AM 3 3x3   6008764.4124 2109484.6384 37.772737612649706 -122.41308978059901 (37.7727376126497, -122.413089780599)
14251 85786 3 46 1211 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6009596.5259 2110188.4047 37.7747166682516 -122.410261094209 (37.7747166682516, -122.410261094209)
14305 85794 3 46 1001 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6010934.7813 2111463.5411 37.778292821216 -122.405721608986 (37.778292821216, -122.405721608986)
14375 85777 3 46 1355 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6008992.8894 2109607.7576 37.773088492602795 -122.412308154132 (37.7730884926028, -122.412308154132)
14561 7568 3 46 2941 Folsom St 1 1 1 2     18 3x3   6008397.77442 2101269.6431 37.7501605343002 -122.413776835747 (37.7501605343002, -122.413776835747)
14696 85756 3 46 956 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6011236.2364 2111841.2613 37.779346806168704 -122.404705356954 (37.7793468061687, -122.404705356954)
14758 85855 3 46 1530 Folsom St 1 1 1 2   05/21/2007 12:00:00 AM 3 3x3   6008286.9019 2109012.2565 37.771413745293 -122.41470811142099 (37.771413745293, -122.414708111421)
14760 91037 3 46 1051X Folsom St 7 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6010705.7086 2111246.6708 37.7776845332645 -122.40649877417499 (37.7776845332645, -122.406498774175)
14902 85761 3 46 1228 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6009463.2457 2110145.8929 37.7745924689532 -122.41071913644501 (37.7745924689532, -122.410719136445)
15023 97221 3 46 1301X Newcomb Ave 1 11 1 2     5 15x200   6016689.53805 2094986.8063299998 37.733371301443 -122.38466554190701 (37.733371301443, -122.384665541907)
15087 91034 3 46 1051X Folsom St 4 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6010653.2937 2111194.8106 37.7775392048064 -122.406676440472 (37.7775392048064, -122.406676440472)
15095 85799 3 46 951 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6011299.4671 2111813.5286 37.779274192475796 -122.404484661651 (37.7792741924758, -122.404484661651)
15191 28961 3 46 207 09th St 1 1 1 2   07/02/2011 12:00:00 AM 3 3x3   6008851.69192 2110257.83982 37.77486554133821 -122.412842545373 (37.7748655413382, -122.412842545373)
15203 91033 3 46 1051X Folsom St 3 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6010628.8889 2111172.6244 37.777476921213605 -122.40675930128401 (37.7774769212136, -122.406759301284)
15259 85857 3 46 1530 Folsom St 3 1 1 2   05/21/2007 12:00:00 AM 3 3x3   6008243.2994 2108951.1128 37.771243409160206 -122.414854606958 (37.7712434091602, -122.414854606958)
15284 91036 3 46 1051X Folsom St 6 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6010688.5143 2111227.8126 37.7776317911098 -122.406556926191 (37.7776317911098, -122.406556926191)
15402 85743 3 46 850 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6011909.0687 2112486.2465 37.7811553685168 -122.402423099291 (37.7811553685168, -122.402423099291)
15416 85854 3 46 858 Folsom St 1 1 1 2   05/21/2007 12:00:00 AM 3 3x3   6011861.9039 2112442.745 37.7810332904479 -122.40258320702299 (37.7810332904479, -122.402583207023)
15524 85858 3 46 1608 Folsom St 1 1 1 2   05/21/2007 12:00:00 AM 8 3x3   6008131.7874 2108761.9182 37.770717658851396 -122.41522693781499 (37.7707176588514, -122.415226937815)
15530 85744 3 46 868 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6011811.5337 2112389.6274 37.780884629613 -122.402753726875 (37.780884629613, -122.402753726875)
15618 49607 3 46 1245 Folsom St 2 1 1 2   05/13/2003 12:00:00 AM 3 3x3 Permit Number 46474 6009479.3313 2110073.508 37.7743946188288 -122.41065838012199 (37.7743946188288, -122.410658380122)
15742 85781 3 46 1285 Folsom St 1 1 1 2   02/21/2012 12:00:00 AM 3 3x3   6009302.3903 2109906.9077 37.773927251443205 -122.411258683374 (37.7739272514432, -122.411258683374)
15785 85778 3 46 1301 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6009142.6509 2109745.8127 37.7734759622446 -122.41179986511601 (37.7734759622446, -122.411799865116)
15899 22327 3 46 5155 03rd St 2 1 1 2     12 3X3   6014617.6908 2094280.6281 37.7313174804906 -122.39177919347401 (37.7313174804906, -122.391779193474)
15940 97233 3 46 1300X Newcomb Ave 13 11 1 2     6 15x200   6016357.8982 2094854.1147 37.7329886101989 -122.385802878589 (37.7329886101989, -122.385802878589)
15989 7405 3 46 1065 Folsom St 1 1 1 2   12/15/1998 12:00:00 AM 6 3X3   6010535.4473 2111084.5056 37.7772297388865 -122.407076335552 (37.7772297388865, -122.407076335552)
16092 85760 3 46 1196 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6009690.0521 2110363.0901 37.7752015556324 -122.40994990092399 (37.7752015556324, -122.409949900924)
16136 85809 3 46 875 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 4 3x3   6011790.9277 2112282.0183 37.78058800949079 -122.402817443224 (37.7805880094908, -122.402817443224)
16163 26637 3 46 400X Winfield St 1 1 1 2   02/12/1998 12:00:00 AM 6 3X3            
16241 91032 3 46 1051X Folsom St 2 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6010616.6864 2111159.8673 37.777441210433395 -122.40680061468099 (37.7774412104334, -122.406800614681)
16302 85797 3 46 969 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6011197.4105 2111716.4639 37.779001971452395 -122.40483088408399 (37.7790019714524, -122.404830884084)
16370 85856 3 46 1530 Folsom St 2 1 1 2   05/21/2007 12:00:00 AM 3 3x3   6008268.3583 2108979.6799 37.7713232557148 -122.414769948978 (37.7713232557148, -122.414769948978)
16507 85757 3 46 960 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6011195.1919 2111802.9901 37.7792394282463 -122.404844652616 (37.7792394282463, -122.404844652616)
16587 103753 3 46 1615 Folsom St 1 1 1 2   05/04/2007 12:00:00 AM 3 3x3   6008187.9193 2108722.8263 37.7706134761345 -122.415030008645 (37.7706134761345, -122.415030008645)
16597 97225 3 46 1301X Newcomb Ave 5 11 1 2   09/30/2011 12:00:00 AM 3 15x200   6016649.85073 2094946.9135099999 37.7332595687675 -122.38479997523599 (37.7332595687675, -122.384799975236)
16758 85768 3 46 1400X Folsom St 3 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6008662.6876 2109384.932 37.772458131185104 -122.41343460643999 (37.7724581311851, -122.41343460644)
16759 26628 3 46 1099X Bay Shore Blvd 1 1 1 2   03/05/2003 12:00:00 AM 3 3X3   6011258.58098 2094170.8511 37.7308290106415 -122.403384596621 (37.7308290106415, -122.403384596621)
16950 25174 3 46 3062 Market St 2 1 1 2     100 3X3   6000130.8652 2105433.23803 37.761125030928895 -122.44266313540199 (37.7611250309289, -122.442663135402)
17012 7531 3 46 2829 Folsom St 1 1 1 2     60 3x3   6008362.05512 2101958.45001 37.752049837241 -122.41394907658702 (37.752049837241, -122.413949076587)
17173 7598 3 46 3106 Folsom St 2 1 1 2     45 3X3   6008393.64019 2100437.22493 37.7478746680801 -122.41373225995702 (37.7478746680801, -122.413732259957)
17189 7579 3 46 2995 Folsom St 1 1 1 2     60 4x4   6008416.03486 2101001.24422 37.7494245965646 -122.41369470787 (37.7494245965646, -122.41369470787)
17190 7561 3 46 2921 Folsom St 1 1 1 2     60 4X4   6008393.481319999 2101389.9459599997 37.750490617869296 -122.41380019023899 (37.7504906178693, -122.413800190239)
17202 7497 3 46 2700 Folsom St 1 1 1 2     60 3X3   6008270.16145 2102659.31707 37.753969098407005 -122.41431644427401 (37.753969098407, -122.414316444274)
17228 23635 3 46 108 Virginia Ave 1 1 1 2     18 5x5   6006522.04559 2098512.21616 37.742483748623 -122.420067568263 (37.742483748623, -122.420067568263)
17323 7553 3 46 2896 Folsom St 1 1 1 2     2 3X3   6008325.6957 2101595.54831 37.751051348745996 -122.41404914235001 (37.751051348746, -122.41404914235)
17325 7646 3 46 3301 Folsom St 1 1 1 2     21 3x3   6008513.44624 2099397.67081 37.745027010685 -122.413244473962 (37.745027010685, -122.413244473962)
17333 7543 3 46 2872 Folsom St 1 1 1 2     3 3x3   6008316.06064 2101754.32335 37.7514867681181 -122.41409369299299 (37.7514867681181, -122.414093692993)
17390 25188 3 46 3741 Market St 1 1 1 2     18 3X3   6000279.55164 2102883.22055 37.7541317821777 -122.44196585866501 (37.7541317821777, -122.441965858665)
17404 7550 3 46 2888 Folsom St 1 1 1 2     60 3x3   6008324.12517 2101635.93861 37.75116216321621 -122.414057430518 (37.7511621632162, -122.414057430518)
17424 7562 3 46 2924 Folsom St 1 1 1 2   12/14/2013 12:00:00 AM 3 5x5   6008336.41396 2101367.26054 37.7504251238168 -122.41399592947201 (37.7504251238168, -122.413995929472)
17450 7664 3 46 3348 Folsom St 1 1 1 2     18 4X4   6008462.72403 2099121.09112 37.7442647363292 -122.413400306703 (37.7442647363292, -122.413400306703)
17454 7657 3 46 3334 Folsom St 1 1 1 2     18 4X4   6008459.10706 2099217.21001 37.7445284544392 -122.41341960975099 (37.7445284544392, -122.413419609751)
17555 7607 3 46 3167 Folsom St 1 1 1 2     60 3X3   6008461.5790099995 2100237.0852799998 37.7473289441915 -122.413483177404 (37.7473289441915, -122.413483177404)
17556 7440 3 46 2528 Folsom St 1 1 1 2     18 3X3   6008209.2972 2103689.6592099997 37.7567947646774 -122.414599835016 (37.7567947646774, -122.414599835016)
17654 7660 3 46 3340 Folsom St 1 1 1 2   09/23/2015 01:35:00 PM 3 4x4   6008461.083190001 2099185.41304 37.744441257954705 -122.41341052839701 (37.7444412579547, -122.413410528397)
17682 23641 3 46 131 Virginia Ave 1 1 1 2   12/05/1997 12:00:00 AM 10 3X3   6006567.62834 2098529.44793 37.742533631335604 -122.419911178867 (37.7425336313356, -122.419911178867)
17755 7599 3 46 3106 Folsom St 3 1 1 2     16 3X3   6008391.53469 2100462.67214 37.747944422200796 -122.413741340393 (37.7479444222008, -122.413741340393)
Powered by Datasette · Query took 13.708ms · Data source: data.sfgov.org