sf-trees

Data source: data.sfgov.org

Custom SQL query returning 16 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
16686 19817 3 190 100 STAIRWAY25 1 1 1 2     12 100ST            
94834 99679 3 190 165 Grattan St 1 1 1 4 2   10 3x3   5997880.8 2106478.8 37.7638673579207 -122.45052048585899 (37.7638673579207, -122.450520485859)
79512 804 3 190 680X 39th Ave 2 11 1 2     3 6-HOA   5983823.94935 2111143.69789 37.7758612538886 -122.499482885033 (37.7758612538886, -122.499482885033)
64747 191695 3 190 950x Kansas St 4 3 1 2     4     6011603.94241 2103847.92507 37.7574194607598 -122.40287096412901 (37.7574194607598, -122.402870964129)
143567 111509 3 190 800x BOSWORTH ST 4 7 1 2     4     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
6018 19926 3 190 100 STAIRWAY37 6 1 1 2     3 20ST            
17045 19792 3 190 100 STAIRWAY19 14 1 1 2     6 20ST            
7267 19835 3 190 100 STAIRWAY25 19 1 1 2     12 60X            
14534 18564 3 190 1700X Quesada Ave 19 11 1 2     30 19   6014511.59225 2095170.6430400002 37.7337553901961 -122.392208220649 (37.7337553901961, -122.392208220649)
8172 19836 3 190 100 STAIRWAY25 20 1 1 2     12 60X            
15209 19838 3 190 100 STAIRWAY25 22 1 1 2     6 60X            
67780 191690 3 190 900x Carolina St 22 3 1 2     2     6012468.62754 2103498.74867 37.756508943061206 -122.39985600137399 (37.7565089430612, -122.399856001374)
11287 20003 3 190 100 STAIRWAY46 23 1 1 2     3 2            
65580 191710 3 190 1427x Innes Ave 28 3 1 2     3     6016141.2133599995 2096757.17707 37.7382020430791 -122.386684681762 (37.7382020430791, -122.386684681762)
172289 207711 3 190 200x Terrace Dr 31 3 1 2     12     5993844.07189 2096487.62875 37.7362022754996 -122.463756979508 (37.7362022754996, -122.463756979508)
50134 191700 3 190 1700x Quesada Ave 39 3 1 2     3     6014384.30677 2095263.8272900002 37.7340041867507 -122.39265480417801 (37.7340041867507, -122.392654804178)
Powered by Datasette · Query took 56.889ms · Data source: data.sfgov.org