sf-trees

Data source: data.sfgov.org

Custom SQL query returning 30 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
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)
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)
97737 30166 3 98 410X Mansell St 25 11 1 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
100801 30165 3 98 410X Mansell St 22 11 1 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
139594 30164 3 98 410X Mansell St 21 11 1 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
84069 30163 3 98 410X Mansell St 20 11 1 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
109841 30145 3 98 410X Mansell St 7 11 1 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
139595 30143 3 98 410X Mansell St 5 11 1 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
122746 30141 3 98 410X Mansell St 3 11 1 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
108499 30139 3 98 410X Mansell St 1 11 1 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
107074 30054 3 98 610X Junipero Serra Blvd 7 11 1 2           5991361.953164 2093442.6103069999 37.7276980777014 -122.47211671569599 (37.7276980777014, -122.472116715696)
97043 27143 3 98 1775 Silver Ave 4 1 1 2     12 2X3   6011388.84182 2095356.57174 37.7340920254878 -122.403017629645 (37.7340920254878, -122.403017629645)
82634 26499 3 98 2710 Harrison St 3 1 1 2     3 4x3   6008889.7812 2102567.01926 37.7537504562032 -122.41216712165199 (37.7537504562032, -122.412167121652)
9895 24292 3 98 403 Winfield St 1 1 1 2   10/28/1992 12:00:00 AM 3 3X3            
1585 23896 3 98 1581 Webster St 3 1 1 2   05/24/2017 12:00:00 AM 3 3x3   6003535.353102201 2114132.0136397 37.7852032161945 -122.43150950273301 (37.7852032161945, -122.431509502733)
104095 22545 3 98 7 Topaz Way 1 1 1 2     3 2X3   6001395.6747592995 2098711.0868843 37.742739635423206 -122.43780724032301 (37.7427396354232, -122.437807240323)
78136 21133 3 98 2292X Sunset Blvd 2 1 1 2     12     5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696)
119560 21130 3 98 2292X Sunset Blvd 3 1 1 2     12     5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696)
128536 19363 3 98 738 Shields St 1 1 1 2     3 3X3   5992103.0127542 2089880.5617979001 37.7179604248963 -122.469295726054 (37.7179604248963, -122.469295726054)
93443 15888 3 98 5625 Mission St 1 1 1 2     3 3X3   5998561.46984 2087228.1352400002 37.711048567191604 -122.446781008521 (37.7110485671916, -122.446781008521)
94867 15877 3 98 5508 Mission St 1 1 1 2   12/15/1997 12:00:00 AM 3 3X3   5999048.25069 2087729.15393 37.7124520473945 -122.445134579389 (37.7124520473945, -122.445134579389)
92800 12755 3 98 1733 Lake St 1 1 1 2   02/24/2008 12:00:00 AM 3 3X3   5990033.85435 2114674.56985 37.785918437001705 -122.478259694764 (37.7859184370017, -122.478259694764)
91858 9382 3 98 337 Gold Mine Dr 1 1 1 2     0 3X3   6001129.4629101 2097791.8544146 37.74020049817771 -122.43866187060699 (37.7402004981777, -122.438661870607)
127970 4893 3 98 745X Mansell St 1 1 1 2     12 3X3   6009751.8988059005 2090059.5024836997 37.7194558413593 -122.408303589874 (37.7194558413593, -122.408303589874)
118241 4313 3 98 727 Chenery St 1 1 2 2   08/17/2013 12:00:00 AM   3X3   6002321.2517800005 2095689.19659 37.7344948117373 -122.434390856497 (37.7344948117373, -122.434390856497)
Powered by Datasette · Query took 5.709ms · Data source: data.sfgov.org