sf-trees

Data source: data.sfgov.org

Custom SQL query returning 12 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
35135 56924 1 109 140 Tingley St 1 1 1 1   08/15/1974 12:00:00 AM 3   Permit Number 14167 6002240.5096 2093994.70553 37.7298375431559 -122.434548888919 (37.7298375431559, -122.434548888919)
80086 37574 1 109 30 Collingwood St 1 1 1 1 1 08/15/2014 12:00:00 AM 3   Permit Number 773155 6001973.00287599 2105680.02476784 37.7619074866084 -122.43630964556101 (37.7619074866084, -122.436309645561)
83271 43725 1 109 759 Lakeview Ave 2 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43364 5994445.58077229 2089904.10562801 37.7181601624587 -122.46120025798099 (37.7181601624587, -122.461200257981)
86576 43724 1 109 759 Lakeview Ave 1 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43364 5994445.58077229 2089904.10562801 37.7181601624587 -122.46120025798099 (37.7181601624587, -122.461200257981)
90094 54118 1 109 760 Lakeview Ave 1 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
105304 43729 1 109 763 Lakeview Ave 1 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43366 5994409.95328954 2089904.45905166 37.7181590824666 -122.461323431638 (37.7181590824666, -122.461323431638)
111021 43728 1 109 760 Lakeview Ave 4 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
112173 43727 1 109 760 Lakeview Ave 3 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
129415 43734 1 109 777 Lakeview Ave 1 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43371 5994281.26699369 2089905.22565848 37.7181537802459 -122.46176829730601 (37.7181537802459, -122.461768297306)
141030 43726 1 109 760 Lakeview Ave 2 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
144269 56594 1 109 533 Laidley St 1 1 1 1   11/16/2012 12:00:00 AM 3 3x3 Permit Number 768959 6003224.0 2096098.0 37.7356684939052 -122.431298930259 (37.7356684939052, -122.431298930259)
145556 66265 1 109 4020 26th St 1 1 1 1   10/30/1990 12:00:00 AM 3 6x9 Permit Number 29370 6003740.3803829 2100725.5739603 37.7484039979455 -122.429843577344 (37.7484039979455, -122.429843577344)
Powered by Datasette · Query took 77.459ms · Data source: data.sfgov.org