sf-trees

Data source: data.sfgov.org

Custom SQL query returning 20 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5604 19964 3 19 100 STAIRWAY41 2 1 1 2     6 25ST            
8096 19962 3 19 100 STAIRWAY41 -2 1 1 2     6 25ST            
9264 19963 3 19 100 STAIRWAY41 1 1 1 2     6 25ST            
11331 1100 3 19 2328 Alemany Blvd 1 1 1 2     25 3X3   5999423.31284 2089282.1433599999 37.71673760544579 -122.44394976577298 (37.7167376054458, -122.443949765773)
11566 16410 3 19 1186X Munich St 3 1 1 2     42 TR   6001066.26402 2087197.59203 37.7111074743937 -122.43812166787501 (37.7111074743937, -122.438121667875)
14648 19819 3 19 100 STAIRWAY25 3 1 1 2     12 100ST            
15377 25938 3 19 2000 Oakdale Ave 3 1 1 2   04/22/1997 12:00:00 AM 12 3x3   6012867.3394 2097145.5573099998 37.739086658519895 -122.39803142710899 (37.7390866585199, -122.398031427109)
15925 25939 3 19 2000 Oakdale Ave 4 1 1 2   04/22/1997 12:00:00 AM 10 3x3   6012857.31615 2097153.53613 37.7391080084261 -122.39806664277201 (37.7391080084261, -122.398066642772)
16920 19979 3 19 100 STAIRWAY45 6 1 1 2     3 30ST            
17954 16098 3 19 300 Monterey Blvd 1 1 1 2   12/17/1997 12:00:00 AM 6 2X3   6000050.52204 2094718.8331 37.7317012658005 -122.442171864536 (37.7317012658005, -122.442171864536)
18654 16099 3 19 300 Monterey Blvd 3 1 1 2     12 3X3   6000036.69943 2094718.89433 37.7317006461483 -122.442219656332 (37.7317006461483, -122.442219656332)
18666 19313 3 19 21 Shields St 1 1 1 2     3 3X3   5993901.63447 2089816.98545 37.7178896324771 -122.463074115289 (37.7178896324771, -122.463074115289)
19631 16102 3 19 300 Monterey Blvd 6 1 1 2     12 3X3   6000017.68556 2094719.9660099999 37.7317025050652 -122.442285467815 (37.7317025050652, -122.442285467815)
21395 16100 3 19 300 Monterey Blvd 4 1 1 2     12 3X3   6000028.57256 2094720.41703 37.7317043639536 -122.442247861742 (37.7317043639536, -122.442247861742)
21593 16127 3 19 330 Monterey Blvd 2 1 1 2     12 3x3   5999874.93833 2094721.1240700001 37.7316975479954 -122.442779055318 (37.7316975479954, -122.442779055318)
32407 866 3 19 600X Alemany Blvd 4 1 1 2     6 1X1   6007241.9784 2095034.8696299999 37.7329762592527 -122.41733187808398 (37.7329762592527, -122.417331878084)
100221 5821 3 19 1027 Duncan St 1 1 1 2     75 3X3   5999811.0829915 2099731.7400522 37.745451872839 -122.443359584044 (37.745451872839, -122.443359584044)
110428 12623 3 19 825 Lake St 1 1 1 2     27 3X3   5992882.168 2114794.01241 37.7864113245051 -122.468414093066 (37.7864113245051, -122.468414093066)
112118 878 3 19 600X Alemany Blvd 16 1 1 2     6 1X1   6007241.9784 2095034.8696299999 37.7329762592527 -122.41733187808398 (37.7329762592527, -122.417331878084)
139863 24744 3 19 128X Point Lobos Ave 1 1 1 2   02/02/1996 12:00:00 AM 3 3x3   5982380.471419999 2112632.1433099997 37.7798632908372 -122.504586464809 (37.7798632908372, -122.504586464809)
Powered by Datasette · Query took 58.677ms · Data source: data.sfgov.org