sf-trees

Data source: data.sfgov.org

Custom SQL query returning 37 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5604 19964 3 19 100 STAIRWAY41 2 1 1 2     6 25ST            
6044 107491 3 19 1306x Montgomery St 20 11 1 2     8     6011446.048280001 2119975.7461599996 37.8016938891322 -122.40455229795 (37.8016938891322, -122.40455229795)
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)
26942 129350 3 19 1306x Montgomery St 38 3 1 2     1 Width 8ft   6011425.50986 2120159.17711 37.8021963979046 -122.404636291051 (37.8021963979046, -122.404636291051)
27490 129348 3 19 1306x Montgomery St 33 3 1 2     2 Width 8ft   6011427.80927 2120135.82348 37.802132403051 -122.404626688974 (37.802132403051, -122.404626688974)
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)
43705 190817 3 19 390x Hampshire St 5 11 1 2     13 Width 5ft   6010044.56493 2106488.02831 37.7645813917285 -122.40845015844101 (37.7645813917285, -122.408450158441)
45155 190814 3 19 390x Hampshire St 1 11 1 2     16 Width 5ft   6010041.1190599995 2106539.02685 37.7647212291204 -122.40846567444599 (37.7647212291204, -122.408465674446)
46600 116804 3 19 131 LAKESHORE DR 1 3 2 2       10x100   5984782.0 2094243.0 37.7295127607338 -122.494922366174 (37.7295127607338, -122.494922366174)
75147 129353 3 19 1306x Montgomery St 51 3 1 2     6 Width 8ft   6011391.406830001 2120329.06369 37.8026609588854 -122.404766271855 (37.8026609588854, -122.404766271855)
86324 121732 3 19 1301 Vermont St 7 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
95182 16377 3 19 1400X Montgomery St 10 11 1 2     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508)
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)
104252 121734 3 19 1301 Vermont St 9 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
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)
135071 190816 3 19 390x Hampshire St 3 11 1 2     7 Width 5ft   6010044.10542 2106509.4810599997 37.7646402703573 -122.40845326111099 (37.7646402703573, -122.408453261111)
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)
154652 129351 3 19 1306x Montgomery St 39 3 1 2     1 Width 8ft   6011425.67929 2120161.57643 37.8022029953207 -122.404635873741 (37.8022029953207, -122.404635873741)
163136 129352 3 19 1306x Montgomery St 45 3 1 2     3 Width 8ft   6011406.69978 2120255.02893 37.8024585322873 -122.404708135188 (37.8024585322873, -122.404708135188)
175803 129354 3 19 1306x Montgomery St 52 3 1 2     14 Width 8ft   6011388.89614 2120338.61388 37.8026870410416 -122.40477563290199 (37.8026870410416, -122.404775632902)
181902 190815 3 19 390x Hampshire St 2 11 1 2     11 Width 5ft   6010042.68497 2106527.82648 37.7646905631515 -122.408459468238 (37.7646905631515, -122.408459468238)
183528 219372 3 19 400x Marietta Dr 17 11 1 2     9 Width 3ft   5999397.86314 2097051.08053 37.7380678498474 -122.444595794674 (37.7380678498474, -122.444595794674)
188999 129349 3 19 1306x Montgomery St 35 3 1 2     2 Width 8ft   6011426.64663 2120143.89656 37.8021545047788 -122.40463128093398 (37.8021545047788, -122.404631280934)
Powered by Datasette · Query took 35.009ms · Data source: data.sfgov.org