sf-trees

Data source: data.sfgov.org

Custom SQL query returning 26 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
24465 95104 1 88 2200 Beach St 3 5 1 1   01/08/2008 12:00:00 AM 5     5999633.730169999 2120895.6152 37.803552367813104 -122.445494383786 (37.8035523678131, -122.445494383786)
66339 84782 1 88 228 Mississippi St 1 1 1 1   03/20/2007 12:00:00 AM 5   Permit No. 49243 6013990.15625 2105982.3752200003 37.763413148108505 -122.394767902514 (37.7634131481085, -122.394767902514)
179016 56947 1 88 690 Arkansas St 1 1 1 1   08/27/1974 12:00:00 AM 5   Permit Number 14199 6012986.78866 2103864.51855 37.7575421408828 -122.398089663624 (37.7575421408828, -122.398089663624)
10311 27188 1 88 258 Silver Ave 1 1 1 1   11/25/2002 12:00:00 AM 5 2X3   6002908.14927 2093727.2885 37.729141154025506 -122.43222169348999 (37.7291411540255, -122.43222169349)
2537 230348 2 88 280 Arlington St 1 1 1 1     5 3x3   6004547.50076 2096560.5372400002 37.7370134334286 -122.42675600438 (37.7370134334286, -122.42675600438)
76734 88076 1 88 674 Thornton Ave 1 1 1 1   06/24/2008 12:00:00 AM 5 3x3 Permit Number 51071 6011923.037330001 2094336.6439200002 37.731321332804605 -122.40109909554701 (37.7313213328046, -122.401099095547)
138212 94884 1 88 2010 Quesada Ave 1 1 1 1 1 11/23/2010 12:00:00 AM 5 3x3 Permit Number 53951 6013072.55459 2096282.04692 37.736727066797 -122.397261344859 (37.736727066797, -122.397261344859)
146771 88351 1 88 700 Vienna St 1 1 1 1   07/10/2008 12:00:00 AM 5 3x3 Permit Number 51333 6002622.22718 2089414.5665400003 37.7172831683531 -122.432902166399 (37.7172831683531, -122.432902166399)
168943 88037 1 88 2301X Lyon St 7 1 1 1   06/23/2008 12:00:00 AM 5 3x3 Permit Number 51052 5999275.57165 2116691.87228 37.7919895603315 -122.446431199448 (37.7919895603315, -122.446431199448)
51534 110564 2 88 135 Theresa St 3 1 1 1     5 3x9   6002092.75194 2093699.4633900002 37.7290184865087 -122.43503859588199 (37.7290184865087, -122.435038595882)
171641 177409 2 88 659 Madrid St 1 1 1 1     5 Width 2ft   6002137.168430001 2090084.38724 37.719094822944996 -122.434626653316 (37.719094822945, -122.434626653316)
2512 178827 2 88 927 Brazil Ave 3 1 1 1     5 Width 3ft   6004338.08735 2090755.04432 37.7210610008535 -122.427066663506 (37.7210610008535, -122.427066663506)
49891 177413 2 88 518 Athens St 1 1 1 1     5 Width 3ft   6003506.69699 2090312.38662 37.719798511885706 -122.42990897621401 (37.7197985118857, -122.429908976214)
50219 230323 2 88 12 Chattanooga St 1 1 1 1     5 Width 3ft   6004674.70805 2103511.60917 37.7561066672951 -122.42681107348601 (37.7561066672951, -122.426811073486)
55341 130999 2 88 2009 Jones St 1 1 1 1     5 Width 3ft   6008124.35834 2119571.24818 37.8003970406522 -122.41601824307101 (37.8003970406522, -122.416018243071)
61520 130998 2 88 2201 Leavenworth St 4 9 1 1     5 Width 3ft   6007580.24685 2119942.9983 37.8013871663302 -122.41792745790899 (37.8013871663302, -122.417927457909)
67518 230357 2 88 137 Randall St 1 1 1 1     5 Width 3ft   6004642.1298400005 2097534.3319200003 37.739692602838296 -122.426498147168 (37.7396926028383, -122.426498147168)
74720 131004 2 88 1109 Sansome St 2 1 1 1     5 Width 3ft   6011962.5768099995 2119524.82057 37.8004846103385 -122.402733131341 (37.8004846103385, -122.402733131341)
154873 230319 2 88 119 Day St 1 1 1 1     5 Width 3ft   6005056.96104 2098704.0891400003 37.7429279327818 -122.425147048897 (37.7429279327818, -122.425147048897)
161788 130997 2 88 2201 Leavenworth St 2 9 1 1     5 Width 3ft   6007578.93915 2119952.7888599997 37.8014139751467 -122.417932677574 (37.8014139751467, -122.417932677574)
168525 177402 2 88 670 Vienna St 1 1 1 1     5 Width 3ft   6002753.398469999 2089622.73249 37.7178621851574 -122.43246362908701 (37.7178621851574, -122.432463629087)
172322 230356 2 88 137 Randall St 2 1 1 1     5 Width 3ft   6004658.9023 2097536.10277 37.73969841334279 -122.42644028119 (37.7396984133428, -122.42644028119)
183043 230286 2 88 3714 Cesar Chavez St 1 1 1 1     5 Width 3ft   6005720.70834 2100540.1162799997 37.748006719144 -122.42298245807899 (37.748006719144, -122.422982458079)
62272 177397 2 88 650 France Ave 2 1 1 1     5 Width 4ft   6002573.73742 2089477.3552599999 37.717452821874105 -122.433074256169 (37.7174528218741, -122.433074256169)
73090 123057 2 88 514 Funston Ave 2 2 1 1     5 Width 4ft   5991919.1397400005 2111920.98536 37.778467110254795 -122.47153646453998 (37.7784671102548, -122.47153646454)
73543 193322 2 88 2111 18th St 4 1 1 1     5 Width 4ft   6011436.66428 2105551.33646 37.762087307318104 -122.403569326371 (37.7620873073181, -122.403569326371)
Powered by Datasette · Query took 5.082ms · Data source: data.sfgov.org