sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
96456 5412 1 17 414 Dolores St 1 1 2 1   07/07/2008 12:00:00 AM   3x3   6004849.3785887 2105949.0211321 37.7628090992038 -122.426380541105 (37.7628090992038, -122.426380541105)
1361 16698 3 26 950X Noriega St 2 11 2 2     12 8   5991017.9677099995 2103156.31666 37.7543495107367 -122.47401428523999 (37.7543495107367, -122.47401428524)
13970 17450 3 284 1967 Palou Ave 4 1 2 2     42 3X3   6012966.10245 2096645.10936 37.7377180333685 -122.397654855789 (37.7377180333685, -122.397654855789)
102823 20136 1 82 890 Steiner St 1 1 2 1   01/11/2011 12:00:00 AM 3 8x4 Permit Number 54087 6003007.0 2111306.0 37.777413731872 -122.43313545029301 (37.777413731872, -122.433135450293)
81307 20137 1 82 898 Steiner St 1 1 2 1   01/11/2011 12:00:00 AM 3 8x4 Permit Number 54088 6003009.7075288 2111327.5412022998 37.777473032235704 -122.433127623561 (37.7774730322357, -122.433127623561)
80289 79468 1 11 606 Webster St 1 1 2 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52423 6004042.90191121 2110875.50885644 37.7762904169609 -122.42952121696301 (37.7762904169609, -122.429521216963)
102817 80937 1 37 3124-3128 Laguna St 2 1 2 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52345 6003823.24826281 2119450.20874415 37.7998219368855 -122.43089315213301 (37.7998219368855, -122.430893152133)
84751 82096 1 18 1363 Francisco St 1 1 2 1   07/01/2009 12:00:00 AM   3x3 Permit Number 52338 6004802.97001971 2120513.88344233 37.802797975517294 -122.42757877147899 (37.8027979755173, -122.427578771479)
107476 82512 1 12 52 Tulane St 1 1 2 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52482 6007264.0 2093867.0 37.7297707824944 -122.41717301728399 (37.7297707824944, -122.417173017284)
107768 82751 1 147 52 Sheridan St 1 1 2 1   07/07/2009 12:00:00 AM 3 3x3 Permit Number 52446 6009256.89976445 2109417.42292722 37.772580689338 -122.41138145626002 (37.772580689338, -122.41138145626)
107139 82886 1 134 761 Clementina St 1 1 2 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52437 6009240.34446046 2110165.45314704 37.7746336766823 -122.41149158097299 (37.7746336766823, -122.411491580973)
97501 82889 1 37 1423 Francisco St 1 1 2 1   07/01/2009 12:00:00 AM   3x3 Permit Number 52339 6004509.13864627 2120473.3950974997 37.8026701808582 -122.42859269053001 (37.8026701808582, -122.42859269053)
128027 82995 1 12 1412 Quesada Ave 1 1 2 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52364 6016260.71862294 2093905.81391215 37.730379387125204 -122.38607277339099 (37.7303793871252, -122.386072773391)
127755 83007 1 457 1058 De Haro St 1 11 2 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52381 6012170.46860809 2103464.70975517 37.7563988530014 -122.40088475581499 (37.7563988530014, -122.400884755815)
84066 83339 1 51 2233 28th Ave 1 1 2 1   07/01/2009 12:00:00 AM   3x3 Permit Number 52332 5987590.2167451 2100087.03718588 37.7457229434205 -122.485642930331 (37.7457229434205, -122.485642930331)
99500 83367 1 37 3124-3128 Laguna St 1 1 2 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52345 6003823.24826281 2119450.20874415 37.7998219368855 -122.43089315213301 (37.7998219368855, -122.430893152133)
92708 85104 1 19 1403 11th Ave 1 5 2 1     9 2x2 Tree 1 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
85124 85121 1 19 1403 11th Ave 2 5 2 1   02/27/2007 12:00:00 AM 7 2x2 Tree 2. Permit Number 49495. 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
115664 85184 1 49 501 Bartlett St   5 2 1   12/13/2006 12:00:00 AM   3x25 Permit Number 768657 6006822.0 2100867.0 37.748966349809606 -122.419197411761 (37.7489663498096, -122.419197411761)
110920 85195 1 17 333 Eucalyptus Dr   5 2 1           5990168.0 2094689.0 37.731051182582604 -122.47633519175501 (37.7310511825826, -122.476335191755)
101229 85273 1 17 36 Santa Cruz Ave   5 2 1           5993017.1 2086630.8 37.709090137513 -122.465900153218 (37.709090137513, -122.465900153218)
97405 85294 1 86 2255 Mariposa St   5 2 1   07/27/2007 12:00:00 AM   2x50 Permit Number 49675 6010752.0 2105977.0 37.7632178155038 -122.40596731591499 (37.7632178155038, -122.405967315915)
92510 88654 1 461 94 Danton St   5 2 1   08/05/2008 12:00:00 AM     Permit Number 51634 6002844.0 2094598.0 37.7315282931893 -122.43250562955099 (37.7315282931893, -122.432505629551)
120372 88656 1 461 94 Danton St   5 2 1   08/05/2008 12:00:00 AM     Permit Number 51634 6002844.0 2094598.0 37.7315282931893 -122.43250562955099 (37.7315282931893, -122.432505629551)
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)
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)
117077 89137 1 17 3170 23rd St   1 2 1   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373001 (37.7541940143569, -122.41572017373)
111084 89138 1 17 3170 23rd St   1 2 1   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373001 (37.7541940143569, -122.41572017373)
86139 89139 1 17 3170 23rd St   5 2 1   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373001 (37.7541940143569, -122.41572017373)
125875 89140 1 17 3170 23rd St   5 2 1   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373001 (37.7541940143569, -122.41572017373)
101836 92072 1 168 3001 Pacific Ave   5 2 1   06/18/2009 12:00:00 AM     Permit Number 52188 5999733.7 2116663.4 37.791937538515604 -122.444844029888 (37.7919375385156, -122.444844029888)
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)
113495 92775 1 17 2701 Pacific Ave   1 2 1   10/15/2009 12:00:00 AM     Permit Number 52996 6001178.5 2116864.5 37.7925720539586 -122.43985945141 (37.7925720539586, -122.43985945141)
92559 92776 1 4 2701 Pacific Ave   5 2 1   10/15/2009 12:00:00 AM     Permit Number 52996 6001178.5 2116864.5 37.7925720539586 -122.43985945141 (37.7925720539586, -122.43985945141)
109480 92778 1 4 2701 Pacific Ave   5 2 1   10/15/2009 12:00:00 AM     Permit Number 52996 6001178.5 2116864.5 37.7925720539586 -122.43985945141 (37.7925720539586, -122.43985945141)
96749 93115 1 75 397 San Jose Ave 1 21 2 1   02/02/2009 12:00:00 AM   26x6 Permit Number 53167 6006259.6 2100887.6 37.7489912240508 -122.42114365927 (37.7489912240508, -122.42114365927)
143915 93160 1 17 201 Upper Ter 1 5 2 1   12/22/2009 12:00:00 AM   1x1   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
143329 93161 1 17 201 Upper Ter 2 5 2 1   12/22/2009 12:00:00 AM   1x1   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
86307 93162 1 17 201 Upper Ter 3 5 2 1   12/22/2009 12:00:00 AM   3x3   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
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)
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)
87250 93936 1 17 230 Seacliff Ave   21 2 1   04/26/2010 12:00:00 AM   37x6   5987086.7 2115743.7 37.7886824393648 -122.488534508212 (37.7886824393648, -122.488534508212)
94304 94961 1 17 3098 PACIFIC AVE 1 5 2 1   10/25/2010 12:00:00 AM       5999362.0 2116697.0 37.792008575714 -122.446132526841 (37.792008575714, -122.446132526841)
140567 94962 1 17 3098@Lyon Pacific Ave   5 2 1   10/25/2010 12:00:00 AM       5999362.0 2116697.3 37.7920093994348 -122.44613254842899 (37.7920093994348, -122.446132548429)
25407 95032   17 211 Maynard St   8 2 1           6004772.0 2093802.0 37.729451797878205 -122.425783519869 (37.7294517978782, -122.425783519869)
79071 95369   17 27 Hartford St   8 2 1   02/18/2011 12:00:00 AM       6002651.0 2105744.0 37.7621216467866 -122.433969295968 (37.7621216467866, -122.433969295968)
138475 96182 1 17 330 South Van Ness Ave   8 2 1   04/04/2011 12:00:00 AM     Permit Number 767813 6007366.0 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618)
114285 96183 1 17 330 South Van Ness Ave   8 2 1           6007366.0 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618)
16044 96231 1 17     1 2 1                    
11641 96232 1 17     1 2 1                    
10638 96234 1 17     1 2 1   04/15/2011 12:00:00 AM     Permit Number 767856          
105459 96289 1 17 228 30th St   1 2 1         Permit Number 767877 6005120.0 2098458.0 37.7422557889482 -122.42491157296699 (37.7422557889482, -122.424911572967)
100936 96291 1 17 1294 Union St   6 2 1   03/21/2011 12:00:00 AM       6006773.0 2119090.0 37.7989995844362 -122.420660308797 (37.7989995844362, -122.420660308797)
80534 96292 1 17 1294 Union St   6 2 1   03/21/2011 12:00:00 AM       6006773.0 2119090.0 37.7989995844362 -122.420660308797 (37.7989995844362, -122.420660308797)
101905 97139 2 19 937 Goettingen St   25 2 1           6011052.0 2090410.0 37.720490952554606 -122.40383424464399 (37.7204909525546, -122.403834244644)
104353 98250 1 17 650 Eddy St   1 2 1         Sidewalk landscaping permit adjacent to building. 6007271.2 2113371.6 37.783326336649 -122.41853065554 (37.783326336649, -122.41853065554)
82720 98465 7 17 190 Portola Dr   13 2 1           5999550.3 2100620.3 37.7478767693988 -122.444325170302 (37.7478767693988, -122.444325170302)
115357 98501 7 17 232 Glenview Dr   13 2 1           5998998.0 2100740.0 37.748173910048706 -122.446243600021 (37.7481739100487, -122.446243600021)
80672 98502 7 17 244 Glenview Dr   13 2 1           5999066.0 2100737.0 37.7481695560511 -122.44600824337601 (37.7481695560511, -122.446008243376)
145716 98878 7 17 11 Panorama Dr   13 2 1           5998029.0 2100213.0 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849)
99802 98890 7 17 256 Glenview Dr   13 2 1           5999134.0 2100748.0 37.748203642185395 -122.44577389345 (37.7482036421854, -122.44577389345)
98291 98892 7 17 220 Glenview Dr   13 2 1           5998935.0 2100753.0 37.7482060067302 -122.44646238623999 (37.7482060067302, -122.44646238624)
94734 98893 7 17 216 Glenview Dr   13 2 1           5998910.0 2100761.0 37.7482265448319 -122.44654941060699 (37.7482265448319, -122.446549410607)
127072 99201 1 17 4016 26th St   1 2 2 1 04/12/2012 12:00:00 AM   6x10.5 Permit Number 768835 6003752.7 2100736.7 37.7484352450997 -122.429801769855 (37.7484352450997, -122.429801769855)
87791 99527 1 17 120 Howard St 1 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
145403 99528 1 17 120 Howard St 2 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
86544 99529 1 17 120 Howard St 3 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
124767 99530 1 17 120 Howard St 4 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
114228 99531 1 17 120 Howard St 5 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
138994 99532 1 17 120 Howard St 6 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
145017 99533 1 17 188 Spear St 1 1 2 1       5x9   6014774.7 2116168.9 37.791426646732894 -122.39276706915899 (37.7914266467329, -122.392767069159)
138642 99534 1 17 188 Spear St 2 1 2 1       5x9   6014774.7 2116168.9 37.791426646732894 -122.39276706915899 (37.7914266467329, -122.392767069159)
129064 99535 1 17 188 Spear St 3 1 2 1       5x9   6014774.7 2116168.9 37.791426646732894 -122.39276706915899 (37.7914266467329, -122.392767069159)
82677 99536 1 17 188 Spear St 4 1 2 1       5x9   6014774.7 2116168.9 37.791426646732894 -122.39276706915899 (37.7914266467329, -122.392767069159)
100274 99610 2 17 111 Corwin St   14 2 1           6000616.0 2104331.0 37.7581261988062 -122.44090619353999 (37.7581261988062, -122.44090619354)
119565 99732 2 98 4150 Ocean Ave 1 5 2 1           5986619.2 2095203.6 37.7322576937009 -122.48864164528798 (37.7322576937009, -122.488641645288)
99533 100242 5 17 76 Linda St   10 2 1           6005815.0 2105046.0 37.76038415245 -122.422976606568 (37.76038415245, -122.422976606568)
81443 100355 1 18 591 Waller St   1 2 1   12/30/2014 12:00:00 AM 3 27x6 Permit Number 769031 6002899.6 2108847.2 37.770656382716396 -122.43333123962 (37.7706563827164, -122.43333123962)
89166 102275 7 17 267 Topaz Way   13 2 1           6001225.6 2097744.2 37.740075118911705 -122.438326054857 (37.7400751189117, -122.438326054857)
97106 102276 5 17 279 Topaz Way   13 2 1           6001205.6 2097796.6 37.7402178594385 -122.43839895973301 (37.7402178594385, -122.438398959733)
102839 102414 2 60 1301 Page St 2 1 2 1           6000345.0 2109213.0 37.77151552050871 -122.44219387377399 (37.7715155205087, -122.442193873774)
100486 103619 2 17 1200 Monterey Blvd 1 7 2 1           5994284.3 2094292.0 37.7301989768893 -122.46207576474701 (37.7301989768893, -122.462075764747)
89308 103623 1 241 333 El Camino Del Mar 1 5 2 1   06/04/2013 12:00:00 AM   13x2 Permit Number 770205 5987603.5 2115303.5 37.787503918723395 -122.48671414227199 (37.7875039187234, -122.486714142272)
95495 104151 1 54 525X Church St 1 5 2 4 4     2x58   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
81163 104152 1 54 525X Church St 2 5 2 4 4     2x68   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
141475 104153 1 54 525X Church St 1 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
113603 104154 1 54 525X Church St 2 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
81722 104155 1 54 525X Church St 3 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
92935 104156 1 54 525X Church St 4 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
96077 104157 1 54 525X Church St 5 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
95556 104158 1 54 525X Church St 6 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
142588 104374 2 17 22 GARDENSIDE DR 1 3 2 1       50x50   5999468.0 2101996.0 37.7516494117124 -122.444708626009 (37.7516494117124, -122.444708626009)
113148 104375 2 17 30 GARDENSIDE DR 1 3 2 1       50x50   5999465.0 2102094.0 37.7519183246276 -122.444726043725 (37.7519183246276, -122.444726043725)
120169 104564 5 64 18 FLOOD AVE 1 7 2 1           6000327.0 2094154.0 37.730166118083794 -122.44117551704201 (37.7301661180838, -122.441175517042)
138621 104565 5 64 18 FLOOD AVE 1 7 2 1           6000327.0 2094154.0 37.730166118083794 -122.44117551704201 (37.7301661180838, -122.441175517042)
141674 104634 1 54 217 Montcalm St   7 2 1       16x16   6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229)
118218 104635 1 54 217 Montcalm St   7 2 1       16x16   6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229)
111744 104636 1 54 217 Montcalm St   7 2 1       16x16   6010036.0 2099691.0 37.7459177905176 -122.40800041337499 (37.7459177905176, -122.408000413375)
94853 104637 1 54 217 Montcalm St   7 2 1       16x16   6010036.0 2099691.0 37.7459177905176 -122.40800041337499 (37.7459177905176, -122.408000413375)
128347 104667 1 18 172 Clipper St 1 1 2 1 1 01/19/2016 12:00:00 AM   6x12 Permit Number 777366 6003998.6 2101043.1 37.749290469922705 -122.42897329466999 (37.7492904699227, -122.42897329467)
Powered by Datasette · Query took 4.37ms · Data source: data.sfgov.org