sf-trees

Data source: data.sfgov.org

Custom SQL query returning 20 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
43333 6292 1 12 1700X Ellis St 11 1 1 3   01/28/2013 12:00:00 AM 24 3X4 Permit Number 768629 6002728.2699376 2113059.4201816004 37.7822123689276 -122.43422505132601 (37.7822123689276, -122.434225051326)
48375 17720 1 37 1300X Pierce St 1 1 1 3   01/28/2013 12:00:00 AM 35 3X3 Permit Number 768629 6002290.5602400005 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321)
77366 17721 1 37 1300X Pierce St 2 1 1 3   01/28/2013 12:00:00 AM 3 3X3 Permit Number 768629 6002290.5602400005 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321)
77843 98421 3 15 1501X Steiner St 5 1 1 3       3x3 Permit Number 768629 6002677.2 2113386.1 37.7831064505465 -122.43442509431299 (37.7831064505465, -122.434425094313)
82149 98423 3 44 1501X Steiner St 7 1 1 3   01/28/2013 12:00:00 AM   3x3 Permit Number 768629 6002677.2 2113386.1 37.7831064505465 -122.43442509431299 (37.7831064505465, -122.434425094313)
92526 98417 3 15 1501X Steiner St 1 1 1 3       3x3 Permit Number 768629 6002677.2 2113386.1 37.7831064505465 -122.43442509431299 (37.7831064505465, -122.434425094313)
95645 17724 1 37 1300X Pierce St 5 1 1 3   01/28/2013 12:00:00 AM 20 3X3 Permit Number 768629 6002290.5602400005 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321)
99261 98426 3 15 1501X Steiner St 10 1 1 3       3x3 Permit Number 768629 6002677.2 2113386.1 37.7831064505465 -122.43442509431299 (37.7831064505465, -122.434425094313)
99569 98434 3 44 1401X Steiner St 9 1 1 3   01/28/2013 12:00:00 AM   3x3 Permit Number 768629 6002724.9 2113044.1 37.782170112299795 -122.434235614198 (37.7821701122998, -122.434235614198)
101074 102516 3 44 1401X Steiner St 2 1 1 3   01/28/2013 12:00:00 AM   4x4 Permit Number 768629 6002724.9 2113044.1 37.782170112299795 -122.434235614198 (37.7821701122998, -122.434235614198)
117106 98432 3 44 1401X Steiner St 7 1 1 3   01/28/2013 12:00:00 AM   3x3 Permit Number 768629 6002724.9 2113044.1 37.782170112299795 -122.434235614198 (37.7821701122998, -122.434235614198)
118532 98422 3 44 1501X Steiner St 6 1 1 3   01/28/2013 12:00:00 AM   3x3 Permit Number 768629 6002677.2 2113386.1 37.7831064505465 -122.43442509431299 (37.7831064505465, -122.434425094313)
119159 6290 1 12 1700X Ellis St 9 1 1 3   05/06/2015 12:00:00 AM   4x4 Permit Number 768629 6002728.2699376 2113059.4201816004 37.7822123689276 -122.43422505132601 (37.7822123689276, -122.434225051326)
123156 98435 3 44 1401X Steiner St 10 1 1 3   01/28/2013 12:00:00 AM   3x3 Permit Number 768629 6002724.9 2113044.1 37.782170112299795 -122.434235614198 (37.7821701122998, -122.434235614198)
123177 6288 1 6 1700X Ellis St 2 1 1 3   01/28/2013 12:00:00 AM   4x3 Permit Number 768629 6002728.2699376 2113059.4201816004 37.7822123689276 -122.43422505132601 (37.7822123689276, -122.434225051326)
123574 98418 3 17 1501X Steiner St 2 1 1 3       3x3 Permit Number 768629 6002677.2 2113386.1 37.7831064505465 -122.43442509431299 (37.7831064505465, -122.434425094313)
125042 98427 3 15 1401X Steiner St 1 1 1 3       3x3 Permit Number 768629 6002724.9 2113044.1 37.782170112299795 -122.434235614198 (37.7821701122998, -122.434235614198)
139442 98425 3 15 1501X Steiner St 9 1 1 3       3x3 Permit Number 768629 6002677.2 2113386.1 37.7831064505465 -122.43442509431299 (37.7831064505465, -122.434425094313)
141545 98431 3 17 1401X Steiner St 6 1 1 3       3x3 Permit Number 768629 6002724.9 2113044.1 37.782170112299795 -122.434235614198 (37.7821701122998, -122.434235614198)
143937 17725 1 37 1300X Pierce St 6 1 1 3   01/28/2013 12:00:00 AM 60 3X3 Permit Number 768629 6002290.5602400005 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321)
Powered by Datasette · Query took 7.433ms · Data source: data.sfgov.org