sf-trees

Data source: data.sfgov.org

Custom SQL query returning 17 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1719 251394 6 154 203 Corbett Ave 1 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779803 6000094.0 2105620.0 37.7616357315689 -122.442804047122 (37.7616357315689, -122.442804047122)
46596 186116 2 154 1700 Sunset Blvd 1 9 1 1     2 Width 0ft   5984983.194 2103006.193 37.7535858999024 -122.49487269449 (37.7535858999024, -122.49487269449)
89111 20774 3 154 1701X Sunset Blvd 1 1 1 2     2     5984888.092725 2103630.7874996 37.7552952964732 -122.49524762816002 (37.7552952964732, -122.49524762816)
160161 186190 2 154 1701 Sunset Blvd 1 9 1 1     3 Width 0ft   5984778.3318 2103573.7698 37.755132314748394 -122.495623003209 (37.7551323147484, -122.495623003209)
160873 185390 2 154 2300 Sunset Blvd 1 19 1 1     2 Width 0ft   5985092.6382 2098924.4627 37.742384987274704 -122.49419339090001 (37.7423849872747, -122.4941933909)
24134 186264 2 154 1800 Sunset Blvd 2 9 1 1     2 Width 0ft   5985008.2513 2102330.1154 37.751731043534 -122.49473620106001 (37.751731043534, -122.49473620106)
89881 116068 3 154 4150X CLEMENT ST 2 7 1 2     3 3x3   5983115.0 2113126.0 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527)
82204 76514 1 154 1000 Tompkins Ave 4 1 1 1   06/13/2016 12:00:00 AM 3 3x3 Permit Number 778440 6009284.86795875 2096393.41418024 37.7368212561993 -122.41036493916 (37.7368212561993, -122.41036493916)
46015 124181 2 154 18 Almaden Ct 6 9 1 1     2 Width 9ft   5995866.538240001 2112606.8415599996 37.780577864424295 -122.457930655785 (37.7805778644243, -122.457930655785)
123372 116663 3 154 199x Esmeralda Ave 16 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
180584 186563 2 154 1501 Sunset Blvd 34 19 1 1     1 Width 0ft   5984717.9132 2104705.2165 37.7582354149831 -122.495915407531 (37.7582354149831, -122.495915407531)
31742 186044 2 154 1900 Sunset Blvd 39 9 1 1     2 Width 0ft   5985010.437999999 2102178.2104 37.7513140820988 -122.494717441079 (37.7513140820988, -122.494717441079)
174794 186572 2 154 1501 Sunset Blvd 43 19 1 1     1 Width 0ft   5984761.0418 2104653.2947 37.7580953780168 -122.495762422342 (37.7580953780168, -122.495762422342)
76059 186323 2 154 1800 Sunset Blvd 61 9 1 1     2 Width 0ft   5984977.2414 2102887.891 37.7532607267541 -122.4948845576 (37.7532607267541, -122.4948845576)
47538 185581 2 154 2201 Sunset Blvd 65 9 1 1     2 Width 0ft   5984892.0445 2099593.3004 37.744209694224104 -122.494936277947 (37.7442096942241, -122.494936277947)
166672 186403 2 154 1801 Sunset Blvd 70 9 1 1     3 Width 0ft   5984820.922 2102312.2628 37.7516710584533 -122.495382684544 (37.7516710584533, -122.495382684544)
24981 184886 2 154 1201 Sunset Blvd 76 9 1 1     1 Width 0ft   5984683.9949 2106763.6802 37.763885393603104 -122.49618458155199 (37.7638853936031, -122.496184581552)
Powered by Datasette · Query took 2.09ms · Data source: data.sfgov.org