sf-trees

Data source: data.sfgov.org

Custom SQL query returning 15 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
19473 61098 1 98 806 Shotwell St 1 1 1 1 1 09/24/1988 12:00:00 AM   3x3 Permit Number 25594 6007925.06671696 2103219.75918175 37.7554885536992 -122.41554954379299 (37.7554885536992, -122.415549543793)
44081 56991 1 98 4160 26th St 1 1 1 1   08/27/1974 12:00:00 AM     Permit Number 767882 6002854.60493399 2100676.90172362 37.74822015482471 -122.432903090117 (37.7482201548247, -122.432903090117)
79808 37377 1 98 755 Morse St 11 5 1 1 1 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
84241 37371 1 98 755 Morse St 5 5 1 1 1 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
85503 96631 1 98 1212 10th Ave 2 1 1 1   11/24/2015 12:00:00 AM   4x4 Permit Number 776835 5993035.2 2107183.3 37.7655231963247 -122.467331039359 (37.7655231963247, -122.467331039359)
88223 94197 1 98 355 Ocean Ave 5 1 1 1   05/25/2010 12:00:00 AM   3x3 Permit Number 53723 5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662)
101049 94198 1 98 355 Ocean Ave 6 1 1 1   05/25/2010 12:00:00 AM   3x3 Permit Number 53723 5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662)
123231 88829 1 98 4437 20th St   1 2 1   09/30/2008 12:00:00 AM   8x1 Permit Number 51764 6001659.0 2104076.0 37.757485378077604 -122.43728079846599 (37.7574853780776, -122.437280798466)
125354 113803 1 98 806 SHOTWELL ST 2 1 1 1 1     3x3   6007931.0 2103220.0 37.755489548438 -122.41552904166201 (37.755489548438, -122.415529041662)
128554 93164 1 98 201 Upper Ter 2 5 2 1   12/22/2009 12:00:00 AM   1x2   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
139023 37379 1 98 755 Morse St 13 5 1 1 1 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
139298 92611 1 98 3856 23rd St   6 2 1   08/31/2009 12:00:00 AM     Permit Number 52924 6004067.0 2102488.0 37.753261698893496 -122.428839761175 (37.7532616988935, -122.428839761175)
141935 65625 1 98 238 Ney St 1 1 1 1 1 02/07/1990 12:00:00 AM     Permit Number 28533 6004892.15539073 2094035.47955331 37.73009967019979 -122.42538473936399 (37.7300996701998, -122.425384739364)
143838 89015 1 98 4437 20th St   1 2 1   09/30/2008 12:00:00 AM   3x1 Permit Number 51764 6001659.0 2104076.0 37.757485378077604 -122.43728079846599 (37.7574853780776, -122.437280798466)
144925 93163 1 98 201 Upper Ter 1 5 2 1   12/22/2009 12:00:00 AM   1x15   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
Powered by Datasette · Query took 47.845ms · Data source: data.sfgov.org