sf-trees

Data source: data.sfgov.org

Custom SQL query returning 23 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
157750 30806 1 19 138 Hamerton Ave 1 1 1 1 1 02/06/1995 12:00:00 AM 15   Permit Number 34671 6001325.75026 2095385.6774799998 37.7336048607826 -122.437810896383 (37.7336048607826, -122.437810896383)
30510 30812 1 19 100 Joost Ave 1 1 1 1 1 02/06/1995 12:00:00 AM 5   Permit Number 34674 6001381.93618 2094967.05294 37.7324586091634 -122.43758667648001 (37.7324586091634, -122.43758667648)
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)
131920 31117 1 19 450 Edna St 3 1 1 1 1 03/21/1995 12:00:00 AM 3   Permit Number 34839 5998792.33216 2094320.7757 37.7305365079364 -122.446493035949 (37.7305365079364, -122.446493035949)
64687 31118 1 19 450 Edna St 1 1 1 1 1 03/21/1995 12:00:00 AM 7   Permit Number 34839 5998792.48559 2094316.2837 37.730524182724 -122.446492182475 (37.730524182724, -122.446492182475)
75317 34709 1 19 727 46th Ave 1 1 1 1 1 07/28/1997 12:00:00 AM 25   Permit Number 38365 5981632.43118 2110780.81019 37.7747360459971 -122.50703684968501 (37.7747360459971, -122.507036849685)
69062 35257 1 19 2363 Larkin St 1 1 1 1 1 03/26/2001 12:00:00 AM 2   Permit Number 43818 6006687.16748 2119377.40243 37.799783881083606 -122.420977735243 (37.7997838810836, -122.420977735243)
146783 35594 1 19 1303 Rhode Island St 1 1 1 1 1 11/12/2005 12:00:00 AM 5   Permit Number 38957 6012015.58746 2102213.6753599998 37.752955146087295 -122.401332479509 (37.7529551460873, -122.401332479509)
167693 38364 1 19 4001 Lawton St 1 1 1 1 1 05/01/2002 12:00:00 AM 5   Permit Number 44994 5981794.8549 2104174.5597 37.7566067521127 -122.50598509825001 (37.7566067521127, -122.50598509825)
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)
183234 43136 1 19 1730 Burrows St 1 1 1 1 1 07/11/2000 12:00:00 AM 7   Permit Number 42952 6006290.853069999 2092023.3911599999 37.7246538391803 -122.42040649398199 (37.7246538391803, -122.420406493982)
76264 44486 1 19 390 Harvard St 1 1 1 1 1 03/26/2001 12:00:00 AM 16   Permit Number 43792 6006402.34332 2092081.2102700002 37.724818880074395 -122.420025186814 (37.7248188800744, -122.420025186814)
174140 49714 1 19 1181@ POLK Chestnut St 1 1 1 1 1 06/03/2003 12:00:00 AM 5   Permit Number 46526 6006207.33741 2120358.03247 37.8024493825888 -122.422707853704 (37.8024493825888, -122.422707853704)
148745 61250 1 19 2033 Leavenworth St 1 1 1 1 1 03/15/1997 12:00:00 AM 7   Permit Number 24211 6007651.97178 2119454.00624 37.800048553351296 -122.41764457883001 (37.8000485533513, -122.41764457883)
48359 66778 1 19 1335 Union St 1 1 1 1 1 09/20/1991 12:00:00 AM 5   Permit Number 30043 6006555.48078 2119018.76457 37.798791728305396 -122.42140793763001 (37.7987917283054, -122.42140793763)
35180 68976 1 19 2550 Chestnut St 1 1 1 1 1 01/04/1994 12:00:00 AM 7   Permit Number 32966 5999654.77227 2119511.53893 37.7997532672523 -122.44532199182301 (37.7997532672523, -122.445321991823)
180391 69013 1 19 2183 45th Ave 1 1 1 1 1 01/05/1994 12:00:00 AM 4   Permit Number 33017 5982309.8617 2100270.0071 37.7459162464128 -122.50391486605301 (37.7459162464128, -122.503914866053)
54321 70512 2 19 75 Vienna St 1 1 1 1 1 06/25/1994 12:00:00 AM 5     6004917.4216 2092965.0192099998 37.7271618505134 -122.425221249286 (37.7271618505134, -122.425221249286)
59244 71583 2 19 266 Flournoy St 1 1 1 1 1 09/30/1995 12:00:00 AM 7     5993925.4185 2086705.1573599998 37.7093466620935 -122.462766282735 (37.7093466620935, -122.462766282735)
25548 71937 2 19 1053 Montgomery St 1 1 1 1 1 10/21/1995 12:00:00 AM 4     6011562.24883 2118965.23166 37.7989257551836 -122.404079031531 (37.7989257551836, -122.404079031531)
62195 84689 2 19 3632 Fillmore St 1 1 1 1 1   3     6002195.05393 2120739.39081 37.80326930438871 -122.436619630107 (37.8032693043887, -122.436619630107)
61110 92458 1 19 3319 Lawton St 1 1 1 1 1 07/30/2009 12:00:00 AM 1 3x3 Permit Number 52848 5983933.4582 2104246.8072 37.756930776386795 -122.498594490514 (37.7569307763868, -122.498594490514)
56672 96034 1 19 1075 Pacific Ave 1 1 1 1 1 09/02/2011 12:00:00 AM 3 3x3 Permit Number 767673 6008986.730930001 2117980.65751 37.7960781193685 -122.41292155709999 (37.7960781193685, -122.4129215571)
Powered by Datasette · Query took 66.254ms · Data source: data.sfgov.org