sf-trees

Data source: data.sfgov.org

Custom SQL query returning 21 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1748 17869 3 155 2132 Pine St 1 1 1 2   05/21/1992 12:00:00 AM 12 3X3   6003712.3639 2115281.4031 37.788369180682295 -122.430979161307 (37.7883691806823, -122.430979161307)
6782 42639 3 155 1651 Union St 9 1 1 4 2 06/18/2014 12:00:00 AM 8 3x3 Permit Number 42688 6005258.416780001 2118846.41372 37.798245281357204 -122.425883928195 (37.7982452813572, -122.425883928195)
11215 75214 3 155 125 Excelsior Ave 3 1 1 4 2 05/08/1992 12:00:00 AM 14 4x5   6002868.59368 2092460.8085599998 37.725661442297294 -122.432268027453 (37.7256614422973, -122.432268027453)
12861 75133 3 155 125 Excelsior Ave 1 1 1 4 2 05/08/1992 12:00:00 AM 14 4x4   6002899.19862 2092441.61812 37.7256104849218 -122.43216085884501 (37.7256104849218, -122.432160858845)
13648 25580 3 155 1511 Hudson Ave 1 1 1 2     9 3X3   6016141.48149 2097069.66658 37.7390600907376 -122.386705539738 (37.7390600907376, -122.386705539738)
22254 16148 3 155 383 Monterey Blvd 1 1 1 2   01/21/1998 12:00:00 AM 3 3X3   5999549.4531 2094641.0103799999 37.7314590136113 -122.443898565568 (37.7314590136113, -122.443898565568)
24426 11480 3 155 10X Jennings St 6 1 1 2   02/20/2008 12:00:00 AM 1 3X3   6012892.419875 2089345.335603 37.7176702433836 -122.397397833393 (37.7176702433836, -122.397397833393)
52863 193537 3 155 2x Dukes Ct 6 3 1 2     13     6016137.541569999 2096287.1710299999 37.736911298305394 -122.386664611588 (37.7369112983054, -122.386664611588)
64916 193539 3 155 2x Dukes Ct 8 3 1 2     53     6016139.60304 2096356.71022 37.7371023529977 -122.3866623318 (37.7371023529977, -122.3866623318)
78332 11476 3 155 10X Jennings St 2 1 1 2   02/20/2008 12:00:00 AM 6 3X3   6012892.419875 2089345.335603 37.7176702433836 -122.397397833393 (37.7176702433836, -122.397397833393)
80896 11479 3 155 10X Jennings St 5 1 1 2   02/20/2008 12:00:00 AM 3 3X3   6012892.419875 2089345.335603 37.7176702433836 -122.397397833393 (37.7176702433836, -122.397397833393)
86699 32726 3 155 200X Farallones St 7 1 1 4 2 10/29/1996 12:00:00 AM 20 6x9 Permit Number 37116 5995015.41074948 2088495.64250033 37.7143256328225 -122.45912868181601 (37.7143256328225, -122.459128681816)
87708 32729 3 155 200X Farallones St 8 1 1 4 2 10/29/1996 12:00:00 AM 12 3x3 Permit Number 37116 5995015.41074948 2088495.64250033 37.7143256328225 -122.45912868181601 (37.7143256328225, -122.459128681816)
98638 11485 3 155 10X Jennings St 11 1 1 2   02/20/2008 12:00:00 AM 3 3X3   6012892.419875 2089345.335603 37.7176702433836 -122.397397833393 (37.7176702433836, -122.397397833393)
117844 24729 3 155 7426 Geary Blvd 1 1 1 2   12/11/2002 12:00:00 AM 3 3X3   5983935.56611 2112495.9733599997 37.7795807585716 -122.49919672398701 (37.7795807585716, -122.499196723987)
119394 42643 3 155 1600X GREEN ST 2 1 1 4 2 06/26/2000 12:00:00 AM 12 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
119826 11490 3 155 100 Jennings St 4 1 1 2   02/20/2008 12:00:00 AM 3 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
142357 42987 3 155 2X Yale St 5 1 1 4 2 09/16/2000 12:00:00 AM 8 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
142877 16478 3 155 9X Newhall St 12 1 1 2   05/16/1997 12:00:00 AM 6 3X3   6018697.204870099 2097076.1109207 37.73921894851821 -122.37786936428301 (37.7392189485182, -122.377869364283)
145909 42986 3 155 2X Yale St 4 1 1 4 2 09/16/2000 12:00:00 AM 3 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
167021 193538 3 155 2x Dukes Ct 7 3 1 2     12     6016137.39736 2096296.36368 37.7369365314813 -122.386665751027 (37.7369365314813, -122.386665751027)
Powered by Datasette · Query took 34.792ms · Data source: data.sfgov.org