sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
38472 129194 2 19 85 Cervantes Blvd 2 9 1 1     6 Width 1ft   6001552.51444 2120931.86169 37.8037612434571 -122.438856955397 (37.8037612434571, -122.438856955397)
38511 245190 2 19 1165 Page St 4 1 1 1     6 Width 0ft   6000954.6073 2109297.4919 37.7717822376068 -122.440091274084 (37.7717822376068, -122.440091274084)
38573 176693 2 19 231 Athens St 1 9 1 1     8 Width 7ft   6004560.89466 2091885.9682599998 37.7241788667532 -122.426376964428 (37.7241788667532, -122.426376964428)
38642 176865 2 19 1142 Munich St 2 1 1 1     5 Width 2ft   6001491.17517 2087075.7451099998 37.7107970662038 -122.436644357861 (37.7107970662038, -122.436644357861)
38700 64762 1 19 648 Funston Ave 1 1 1 1   12/09/1988 12:00:00 AM 8   Permit Number 25739 5991956.18292 2111010.7557900003 37.7759700106605 -122.471341981082 (37.7759700106605, -122.471341981082)
38742 219285 2 19 111 Monterey Blvd 1 9 1 1     5 Width 1ft   6001314.21471 2094602.6455299999 37.7314541797466 -122.437794714872 (37.7314541797466, -122.437794714872)
38919 201349 2 19 1 Bitting Ave 11 9 1 1     6 Width 8ft   6012827.9931 2092586.2696 37.7265656062986 -122.39784774058998 (37.7265656062986, -122.39784774059)
38948 249603 2 19 2240 Golden Gate Ave 2 9 1 1     5 Width 3ft   5998819.017030001 2111486.76835 37.77767161949011 -122.44763601580799 (37.7776716194901, -122.447636015808)
39030 249749 2 19 2500 Broderick St 33 4 1 1     12 Width 1ft   6000235.88036 2117238.71283 37.7935458425285 -122.44314782591299 (37.7935458425285, -122.443147825913)
39031 118935 2 19 882 48th Ave 2 1 1 1     6 Width 3ft   5981106.559230001 2109729.9345299997 37.7718196654774 -122.50877787634701 (37.7718196654774, -122.508777876347)
39084 250169 2 19 721 Parker Ave 10 9 1 1     15 Width 7ft   5997237.65706 2110666.34039 37.7753284349893 -122.453047211372 (37.7753284349893, -122.453047211372)
39223 226882 2 19 2810 19th St 1 9 1 1     5 Width 2ft   6009447.14609 2105030.4857 37.7605458378345 -122.41041355295201 (37.7605458378345, -122.410413552952)
39238 176826 2 19 635 Prague St 1 9 1 1     8 Width 5ft   6002712.89216 2087452.0684200001 37.711899721374 -122.432448688654 (37.711899721374, -122.432448688654)
39296 118084 2 19 7101 Geary Blvd 6 9 1 1     12 Width 3ft   5984977.6516 2112422.66835 37.7794405616591 -122.49558634816002 (37.7794405616591, -122.49558634816)
39518 129245 2 19 1230 Clay St 1 9 1 1     5 Width 3ft   6008845.28336 2117017.82608 37.79342648000571 -122.41334287149401 (37.7934264800057, -122.413342871494)
39633 219241 2 19 19 Miramar Ave 1 2 1 1     7 Width 3ft   5995302.14694 2090052.41762 37.7186166498261 -122.458250223781 (37.7186166498261, -122.458250223781)
39701 129113 2 19 10 Hastings Ter 3 9 1 1     2     6007329.70066 2119282.266 37.7995588581063 -122.418747576633 (37.7995588581063, -122.418747576633)
39856 129108 2 19 155 Retiro Way 2 1 1 1     5 Width 3ft   6001855.64531 2121684.5263400003 37.805845102121296 -122.43786189781 (37.8058451021213, -122.43786189781)
39860 42981 1 19 387 Princeton St 1 1 1 1 1 07/05/2000 12:00:00 AM 9   Permit Number 42865 6007925.78486 2092082.5600700001 37.7249083014575 -122.414758909799 (37.7249083014575, -122.414758909799)
40056 219363 2 19 57 Lagunitas Dr 1 9 1 1     14 Width 3ft   5990950.29751 2095356.30121 37.7329287603452 -122.47367934265199 (37.7329287603452, -122.473679342652)
40060 226881 2 19 14 Liberty St 1 4 1 1     19 Width 1ft   6006207.80682 2104080.83219 37.757756184028395 -122.42154951882 (37.7577561840284, -122.42154951882)
40063 190763 2 19 1901 Quint St 2 9 1 1     18 Width 2ft   6012404.6522 2095210.16355 37.7337466919524 -122.39949535794202 (37.7337466919524, -122.399495357942)
40088 190778 2 19 1250 20th St 6 9 1 1     5 Width 3ft   6014183.521930001 2104826.5276900004 37.760250192011 -122.394018188999 (37.760250192011, -122.394018188999)
40143 176755 2 19 39 Amherst St 2 9 1 1     7 Width 4ft   6007337.46192 2093318.25117 37.7282681695262 -122.416880187495 (37.7282681695262, -122.416880187495)
40191 129271 2 19 1369 Hyde St 7 9 1 1     7 Width 2ft   6007508.18673 2116988.14114 37.7932698109171 -122.417967231327 (37.7932698109171, -122.417967231327)
40241 176843 2 19 182 Niagara Ave 8 10 1 1     3 Width 0ft   5999252.47179 2089747.68303 37.718006124373105 -122.444573717211 (37.7180061243731, -122.444573717211)
40280 227021 2 19 123 Manchester St 1 1 1 1     7 Width 4ft   6008281.58077 2099209.78469 37.7444980969188 -122.414032936584 (37.7444980969188, -122.414032936584)
40364 219319 2 19 300 Ashton Ave 2 9 1 1     7 Width 1ft   5994210.91317 2091964.42992 37.7238038098934 -122.462160735039 (37.7238038098934, -122.462160735039)
40444 226940 2 19 9 Bemis St 1 9 1 1     9 Width 4ft   6003929.09347 2096974.1924299998 37.738114253060395 -122.428923598041 (37.7381142530604, -122.428923598041)
40450 219269 2 19 1330 Kirkham St 5 9 1 1     11 Width 2ft   5990592.20952 2105220.86504 37.7599935416893 -122.47563739517099 (37.7599935416893, -122.475637395171)
40469 249747 2 19 2500 Broderick St 31 4 1 1     10 Width 1ft   6000233.56128 2117245.74106 37.793565007967 -122.44315635509399 (37.793565007967, -122.443156355094)
40477 219411 2 19 845 Detroit St 4 9 1 1     20 Width 5ft   5999420.52154 2095713.4289400002 37.7343962677584 -122.444421347772 (37.7343962677584, -122.444421347772)
40509 176735 2 19 1245 Bacon St 3 9 1 1     5 Width 2ft   6007785.06482 2091940.88647 37.7245113883837 -122.41523534004101 (37.7245113883837, -122.415235340041)
40515 176771 2 19 937 Silver Ave 2 9 1 1     16 Width 2ft   6007368.40948 2093546.0944400001 37.72889551860511 -122.41678933527001 (37.7288955186051, -122.41678933527)
40551 129159 2 19 135 Mayfair Dr 1 9 1 1     4 Width 4ft   5997408.66924 2114451.98586 37.785732623419 -122.452728928703 (37.785732623419, -122.452728928703)
40690 129181 2 19 2815 Filbert St 3 9 1 1     8 Width 4ft   5999478.17066 2118381.38967 37.796640096714505 -122.445851771645 (37.7966400967145, -122.445851771645)
40696 219275 2 19 1651 09th Ave 1 1 1 1     14 Width 2ft   5993370.433230001 2104236.7588299997 37.7574521115395 -122.465957429918 (37.7574521115395, -122.465957429918)
40707 219318 2 19 300 Ashton Ave 1 9 1 1     5 Width 1ft   5994210.25958 2091948.5213400002 37.7237600911452 -122.46216184119 (37.7237600911452, -122.46216184119)
40817 176682 2 19 1998 Alemany Blvd 4 9 1 1     6 Width 2ft   6000630.5225599995 2090456.6587099999 37.7200313490478 -122.43986121213301 (37.7200313490478, -122.439861212133)
40832 227010 2 19 5527 Diamond Heights Blvd 3 9 1 1     4 Width 8ft   6001848.80076 2097475.72956 37.739373388466895 -122.436152077973 (37.7393733884669, -122.436152077973)
40995 176594 2 19 207 Theresa St 6 9 1 1     11 Width 2ft   6001997.82459 2093826.34352 37.72936147984579 -122.43537583891701 (37.7293614798458, -122.435375838917)
41224 227003 2 19 5411 Diamond Heights Blvd 2 9 1 1     2 Width 3ft   6002088.6819 2098074.75757 37.741031805779 -122.435365514706 (37.741031805779, -122.435365514706)
41273 129250 2 19 1230 Clay St 6 9 1 1     6 Width 3ft   6008770.61192 2117008.3352099997 37.7933962277169 -122.413600569531 (37.7933962277169, -122.413600569531)
41354 184569 2 19 3943 Moraga St 1 1 1 1     5 Width 0ft   5981967.8868 2103494.6521 37.7547501020315 -122.505336310147 (37.7547501020315, -122.505336310147)
41410 219410 2 19 845 Detroit St 2 9 1 1     21 Width 5ft   5999420.88677 2095723.69435 37.734424474994995 -122.444420822556 (37.734424474995, -122.444420822556)
41457 176706 2 19 1401 Felton St 2 9 1 1     5 Width 5ft   6006831.721390001 2092612.75382 37.726302566288794 -122.41857854996799 (37.7263025662888, -122.418578549968)
41466 206932 2 19 304 Ridgewood Ave 5 9 1 1     8 Width 3ft   5996826.20254 2095064.45784 37.732465983599894 -122.453343868921 (37.7324659835999, -122.453343868921)
41521 176750 2 19 1100 Felton St 8 9 1 1     6 Width 2ft   6007642.23896 2092919.3671799998 37.7271900586719 -122.415798324654 (37.7271900586719, -122.415798324654)
41828 190809 2 19 2109 22nd St 1 9 1 1     4 Width 3ft   6011813.75397 2103701.3128400003 37.7570286091033 -122.402135040812 (37.7570286091033, -122.402135040812)
41916 176824 2 19 102 Bowdoin St 6 9 1 1     6 Width 6ft   6008431.82226 2094483.21435 37.7315284044084 -122.413179268628 (37.7315284044084, -122.413179268628)
41994 129117 2 19 12 Hastings Ter 8 9 1 1     5     6007264.16981 2119273.41538 37.7995308667162 -122.418973709394 (37.7995308667162, -122.418973709394)
42195 129225 2 19 2711 Vallejo St 11 9 1 1     3 Width 4ft   6000598.01874 2117499.1088 37.794281463669705 -122.441913500121 (37.7942814636697, -122.441913500121)
42201 176845 2 19 54 Gambier St 1 9 1 1     4 Width 2ft   6005715.3463 2093303.5013700002 37.728136293845104 -122.42248686869101 (37.7281362938451, -122.422486868691)
42298 129251 2 19 1230 Clay St 7 9 1 1     6 Width 3ft   6008764.64924 2117007.4706200003 37.7933935189451 -122.41362113973 (37.7933935189451, -122.41362113973)
42361 176822 2 19 102 Bowdoin St 4 9 1 1     8 Width 6ft   6008425.8217 2094514.9756099998 37.7316152771105 -122.413202258904 (37.7316152771105, -122.413202258904)
42520 176665 2 19 1787 San Jose Ave 1 9 1 1     6 Width 3ft   6000762.888230001 2093739.1978 37.729051986242204 -122.43963887275801 (37.7290519862422, -122.439638872758)
42535 250173 2 19 721 Parker Ave 14 9 1 1     4 Width 7ft   5997239.18442 2110648.2538799997 37.7752788616692 -122.453040622039 (37.7752788616692, -122.453040622039)
42674 219277 2 19 70 Marcela Ave 2 2 1 1     7 Width 4ft   5994666.162690001 2100675.76794 37.74774920006679 -122.46121818977501 (37.7477492000668, -122.461218189775)
42679 219324 2 19 1090 Capitol Ave 10 9 1 1     7 Width 1ft   5995080.31545 2091178.4589099998 37.721695741442396 -122.459098491311 (37.7216957414424, -122.459098491311)
43202 118930 2 19 875 La Playa 6 9 1 1     5 Width 4ft   5980751.65283 2109636.5801 37.7715424153171 -122.509998562861 (37.7715424153171, -122.509998562861)
43208 219383 2 19 459 Mangels Ave 4 9 1 1     6 Width 10ft   5998400.01537 2095223.03965 37.7329914952508 -122.447914261545 (37.7329914952508, -122.447914261545)
43211 118078 2 19 7150 Geary Blvd 1 9 1 1     14 Width 7ft   5984743.66491 2112532.51161 37.7797284549829 -122.496403902204 (37.7797284549829, -122.496403902204)
43294 219284 2 19 201 Hearst Ave 3 9 1 1     16 Width 2ft   6000000.31433 2094329.62548 37.7306297307768 -122.44231751154499 (37.7306297307768, -122.442317511545)
43342 226971 2 19 220 Swiss Ave 4 9 1 1     8 Width 2ft   6001230.712180001 2096666.61613 37.7371166162454 -122.438231202605 (37.7371166162454, -122.438231202605)
43377 176817 2 19 633 Burrows St 2 9 1 1     6 Width 3ft   6009456.4217300005 2092933.01773 37.7273293618403 -122.40952764698099 (37.7273293618403, -122.409527646981)
43420 176674 2 19 17 Paulding St 6 9 1 1     6 Width 2ft   6000269.12571 2093162.5981700001 37.7274406610436 -122.441304488221 (37.7274406610436, -122.441304488221)
43522 176727 2 19 1835 Silliman St 2 9 1 1     4 Width 2ft   6005346.06759 2092637.3763400002 37.7262864216673 -122.42371613669901 (37.7262864216673, -122.423716136699)
43601 226883 2 19 2810 19th St 3 9 1 1     4 Width 2ft   6009442.873790001 2105030.57293 37.7605458378462 -122.41042833510599 (37.7605458378462, -122.410428335106)
43606 176668 2 19 25 Camellia Ave 1 9 1 1     7 Width 2ft   6003228.3472 2094009.7333099998 37.7299348336038 -122.43113489517799 (37.7299348336038, -122.431134895178)
43705 190817 3 19 390x Hampshire St 5 11 1 2     13 Width 5ft   6010044.56493 2106488.02831 37.7645813917285 -122.40845015844101 (37.7645813917285, -122.408450158441)
43812 176599 2 19 255 Ottawa Ave 1 9 1 1     17 Width 8ft   5998280.541680001 2089346.8494799999 37.716850019794606 -122.44790439957899 (37.7168500197946, -122.447904399579)
43911 219267 2 19 1486 19th Ave 2 9 1 1     6 Width 3ft   5990295.40982 2105284.56966 37.7601512467979 -122.476668525453 (37.7601512467979, -122.476668525453)
43916 249625 2 19 2450 Golden Gate Ave 3 9 1 1     19 Width 7ft   5997639.79528 2111322.31201 37.777152600940106 -122.451703458765 (37.7771526009401, -122.451703458765)
43932 206959 2 19 546 Joost Ave 3 9 1 1     1     5998473.1983199995 2095010.9948599997 37.7324134532998 -122.44764599109399 (37.7324134532998, -122.447645991094)
44115 31115 1 19 450 Edna St 6 1 1 1 1 03/21/1995 12:00:00 AM 5   Permit Number 34839 5998792.06252 2094332.58617 37.7305689213091 -122.44649481749201 (37.7305689213091, -122.446494817492)
44302 219351 2 19 350 Victoria St 2 9 1 1     5 Width 3ft   5993263.35325 2089534.6361099998 37.7170775806463 -122.46525985636002 (37.7170775806463, -122.46525985636)
44382 54527 1 19 4550 Balboa St 1 1 1 1   07/31/1972 12:00:00 AM 8 3x5 Permit Number 10322 5981462.67511 2111006.65453 37.775346149152 -122.507640822085 (37.775346149152, -122.507640822085)
44537 219348 2 19 513 Ramsell St 2 9 1 1     10 Width 8ft   5992970.49595 2090542.2168 37.7198272604875 -122.466345302117 (37.7198272604875, -122.466345302117)
44550 117813 2 19 3900 Balboa St 9 9 1 1     7 Width 6ft   5983481.12715 2111084.52953 37.775678674640396 -122.500664399599 (37.7756786746404, -122.500664399599)
44637 201345 2 19 1 Bitting Ave 7 9 1 1     5 Width 8ft   6012754.450780001 2092609.0590599999 37.726624085606396 -122.398103573427 (37.7266240856064, -122.398103573427)
44737 206937 2 19 33 Congo St 2 9 1 1     10 Width 8ft   6000058.45225 2094003.2368599998 37.7297368568549 -122.442093101029 (37.7297368568549, -122.442093101029)
44824 68547 1 19 526 43rd Ave 1 1 1 1   10/18/1993 12:00:00 AM 9   Permit Number 32434 5982567.23967 2112157.10709 37.7785699651083 -122.50390516811599 (37.7785699651083, -122.503905168116)
45155 190814 3 19 390x Hampshire St 1 11 1 2     16 Width 5ft   6010041.1190599995 2106539.02685 37.7647212291204 -122.40846567444599 (37.7647212291204, -122.408465674446)
45160 226880 2 19 1850 Bryant St 3 4 1 1     25 Width 2ft   6009467.77548 2106133.6543799997 37.7635760441104 -122.41042010180901 (37.7635760441104, -122.410420101809)
45249 219385 2 19 329 Mangels Ave 2 9 1 1     3 Width 2ft   5999222.72505 2095218.63632 37.7330263961533 -122.445069633071 (37.7330263961533, -122.445069633071)
45391 129239 2 19 2792 Fillmore St 8 9 1 1     5 Width 4ft   6002609.508780001 2117716.5979299997 37.794993047745 -122.43496908546999 (37.794993047745, -122.43496908547)
45457 206945 2 19 224 Edna St 2 9 1 1     7 Width 2ft   5998782.42741 2093648.8743 37.7286910586321 -122.446478957932 (37.7286910586321, -122.446478957932)
45474 219274 2 19 1251 Funston Ave 5 9 1 1     8 Width 5ft   5992036.15334 2106859.17905 37.7645755218673 -122.470762873609 (37.7645755218673, -122.470762873609)
45644 218230 2 19 100 Claremont Blvd 6 9 1 1     11 Width 8ft   5993788.79546 2098675.54917 37.7422065730654 -122.46410687336001 (37.7422065730654, -122.46410687336)
45698 219252 2 19 493 Joost Ave 5 9 1 1     3 Width 10ft   5998807.210109999 2094945.46348 37.7322526032772 -122.446486525737 (37.7322526032772, -122.446486525737)
45702 129197 2 19 75 Cervantes Blvd 2 4 1 1     5 Width 2ft   6001606.6144900005 2120894.2374 37.8036610149183 -122.43866704197501 (37.8036610149183, -122.438667041975)
45751 248141 2 19 274 Rutledge St 1 1 1 1     18 Width 2ft   6009875.37752 2099433.39728 37.745201475562794 -122.408537657996 (37.7452014755628, -122.408537657996)
45902 176783 2 19 745 Silliman St 1 9 1 1     6 Width 5ft   6008508.75071 2093604.64822 37.729120368908205 -122.41285121931999 (37.7291203689082, -122.41285121932)
46210 226966 2 19 17 Temple St 2 2 1 1     8 Width 3ft   6000015.92856 2105901.5883400002 37.7624044523192 -122.443094287484 (37.7624044523192, -122.443094287484)
46288 129166 2 19 75 Emerson St 4 9 1 1     10 Width 8ft   5998684.61281 2113379.65213 37.782861304856894 -122.448237300713 (37.7828613048569, -122.448237300713)
46315 206948 2 19 422 Judson Ave 1 9 1 1     10 Width 5ft   5997397.5658599995 2093594.47343 37.7284624896392 -122.451262563442 (37.7284624896392, -122.451262563442)
46357 190782 2 19 1250 20th St 10 9 1 1     13 Width 3ft   6014143.03501 2104824.3821099997 37.7602420504487 -122.394158065056 (37.7602420504487, -122.394158065056)
46421 246622 2 19 37 Norwich St 2 4 1 1     5 Width 4ft   6009131.1615699995 2099436.16764 37.7451673750763 -122.411111235306 (37.7451673750763, -122.411111235306)
46533 129358 2 19 2431 Jones St 20 9 1 1     5 Width 3ft   6007962.785209999 2120702.9106099997 37.8034952158822 -122.41665756479799 (37.8034952158822, -122.416657564798)
46536 176864 2 19 1142 Munich St 1 1 1 1     8 Width 2ft   6001508.44833 2087074.49051 37.710794602952106 -122.436584568222 (37.7107946029521, -122.436584568222)
46543 249746 2 19 2500 Broderick St 30 4 1 1     4 Width 1ft   6000233.18821 2117249.22853 37.7935745623699 -122.44315789653 (37.7935745623699, -122.44315789653)
Powered by Datasette · Query took 3.514ms · Data source: data.sfgov.org