sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
102059 108761 1 90 1350 Church St 1 1 1 1 1 01/05/2015 12:00:00 AM 3 3x3 Permit Number 774645 6004491.73804 2101024.57628 37.749267509186204 -122.427266693799 (37.7492675091862, -122.427266693799)
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)
102897 87853 1 90 599 Moultrie St 1 1 1 1   06/11/2008 12:00:00 AM   3x3 Permit Number 50764 6007684.0 2096571.0 37.7372189966792 -122.415912430403 (37.7372189966792, -122.415912430403)
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)
104974 95423 1 90 2187 21st Ave 1 1 1 1 1 03/01/2011 12:00:00 AM   3x3 Permit Number 767291 5989736.1 2100494.0 37.7469651560486 -122.478252612879 (37.7469651560486, -122.478252612879)
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)
105721 95660 1 90 431 Brussels St 1 1 1 1 1 03/08/2011 12:00:00 AM   3x3 Permit Number 767422 6010656.7 2092697.9 37.726750960199794 -122.40536171554 (37.7267509601998, -122.40536171554)
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)
106002 93256 3 90 1120 Church St 1 1 1 2   12/01/2008 12:00:00 AM 3 3x3 Owner Michael Freethy signed agreement on 12/26/09 to maintain curb cut added within 4' of tree after tree was planted 6004410.0 2102371.0 37.7529598520175 -122.427645261537 (37.7529598520175, -122.427645261537)
106814 95387 1 90 949 Diamond St 1 1 1 1 1 02/24/2011 12:00:00 AM   3x3 Permit Number 767255 6001944.0 2101334.0 37.7499727001327 -122.436098944037 (37.7499727001327, -122.436098944037)
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)
109624 94259 1 90 2777X 19th St 1 1 1 1   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009684.4 2104752.7 37.7597963985886 -122.40957339028499 (37.7597963985886, -122.409573390285)
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)
112161 32720 1 90 644 Hyde St 1 1 1 1   10/29/1996 12:00:00 AM 3 3x3 Permit Number 37113 6007901.48303797 2114768.35798987 37.7871969578975 -122.416449089052 (37.7871969578975, -122.416449089052)
112259 108977 1 90 2970 21st St 1 1 1 1 1 01/20/2015 12:00:00 AM 3 3x3 Permit Number 773794 6008402.2 2103930.0 37.7574655215329 -122.413949705223 (37.7574655215329, -122.413949705223)
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)
113204 114762 1 90 27X Highland Ave 1 1 1 1   12/07/2015 12:00:00 AM     Permit Number 46967 6005096.96871 2096699.6024099998 37.7374263260205 -122.424866136467 (37.7374263260205, -122.424866136467)
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)
116290 88687 1 90 135 Hancock St 1 1 1 1   08/06/2008 12:00:00 AM     Permit Number 51638 6003417.0 2105051.0 37.7602622759886 -122.43127052793899 (37.7602622759886, -122.431270527939)
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)
117348 95786 1 90 3431 22nd St 1 1 1 1 1 08/19/2011 12:00:00 AM   3x3 Permit Number 767530 6005503.0 2103116.0 37.7550672136514 -122.42391842755801 (37.7550672136514, -122.423918427558)
117526 117298 1 90 1590 08th Ave 1 1 1 1   06/06/2016 12:00:00 AM 3   Permit Number 778522 5993741.6 2104678.7 37.7586869726954 -122.46470588880699 (37.7586869726954, -122.464705888807)
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)
117808 98719 1 90 1500 Broadway 1 1 1 1   03/30/2012 12:00:00 AM     Permit Number 768751 6006413.8 2117997.6 37.795979878671 -122.421825625767 (37.795979878671, -122.421825625767)
117889 109142 1 90 342 29th Ave 1 1 1 1 1 01/29/2015 12:00:00 AM 3 3x3 Permit Number 773572 5986886.5 2113633.7 37.782877302208796 -122.489071978745 (37.7828773022088, -122.489071978745)
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)
119953 63015 1 90 75 Wool St 1 1 1 1 1 06/16/2014 12:00:00 AM     Permit Number 772837 6007421.64921795 2097871.12423845 37.7407740975251 -122.41691158671499 (37.7407740975251, -122.416911586715)
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)
124075 50261 1 90 31 Highland Ave 1 1 1 1 1 12/14/2002 12:00:00 AM     Permit Number 46967 6005053.32023027 2096760.11488265 37.737590014135 -122.425021354004 (37.737590014135, -122.425021354004)
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)
125075 53133 1 90 925 Holloway Ave 1 5 1 1 1 08/19/2015 12:00:00 AM     Permit Number 774158 5994000.81776041 2091173.40830125 37.7216197566197 -122.46282963525199 (37.7216197566197, -122.462829635252)
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)
127595 85589 3 90 1566 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6015069.619532 2095135.4181869999 37.7336896386511 -122.390276478357 (37.7336896386511, -122.390276478357)
127668 87026 1 90 863 Church St 1 1 1 1   12/07/2007 12:00:00 AM   3x3 Permit Number 49970 6004379.0 2103877.0 37.757093220538394 -122.427859766577 (37.7570932205384, -122.427859766577)
129588 193407 2 90 541 Missouri St 1 4 1 1     3 Width 2ft   6013570.69062 2104547.33874 37.7594495210946 -122.396118132954 (37.7594495210946, -122.396118132954)
136828 230393 2 90 3420 22nd St 1 1 1 1     9 Width 3ft   6005567.360669999 2103163.57677 37.7552014816894 -122.423699232135 (37.7552014816894, -122.423699232135)
138373 9306 3 90 240X Mansell St 1 1 1 2   03/29/2007 12:00:00 AM 3 3X100   6011154.1519898 2090628.8663314 37.7210976210121 -122.403496526224 (37.7210976210121, -122.403496526224)
138443 15056 3 90 1441 Mendell St 1 1 1 2   06/26/2012 12:00:00 AM 3 4x4   6015002.0 2095363.0 37.7343107811298 -122.390526157796 (37.7343107811298, -122.390526157796)
139100 2389 3 90 2642X Bryant St 1 1 1 2   03/11/2007 12:00:00 AM 3 3X3   6009749.5258463 2101948.1671123 37.752099429361294 -122.409150251369 (37.7520994293613, -122.409150251369)
139282 87673 1 90 2610 Bay Shore Blvd 1 1 1 1   03/14/2006 12:00:00 AM 3 3x3   6010582.741346 2086196.4709060001 37.708895230886 -122.40515978386101 (37.708895230886, -122.405159783861)
139844 93265 3 90 1400X Church St 1 1 1 2   12/02/2008 12:00:00 AM 3 3x3   6004448.1 2100692.1 37.748352138422796 -122.42739391326401 (37.7483521384228, -122.427393913264)
139951 85719 1 90 1175 Howard St 1 1 1 1   04/30/2007 12:00:00 AM 3 3x3   6009405.0 2110901.0 37.7766625499179 -122.410973965657 (37.7766625499179, -122.410973965657)
141895 84852 1 90 1266 Dolores St 1 1 1 1   04/18/2007 12:00:00 AM     Permit No. 49294 6005132.0 2100972.0 37.7491593351889 -122.42504891393499 (37.7491593351889, -122.425048913935)
142002 85561 3 90 990 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6018144.213614 2092843.516343 37.7275665867834 -122.379487431767 (37.7275665867834, -122.379487431767)
142121 86796 1 90 445 Wawona St 1 1 1 1   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625.0 2097033.0 37.737571604455205 -122.471468876287 (37.7375716044552, -122.471468876287)
142452 72994 1 90 590 Clipper St 1 1 1 1   07/06/2011 12:00:00 AM   3x3 Permit Number 768023 6001377.74978743 2100887.76679336 37.748715263692006 -122.438025102274 (37.748715263692, -122.438025102274)
142798 103791 1 90 1214 Polk St 1 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006878.4 2115091.6 37.7880269138329 -122.420011690177 (37.7880269138329, -122.420011690177)
143516 93278 3 90 1559 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004592.0 2099818.0 37.74596019909129 -122.426834068489 (37.7459601990913, -122.426834068489)
143561 91089 1 90 3417X 18th St 1 1 1 1   12/22/2008 12:00:00 AM 3 3x3 Permit Number 51985 6006736.0 2105525.0 37.761751301646704 -122.41982527826299 (37.7617513016467, -122.419825278263)
143565 55516 1 90 299 Douglass St 1 1 1 1   02/28/2014 12:00:00 AM     Permit Number 772528 6001150.72264648 2104659.12373936 37.759057586626206 -122.439080412698 (37.7590575866262, -122.439080412698)
143702 85577 3 90 1370 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016127.199744 2094347.0989189998 37.731583677290004 -122.38656512948499 (37.73158367729, -122.386565129485)
144143 85565 3 90 1276 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016630.35305 2093972.0233900002 37.7305816357941 -122.384799493903 (37.7305816357941, -122.384799493903)
144320 93289 3 90 1159 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004476.0 2102138.0 37.752323821507396 -122.427400423827 (37.7523238215074, -122.427400423827)
144410 85707 3 90 960 Howard St 1 1 1 2   04/30/2007 12:00:00 AM 3 3x3   6010763.0 2112242.0 37.7804206796364 -122.406370731962 (37.7804206796364, -122.406370731962)
144520 52671 1 90 1234@ LINCOLN 08th Ave 1 1 1 1 1 11/10/2010 12:00:00 AM   3x3 Permit Number 53911 5993637.83557736 2107090.14039952 37.7653021756316 -122.46523990796699 (37.7653021756316, -122.465239907967)
144998 85810 1 90 1675 Howard St 1 1 1 1   05/18/2007 12:00:00 AM 3 3x3   6007516.0 2108769.0 37.7707024771995 -122.417357464156 (37.7707024771995, -122.417357464156)
145306 93295 3 90 1019 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004430.0 2102966.0 37.7545947138847 -122.427618485613 (37.7545947138847, -122.427618485613)
145512 72375 5 90 4299X Fulton St 1 1 1 1 1 03/09/1996 12:00:00 AM   3x3 Permit Number 773790 5990099.63678033 2109979.56687008 37.773031079694 -122.47768879633699 (37.773031079694, -122.477688796337)
145750 93279 3 90 1557 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004591.0 2099830.0 37.745993091787795 -122.426838380811 (37.7459930917878, -122.426838380811)
145952 85814 1 90 1607 Howard St 1 1 1 1   05/18/2007 12:00:00 AM 3 3x3   6007663.0 2109095.0 37.7716058657462 -122.41687208779301 (37.7716058657462, -122.416872087793)
146109 85695 3 90 640 Howard St 1 1 1 2   04/30/2007 12:00:00 AM 3 3x3   6012881.28755 2114275.485576 37.786122430176896 -122.39918531693199 (37.7861224301769, -122.399185316932)
156278 230376 2 90 126 Dolores St 1 4 1 1     4 Width 3ft   6004756.55794 2107626.00234 37.7674084411732 -122.426821010098 (37.7674084411732, -122.426821010098)
172742 177452 2 90 404 Naples St 1 1 1 1     1 Width 4ft   6003440.2849 2091219.73942 37.7222861409715 -122.430203237092 (37.7222861409715, -122.430203237092)
173263 230390 2 90 3431 22nd St 1 1 1 1     4 Width 3ft   6005492.40988 2103117.15388 37.7550697840629 -122.423955133335 (37.7550697840629, -122.423955133335)
176715 81753 1 90 565 Missouri St 1 1 1 1   07/02/2009 12:00:00 AM 4 3x3 Permit Number 52385 6013577.35874 2104447.02049 37.7591744400611 -122.396088040728 (37.7591744400611, -122.396088040728)
178042 230375 2 90 70 Pearl St 1 4 1 1     9 Width 4ft   6005616.00843 2108643.7620099997 37.770251521926 -122.423920665902 (37.770251521926, -122.423920665902)
179739 193406 2 90 746 Kansas St 1 1 1 1     1 Width 3ft   6011525.03424 2104899.87784 37.7603034831294 -122.40321785872601 (37.7603034831294, -122.403217858726)
2563 124911 2 90 3234 Pacific Ave 2 1 1 1   07/19/2017 12:00:00 AM 3 Width 4ft Permit Number 780160 5998736.95045 2116593.12953 37.7916876606053 -122.448287711302 (37.7916876606053, -122.448287711302)
9463 85733 1 90 901 Howard St 2 1 1 1   04/30/2007 12:00:00 AM 4 3x3   6011193.193535 2112605.183477 37.7814419523203 -122.404908060988 (37.7814419523203, -122.404908060988)
9788 115347 4 90 398X HARRISON ST 2 1 1 1   12/28/2016 12:00:00 AM 3 4x4 Permit Number 773314 6014854.0 2114630.0 37.7872055860551 -122.392385006805 (37.7872055860551, -122.392385006805)
14031 18353 4 90 480 Potrero Ave 2 1 1 1   04/02/2013 12:00:00 AM 3 3x3   6010310.709559999 2106111.3358 37.76356198052329 -122.407503071611 (37.7635619805233, -122.407503071611)
18377 93250 3 90 1050 Church St 2 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004388.0 2102776.0 37.754070642695496 -122.42775019598 (37.7540706426955, -122.42775019598)
19158 5458 1 90 589 Dolores St 2 1 1 1   08/20/2009 12:00:00 AM 90 3x3   6004996.57492 2104960.58209 37.7601033992601 -122.42580108085801 (37.7601033992601, -122.425801080858)
20240 5355 3 90 214 Dolores St 2 1 1 2   09/03/2009 12:00:00 AM 3 6   6004795.29962 2107076.64131 37.765902217941296 -122.42664788340099 (37.7659022179413, -122.426647883401)
20720 10236 3 90 33 Haight St 2 1 1 2   05/30/2002 12:00:00 AM 8 4X4   6005944.57875 2109639.18298 37.7730032531225 -122.42285489644699 (37.7730032531225, -122.422854896447)
22956 103844 3 90 1541 Polk St 2 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006635.7 2116216.3 37.791101384779296 -122.420931274285 (37.7911013847793, -122.420931274285)
22970 103849 3 90 1524 Polk St 2 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042)
Powered by Datasette · Query took 4.088ms · Data source: data.sfgov.org