sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1590 5343 3 90 180 Dolores St 1 1 1 1   10/24/2014 02:20:00 PM 3 3X3   6004776.7961099995 2107352.0132 37.7666572770255 -122.426731495165 (37.7666572770255, -122.426731495165)
2200 252931 2 90 71 Edgar Ave 1 1 1 1       3x3   5997064.0 2091155.0 37.7217451669512 -122.45223976154499 (37.7217451669512, -122.452239761545)
4892 21646 3 90 1660 Sutter St 1 1 1 2   10/31/2017 01:25:00 PM 3 3X4   6004679.2621 2114722.8807 37.7868903572795 -122.427594040592 (37.7868903572795, -122.427594040592)
4901 18480 3 90 1298 Potrero Ave 1 1 1 2   10/31/2017 01:20:00 PM 3 3x3   6010561.39126 2101710.28558 37.751491708090896 -122.406325925618 (37.7514917080909, -122.406325925618)
9121 85732 1 90 901 Howard St 1 1 1 1   04/30/2007 12:00:00 AM 3 3x3   6011193.193535 2112605.183477 37.7814419523203 -122.404908060988 (37.7814419523203, -122.404908060988)
9977 5406 3 90 392 Dolores St 1 1 1 2   02/02/2012 12:00:00 AM 5 3x3   6004848.6988147 2106052.9215434 37.7630943465887 -122.42639029035401 (37.7630943465887, -122.426390290354)
13480 85599 3 90 1115 Palou Ave 1 1 1 2   03/07/2014 12:00:00 AM 3 3x3   6017434.0078 2093308.576 37.7288043549368 -122.38197498007798 (37.7288043549368, -122.381974980078)
14910 17426 3 90 1869 Palou Ave 1 1 1 2   12/05/2015 01:06:00 PM 3 3X3   6013447.639169999 2096284.8118900002 37.736755533926 -122.39596469871401 (37.736755533926, -122.395964698714)
15344 96670 3 90 1425 Mendell St 1 1 1 2   06/26/2012 12:00:00 AM 4 4x4   6015007.7446 2095379.2401 37.7343556918302 -122.390507431087 (37.7343556918302, -122.390507431087)
16888 18349 4 90 480 Potrero Ave 1 1 1 1   02/28/2006 12:00:00 AM 3 3X3   6010310.27618 2106136.10948 37.763629979170496 -122.40750631726101 (37.7636299791705, -122.407506317261)
17294 10232 3 90 11 Haight St 1 1 1 2   05/30/2002 12:00:00 AM 8     6005984.55063 2109644.68395 37.7730206127534 -122.422717019597 (37.7730206127534, -122.422717019597)
17657 18422 3 90 940 Potrero Ave 1 1 1 2   06/09/2016 06:57:00 AM 3 3x3   6010451.25485 2103753.05423 37.7570945357026 -122.406850749261 (37.7570945357026, -122.406850749261)
17773 18420 3 90 924 Potrero Ave 1 1 1 2   12/14/2013 12:00:00 AM 3 3x3   6010442.48956 2103839.41038 37.7573311599314 -122.406887149344 (37.7573311599314, -122.406887149344)
20723 5477 3 90 655 Dolores St 1 1 1 2     3 3X3   6005026.79294 2104432.16218 37.7586541903676 -122.42565896099899 (37.7586541903676, -122.425658960999)
21273 18371 1 90 636 Potrero Ave 1 1 1 1   05/02/2016 12:00:00 AM 4 2X2   6010355.5730099995 2105342.69627 37.7614539813358 -122.40729371393999 (37.7614539813358, -122.40729371394)
21383 3929 3 90 100X Castro St 1 1 1 2   07/18/2014 12:00:00 AM 3 2x2   6002188.32938 2107609.3026900003 37.7672170447484 -122.43570295204799 (37.7672170447484, -122.435702952048)
21685 18423 3 90 952 Potrero Ave 1 1 1 2   11/20/2013 12:00:00 AM 3 3x3   6010455.30853 2103703.2834799998 37.75695810316021 -122.406833222372 (37.7569581031602, -122.406833222372)
24021 177451 2 90 836 Brazil Ave 1 1 1 1     5 Width 2ft   6004096.8384300005 2090858.43848 37.7213312534072 -122.427907954105 (37.7213312534072, -122.427907954105)
32851 230380 2 90 1450 Hampshire St 1 1 1 1     5 Width 3ft   6010406.10881 2100942.79845 37.74937566986971 -122.40680882918501 (37.7493756698697, -122.406808829185)
41914 230386 2 90 51 13th St 1 4 1 1     9 Width 4ft   6008087.40778 2108285.62264 37.769407368778 -122.415346724678 (37.769407368778, -122.415346724678)
44789 230394 2 90 280 Fair Oaks St 1 1 1 1     1 Width 3ft   6005433.48505 2102088.4512099996 37.752241878473896 -122.42408575987 (37.7522418784739, -122.42408575987)
45445 230392 2 90 3416 22nd St 1 1 1 1     4 Width 3ft   6005586.33797 2103162.25218 37.7551989159029 -122.423633508794 (37.7551989159029, -122.423633508794)
49354 131010 2 90 3099 Steiner St 1 1 1 1     3 Width 3ft   6001935.38679 2118702.3343700003 37.797661323668606 -122.437372261923 (37.7976613236686, -122.437372261923)
50163 17385 1 90 1649 Palou Ave 1 1 1 1   10/28/1996 12:00:00 AM 12 6x5   6014583.05525 2095408.96107 37.7344137306531 -122.39197780950899 (37.7344137306531, -122.391977809509)
53287 78624 2 90 1325 Kansas St 1 1 1 1 1 10/07/2000 12:00:00 AM 2     6011733.68356 2102177.51534 37.7528401263726 -122.402304820204 (37.7528401263726, -122.402304820204)
53871 230391 2 90 3425 22nd St 1 1 1 1     2 Width 3ft   6005521.318 2103117.66656 37.755072823769204 -122.423855197061 (37.7550728237692, -122.423855197061)
62190 79630 2 90 1331 Kansas St 1 1 1 1 1 10/05/2002 12:00:00 AM 2     6011736.35903 2102141.72528 37.752742004040606 -122.402293051689 (37.7527420040406, -122.402293051689)
66030 103847 3 90 1529 Polk St 1 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006640.1 2116184.7 37.7910148670423 -122.42091380589399 (37.7910148670423, -122.420913805894)
77688 93269 3 90 1730 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004618.0 2098811.0 37.743196678206296 -122.42667246707799 (37.7431966782063, -122.426672467078)
79013 85727 1 90 1025 Howard St 1 1 1 1   05/16/2007 12:00:00 AM 3 3x3   6010365.0 2111820.0 37.7792396944918 -122.40771784288 (37.7792396944918, -122.40771784288)
79321 10342 3 90 935 Haight St 1 1 1 2   06/04/2011 12:00:00 AM 3 4x4   6001663.937059999 2109024.15924 37.7710720905099 -122.437618081823 (37.7710720905099, -122.437618081823)
81232 93286 3 90 1283 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004502.0 2101425.0 37.7503675600759 -122.427259727267 (37.7503675600759, -122.427259727267)
83075 93252 3 90 1070 Church St 1 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004394.0 2102659.0 37.753749727529396 -122.427721110855 (37.7537497275294, -122.427721110855)
83349 93300 3 90 589X Church St 1 1 1 2   12/12/2008 12:00:00 AM 3 3x3   6004575.9 2105667.0 37.7620192734995 -122.427306317148 (37.7620192734995, -122.427306317148)
84159 85604 3 90 1261 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016687.610646 2093879.449725 37.7303306134548 -122.384595098105 (37.7303306134548, -122.384595098105)
84828 93291 3 90 1065 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004445.0 2102697.0 37.753856951407705 -122.42754744828301 (37.7538569514077, -122.427547448283)
84975 93277 3 90 1565 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004670.9 2099777.3 37.7458529070189 -122.426558345234 (37.7458529070189, -122.426558345234)
85134 93273 3 90 1679 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004706.9 2099119.3 37.7440482251279 -122.42638702061701 (37.7440482251279, -122.426387020617)
85241 85828 3 90 875 Howard St 1 1 1 2   05/17/2007 12:00:00 AM 3 3x3   6011370.824523999 2112775.117387 37.7819184786136 -122.40430550469401 (37.7819184786136, -122.404305504694)
85581 93267 3 90 1550 Church St 1 1 1 2   12/02/2008 12:00:00 AM 3 3x3   6004563.0 2099865.0 37.746087610537295 -122.426937693393 (37.7460876105373, -122.426937693393)
85651 18391 3 90 874 Potrero Ave 1 1 1 2   12/14/2013 12:00:00 AM 3 4x4   6010420.6643105 2104143.6455038004 37.7581653002339 -122.406984073056 (37.7581653002339, -122.406984073056)
85944 93266 3 90 1440 Church St 1 1 1 2   12/02/2008 12:00:00 AM 3 3x3   6004482.7 2100527.8 37.747902965476 -122.42726256538602 (37.747902965476, -122.427262565386)
86667 85584 3 90 1512 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6015354.897796 2094923.102787 37.7331224832721 -122.389275358402 (37.7331224832721, -122.389275358402)
87496 103843 3 90 1541 Polk St 1 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006635.7 2116216.3 37.791101384779296 -122.420931274285 (37.7911013847793, -122.420931274285)
87716 93293 3 90 1049 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004440.0 2102791.0 37.7541147705659 -122.42757143594 (37.7541147705659, -122.42757143594)
88428 86595 3 90 2154 Bryant St 1 1 1 2   04/30/2007 12:00:00 AM 6 3x3   6009566.0 2104744.0 37.7597658751742 -122.409982265203 (37.7597658751742, -122.409982265203)
88557 85827 1 90 1345 Howard St 1 1 1 1   05/17/2007 12:00:00 AM 3 3x3   6008580.0 2110114.0 37.774455337270396 -122.413772211324 (37.7744553372704, -122.413772211324)
88852 93281 3 90 1465 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004562.0 2100365.0 37.747460438671105 -122.426976756198 (37.7474604386711, -122.426976756198)
90042 93288 3 90 1259 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004494.0 2101568.0 37.7507597523824 -122.42729757712601 (37.7507597523824, -122.427297577126)
90907 13340 3 90 230 Mansell St 1 1 1 2   03/29/2007 12:00:00 AM 3 3X24   6011187.2509688 2090638.9738565 37.721127222942 -122.40338282278499 (37.721127222942, -122.403382822785)
91134 85567 3 90 1274 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016640.49857 2093964.460415 37.730561430483796 -122.384763892339 (37.7305614304838, -122.384763892339)
91447 5370 3 90 265 DOLORES ST 1 1 1 2   07/11/2015 03:03:00 PM 3 3X3   6005008.2 2106862.7 37.765326820302 -122.42589627439101 (37.765326820302, -122.425896274391)
91448 93260 3 90 1250X Church St 1 1 1 2   12/02/2008 12:00:00 AM 3 3x3   6004401.7 2101569.1 37.750757552311704 -122.427616837084 (37.7507575523117, -122.427616837084)
92111 29047 3 90 244 11th St 1 1 1 2   07/31/2012 12:00:00 AM 3 3x3   6008230.7231960995 2109406.8924959 37.7724941663121 -122.414930372766 (37.7724941663121, -122.414930372766)
93529 2 3 90 850X Lake St 1 1 1 2   04/25/2009 12:00:00 AM 3 3X3   5992872.52482 2114854.21479 37.78657606668221 -122.468451837381 (37.7865760666822, -122.468451837381)
93558 85578 3 90 1388 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016034.7263629995 2094416.0331849998 37.7317678372886 -122.386889636739 (37.7317678372886, -122.386889636739)
95708 103848 3 90 1524 Polk St 1 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042)
97539 93284 3 90 1347 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004523.0 2101050.0 37.7493390847523 -122.427160399995 (37.7493390847523, -122.427160399995)
98187 434 3 90 890X Potrero Ave 1 1 1 2   12/14/2013 12:00:00 AM 3 3x3   6010425.429178201 2104052.7086425 37.7579158746071 -122.406961184613 (37.7579158746071, -122.406961184613)
98869 93275 3 90 1607 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004606.0 2099539.0 37.7451949208192 -122.42676579302 (37.7451949208192, -122.42676579302)
99235 86637 3 90 2679 Bryant St 1 1 1 2   04/30/2007 12:00:00 AM 3 3x3   6009805.5318559995 2101750.09748 37.751558711569096 -122.40894259967101 (37.7515587115691, -122.408942599671)
99675 103845 3 90 1540 Polk St 1 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006747.0 2116248.1 37.7911949727431 -122.42054843762399 (37.7911949727431, -122.420548437624)
100161 85559 3 90 980 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6018187.977748999 2092810.8923689998 37.727479421244 -122.37933387198099 (37.727479421244, -122.379333871981)
100513 93282 3 90 1383 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004535.0 2100841.0 37.748765897796204 -122.42710401922199 (37.7487658977962, -122.427104019222)
100755 93259 3 90 1234 Church St 1 1 1 2   12/02/2008 12:00:00 AM 3 3x3   6004459.0 2101704.0 37.7511311972424 -122.42742829765899 (37.7511311972424, -122.427428297659)
101720 93272 3 90 1689 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004632.0 2099057.0 37.7438729293821 -122.42664157265 (37.7438729293821, -122.42664157265)
102730 93257 3 90 1180X Church St 1 1 1 2   12/02/2008 12:00:00 AM 3 3x3   6004390.8 2101994.4 37.7519247103798 -122.42768482883699 (37.7519247103798, -122.427684828837)
102892 13103 1 90 1516 Lombard St 1 1 1 1   03/11/2008 12:00:00 AM 3 3x3   6005111.0 2119918.0 37.801179250916796 -122.426470375667 (37.8011792509168, -122.426470375667)
103768 93261 3 90 1252 Church St 1 1 1 2   12/02/2008 12:00:00 AM 3 3x3   6004465.0 2101602.0 37.750851468343896 -122.427400283526 (37.7508514683439, -122.427400283526)
104380 103834 3 90 900X O'Farrell St 1 1 1 2   11/01/2009 12:00:00 AM 3 3x3   6006751.076230001 2113939.67696 37.78485684194221 -122.420370415446 (37.7848568419422, -122.420370415446)
105434 85569 3 90 1260 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016711.517151 2093911.5196330003 37.7304199931233 -122.384514682139 (37.7304199931233, -122.384514682139)
105958 85583 3 90 1500 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6015418.292964 2094875.9215880001 37.7329964475839 -122.389052889382 (37.7329964475839, -122.389052889382)
108745 93276 3 90 1603 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004604.0 2099562.0 37.7452579604553 -122.426774346316 (37.7452579604553, -122.426774346316)
109604 93274 3 90 1613 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004607.0 2099503.0 37.7450961296299 -122.426759771954 (37.7450961296299, -122.426759771954)
109929 85721 1 90 1049 Howard St 1 1 1 1   04/30/2007 12:00:00 AM 3 3x3   6010189.0 2111652.0 37.778768551926795 -122.408314849736 (37.7787685519268, -122.408314849736)
110080 93283 3 90 1377 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004533.0 2100877.0 37.7488646323576 -122.427113499044 (37.7488646323576, -122.427113499044)
110344 85820 1 90 1501 Howard St 1 1 1 1   05/18/2007 12:00:00 AM 3 3x3   6008072.0 2109608.0 37.7730374398788 -122.415493654294 (37.7730374398788, -122.415493654294)
110579 93290 3 90 1071 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004519.0 2102665.5 37.7537746450798 -122.427289295317 (37.7537746450798, -122.427289295317)
110941 85708 3 90 964 Howard St 1 1 1 2   04/30/2007 12:00:00 AM 3 3x3   6010738.0 2112218.0 37.780353382723604 -122.40645552748501 (37.7803533827236, -122.406455527485)
112715 85568 3 90 1264 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016691.22613 2093926.645569 37.730460403847204 -122.384585884949 (37.7304604038472, -122.384585884949)
113436 93287 3 90 1279 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004501.0 2101449.0 37.750433401942104 -122.427264894728 (37.7504334019421, -122.427264894728)
113657 93285 3 90 1289 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004504.0 2101389.0 37.7502688255514 -122.427250247058 (37.7502688255514, -122.427250247058)
113846 93294 3 90 1037 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004436.0 2102861.0 37.7543067479004 -122.427590255736 (37.7543067479004, -122.427590255736)
114083 100431 6 90 200X Stonecrest Dr 1 7 1 1           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264)
114160 93292 3 90 1059 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004443.0 2102732.0 37.7539529400822 -122.42755685810499 (37.7539529400822, -122.427556858105)
114199 100465 1 90 1140 Potrero Ave 1 1 1 1     3 3x3   6010498.9 2102571.5 37.75385291653011 -122.40660271212 (37.7538529165301, -122.40660271212)
114770 93280 3 90 1485 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004568.0 2100246.0 37.7471340314151 -122.42694753458099 (37.7471340314151, -122.426947534581)
115233 85817 1 90 1581 Howard St 1 1 1 1   05/18/2007 12:00:00 AM 3 3x3   6007957.739489 2109502.485486 37.7727412989479 -122.415881423672 (37.7727412989479, -122.415881423672)
115779 5577 1 90 1041 Dolores St 1 1 1 1   12/11/2010 12:00:00 AM 3 3x3   6005148.8764838 2102292.2742932 37.752785456150605 -122.42508448290899 (37.7527854561506, -122.425084482909)
116886 85824 1 90 1399X Howard St 1 1 1 1   05/17/2007 12:00:00 AM 3 3x3   6008422.422874 2109956.642426 37.774014420128495 -122.414306166437 (37.7740144201285, -122.414306166437)
117554 85822 1 90 1499X Howard St 1 1 1 1   05/17/2007 12:00:00 AM 3 3x3   6008077.269337 2109627.004998 37.7730899192917 -122.415476772701 (37.7730899192917, -122.415476772701)
118353 85607 3 90 1397 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6015969.720597 2094414.6007130002 37.7317603044799 -122.387114277117 (37.7317603044799, -122.387114277117)
118449 85818 1 90 1525 Howard St 1 1 1 1   05/18/2007 12:00:00 AM 3 3x3   6007957.0 2109502.0 37.7727399243445 -122.415883947269 (37.7727399243445, -122.415883947269)
118815 11953 3 90 1436 Kirkwood Ave 1 1 1 2   12/27/2007 12:00:00 AM 6 3X4   6015854.7568499 2096315.1604746997 37.7369724919298 -122.38764428476802 (37.7369724919298, -122.387644284768)
118880 93268 3 90 1574 Church St 1 1 1 2   01/29/2015 05:47:00 AM 3 3x3   6004569.0 2099722.0 37.7456953047191 -122.42690676352 (37.7456953047191, -122.42690676352)
120019 85580 3 90 1458 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6015655.098902999 2094699.254039 37.7325244779387 -122.38822185678002 (37.7325244779387, -122.38822185678)
120118 85737 3 90 843 Howard St 1 1 1 2   04/30/2007 12:00:00 AM 3 3x3   6011572.165806 2112967.7341830004 37.782458608165896 -122.40362250946998 (37.7824586081659, -122.40362250947)
120459 85597 3 90 1101 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 6 3x3   6017523.881587001 2093256.0516779998 37.728665096277204 -122.381660625783 (37.7286650962772, -122.381660625783)
124501 93263 3 90 1326 Church St 1 1 1 2   12/02/2008 12:00:00 AM 3 3x3   6004490.0 2101167.0 37.749658473374204 -122.42728284799401 (37.7496584733742, -122.427282847994)
125597 93271 3 90 1699X Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004711.0 2099043.6 37.7438406020251 -122.426367454995 (37.7438406020251, -122.426367454995)
127346 94638 3 90 2000X Bay Shore Blvd 1 1 1 2   10/19/2010 12:00:00 AM 3 3x3   6012318.2 2088514.6 37.715357222040005 -122.399324379639 (37.71535722204, -122.399324379639)
Powered by Datasette · Query took 5.664ms · Data source: data.sfgov.org