sf-trees

Data source: data.sfgov.org

Custom SQL query returning 17 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4010 253604 2 5 267 Teresita Blvd 1 5 1 1       3x10   5997729.0 2098564.0 37.7421265906625 -122.450474893449 (37.7421265906625, -122.450474893449)
4446 253627 3 5 44 Stonecrest Dr 1 5 1 2       3x3   5991061.0 2093828.0 37.7287388406121 -122.4731851996 (37.7287388406121, -122.4731851996)
8131 112367 6 5 2770 Broadway 1 5 1 1   07/23/2015 12:00:00 AM 3 3x3 Permit Number 774944 6000432.434780001 2117179.73451 37.7933951089516 -122.442463497617 (37.7933951089516, -122.442463497617)
13841 3685 1 5 100X Cargo Way 121 5 1 9     8 3x3   6016762.06772 2099192.87656 37.744924332395 -122.38470767871999 (37.744924332395, -122.38470767872)
81069 113145 2 5 150 BROADMOOR DR 2 5 1 1       3x3   5990980.0 2092843.0 37.726029586770395 -122.473393404688 (37.7260295867704, -122.473393404688)
87877 113532 2 5 2681 28TH AVE 2 5 1 1       6x6   5987701.0 2097026.0 37.7373245974808 -122.485035321422 (37.7373245974808, -122.485035321422)
93554 87293 1 5 763 45th Ave 3 5 1 1   03/19/2008 12:00:00 AM     Permit Number 50306 5981945.1 2110561.2 37.7741514699411 -122.505938997766 (37.7741514699411, -122.505938997766)
95633 114816 2 5 125 BRENTWOOD AVE 1 5 1 1       4x10   5995779.0 2095603.0 37.7338846095715 -122.45700321324699 (37.7338846095715, -122.457003213247)
103044 113533 2 5 2681 28TH AVE 3 5 1 1       6x6   5987701.0 2097026.0 37.7373245974808 -122.485035321422 (37.7373245974808, -122.485035321422)
106304 87292 1 5 763 45th Ave 2 5 1 1   03/19/2008 12:00:00 AM     Permit Number 50306 5981945.1 2110561.2 37.7741514699411 -122.505938997766 (37.7741514699411, -122.505938997766)
107674 106774 2 5 155X Eucalyptus Dr 1 5 1 1     12 3x3   5990905.0300199995 2094685.3067400001 37.7310837571916 -122.47378690918801 (37.7310837571916, -122.473786909188)
107836 113531 2 5 2681 28TH AVE 1 5 1 1     28 6x6   5987701.0 2097026.0 37.7373245974808 -122.485035321422 (37.7373245974808, -122.485035321422)
109255 92815 1 5 54 Cerritos Ave 1 5 1 1   11/06/2009 12:00:00 AM   3x3 Permit Number 53023 5992579.4 2093009.1 37.72657814349439 -122.46787650278 (37.7265781434944, -122.46787650278)
116856 109176 2 5 335 COLON AVE 1 5 1 1     26     5995818.3 2094822.2 37.7317429788493 -122.45681088999399 (37.7317429788493, -122.456810889994)
126772 87291 1 5 763 45th Ave 1 5 1 1   03/19/2008 12:00:00 AM     Permit Number 50306 5981945.1 2110561.2 37.7741514699411 -122.505938997766 (37.7741514699411, -122.505938997766)
127907 109177 2 5 320 COLON AVE 1 5 1 1     24     5995887.7 2094797.5 37.7316791433679 -122.45656917602899 (37.7316791433679, -122.456569176029)
99139 74759 3 5 250 Foerster St 13 5 1 4 2 05/15/1999 12:00:00 AM 30 5x7   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
Powered by Datasette · Query took 10.33ms · Data source: data.sfgov.org