sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
145744 109499 1 7 99 Surrey St 1 1 2 1 1 02/19/2015 12:00:00 AM 3 3x3 Permit Number 774984 6002392.9 2096233.9 37.7359945088656 -122.43418207236999 (37.7359945088656, -122.43418207237)
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)
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)
101905 97139 2 19 937 Goettingen St   25 2 1           6011052.0 2090410.0 37.720490952554606 -122.40383424464399 (37.7204909525546, -122.403834244644)
91444 107078 2 17 92 Homestead St   5 2 1   07/25/2014 12:00:00 AM   3x3.5 Permit Number 773562 6000948.33481 2101213.46128 37.7495851129185 -122.439533357227 (37.7495851129185, -122.439533357227)
101718 109770 1 192 9 Pomona St 1 1 2 1   12/29/2015 12:00:00 AM   6x7 Permit Number 774437 6014227.8 2094671.9 37.7323701819213 -122.393154495945 (37.7323701819213, -122.393154495945)
110212 110320 7 54 9 Imperial Aly   13 2 1           6005040.9 2119421.8 37.7998128500526 -122.426677597274 (37.7998128500526, -122.426677597274)
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)
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)
152708 117679 2 106 7800 Geary Blvd 2 1 2 1     19 Width 3ft   5982700.570040001 2112440.0728599997 37.7793547453385 -122.50346489390199 (37.7793547453385, -122.503464893902)
119638 109607 5 98 775 Congo St 1 7 2 1           6000381.8 2095947.7 37.7350943222142 -122.44111470541901 (37.7350943222142, -122.441114705419)
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)
99533 100242 5 17 76 Linda St   10 2 1           6005815.0 2105046.0 37.76038415245 -122.422976606568 (37.76038415245, -122.422976606568)
91008 120156 6 43 758 10th Ave 1 1 2 1     10     5992930.0 2110298.0 37.77406925887279 -122.467921468059 (37.7740692588728, -122.467921468059)
81298 104856 1 54 739 27th St   1 2 1   02/12/2015 12:00:00 AM 3     6001722.3 2099959.7 37.746186600460604 -122.43676722664301 (37.7461866004606, -122.436767226643)
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)
41228 117919 2 284 727 41st Ave 2 1 2 1     3 Width 3ft   5983193.78874 2110818.2250200002 37.774930606826 -122.501638652158 (37.774930606826, -122.501638652158)
24006 191506 2 284 725 18th St 1 9 2 1     12 Width 2ft   6015277.21856 2105757.38147 37.7628668405556 -122.390300611982 (37.7628668405556, -122.390300611982)
34525 191507 2 284 725 18th St 3 9 2 1     6 Width 2ft   6015301.62259 2105759.06622 37.7628728201497 -122.39021632394699 (37.7628728201497, -122.390216323947)
102661 117259 1 54 670 Eddy St 1 5 2 1       3x3   6007197.5 2113350.2 37.7832634280904 -122.418784110751 (37.7832634280904, -122.418784110751)
105108 104859 1 54 650 Fillmore St   1 2 1           6003597.7 2110555.4 37.775386259915 -122.43103844044701 (37.775386259915, -122.431038440447)
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)
129188 105003 2 98 607 CONGO ST   9 2 1           6000094.1 2095817.0 37.73471905904071 -122.44210000591002 (37.7347190590407, -122.44210000591)
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)
88984 109756 1 54 601 Steiner St 3 5 2 1       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531)
118010 109755 1 54 601 Steiner St 2 5 2 1       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531)
121197 109754 1 54 601 Steiner St 1 5 2 1       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531)
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)
3639 253517 1 54 559 24th Ave 2 5 2 1   09/15/2017 12:00:00 AM 3 2x4.5   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3643 253515 1 54 559 24th Ave 1 1 2 1   09/15/2017 12:00:00 AM 3 7x9.5   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3650 253518 1 54 559 24th Ave 3 5 2 1   09/15/2017 12:00:00 AM 3 2x1   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3660 253516 1 54 559 24th Ave 1 5 2 1   09/15/2017 12:00:00 AM 3 2x2   5988392.0 2112177.0 37.778965370493495 -122.483756799769 (37.7789653704935, -122.483756799769)
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)
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)
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)
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)
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)
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)
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)
97877 121418 5 226 521 Lakeview Ave 1 5 2 1       3x3   5996348.0 2089857.0 37.718140121256106 -122.45462104638399 (37.7181401212561, -122.454621046384)
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)
114798 105147 1 18 52 Mirabel Ave   1 2 1   12/26/2013 12:00:00 AM   3X3 Permit Number 771012 6007663.7 2099931.8 37.7464458666696 -122.41622057503099 (37.7464458666696, -122.416220575031)
79432 106576 5 64 507 STEINER ST 1 7 2 1           6003113.3 2110111.6 37.7741402349502 -122.432682383122 (37.7741402349502, -122.432682383122)
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)
114314 108701 1 12 478 30th St   1 2 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774626 6003507.49152 2098366.3309400002 37.7419128730633 -122.43048058961 (37.7419128730633, -122.43048058961)
10092 173852 1 54 450 Toland St 7 1 2 1   01/27/2017 12:00:00 AM 3 8.5x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10093 173849 1 54 450 Toland St 4 1 2 1   01/27/2017 12:00:00 AM 3 17.6x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10096 173850 1 54 450 Toland St 5 1 2 1   01/27/2017 12:00:00 AM 3 13.9x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10097 173851 1 54 450 Toland St 6 1 2 1   01/27/2017 12:00:00 AM 3 27.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10098 173848 1 54 450 Toland St 3 1 2 1   01/27/2017 12:00:00 AM 3 19.5x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10101 173846 1 54 450 Toland St 1 1 2 1   01/27/2017 12:00:00 AM 3 15x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10104 173847 1 54 450 Toland St 2 1 2 1   01/27/2017 12:00:00 AM 3 11.85x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10106 173853 1 54 450 Toland St 8 1 2 1   01/27/2017 12:00:00 AM 3 26.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
105398 117608 1 54 450 Hayes St 1 1 2 1   06/29/2016 12:00:00 AM 3     6005708.4 2111040.6 37.776837876057 -122.423771533631 (37.776837876057, -122.423771533631)
87925 104864 1 54 45 Hoffman Ave   1 2 1           6000629.3 2102650.0 37.7535113392088 -122.440739618385 (37.7535113392088, -122.440739618385)
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)
112497 104858 1 54 4205 24th St   5 2 1           6001816.0 2101720.7 37.7510272133613 -122.43656924920201 (37.7510272133613, -122.436569249202)
119565 99732 2 98 4150 Ocean Ave 1 5 2 1           5986619.2 2095203.6 37.7322576937009 -122.48864164528798 (37.7322576937009, -122.488641645288)
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)
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)
80680 117478 2 64 400 PERALTA AVE 1 7 2 1       3x3   6009762.0 2099359.0 37.7449908466617 -122.40892445167499 (37.7449908466617, -122.408924451675)
99380 119616 5 54 400 Grove St 1 1 2 1   07/28/2016 12:00:00 AM 3     6005873.6969099995 2111410.5639299997 37.777863036884796 -122.42322602570499 (37.7778630368848, -122.423226025705)
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)
94709 117610 2 98 391 NEVADA ST 1 14 2 1       3x3   6008958.0 2096497.0 37.737087351465796 -122.41150238578501 (37.7370873514658, -122.411502385785)
963 251419 2 50 39 Jones St 2 1 2 1   04/14/2015 12:00:00 AM   3x3   6009068.0 2112723.0 37.781646426577 -122.412268559085 (37.781646426577, -122.412268559085)
970 251418 2 50 39 Jones St 1 1 2 1   04/14/2015 12:00:00 AM   3x3   6009068.0 2112723.0 37.781646426577 -122.412268559085 (37.781646426577, -122.412268559085)
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)
79103 120636 5 64 385 Nevada St 1 5 2 1       3x3   6008960.0 2096519.0 37.7371478708762 -122.411497024701 (37.7371478708762, -122.411497024701)
443 251293 2 54 3789 Market St 1 5 2 1       3x3   6000208.0 2102740.0 37.753734455764 -122.44220302061701 (37.753734455764, -122.442203020617)
178249 227519 2 284 375 Alabama St 1 4 2 1     8 Width 3ft   6008967.54586 2106408.18704 37.7643017925286 -122.41216964832199 (37.7643017925286, -122.412169648322)
79393 106516 1 17 366 Hill St   1 2 1   05/07/2014 12:00:00 AM   3X3 Permit Number 772751 6003996.2 2103381.7 37.755711581068795 -122.42914832014 (37.7557115810688, -122.42914832014)
83840 107144 2 54 360 Spear St 1 1 2 1           6015708.0 2115219.0 37.7888702311939 -122.38947147438 (37.7888702311939, -122.38947147438)
101229 85273 1 17 36 Santa Cruz Ave   5 2 1           5993017.1 2086630.8 37.709090137513 -122.465900153218 (37.709090137513, -122.465900153218)
143940 106932 2 98 358 SHOTWELL ST 1 1 2 1       8x10   6007793.2 2105846.4 37.7626932925098 -122.416191600332 (37.7626932925098, -122.416191600332)
122339 104861 1 54 3458A 18th St   5 2 1           6006508.0 2105569.9 37.7618617394874 -122.42061702780899 (37.7618617394874, -122.420617027809)
110920 85195 1 17 333 Eucalyptus Dr   5 2 1           5990168.0 2094689.0 37.731051182582604 -122.47633519175501 (37.7310511825826, -122.476335191755)
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)
114285 96183 1 17 330 South Van Ness Ave   8 2 1           6007366.0 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618)
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)
98437 113995 1 54 3221 Washington St 1 1 2 1   10/27/2015 12:00:00 AM   39x3   5999265.7 2115942.6 37.789931692456996 -122.44641142836599 (37.789931692457, -122.446411428366)
42994 109343 1 54 3211 Baker St 2 9 2 1   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
97307 109345 1 54 3211 Baker St 4 9 2 1   02/11/2015 12:00:00 AM 3 8.75x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
99464 109344 1 54 3211 Baker St 3 9 2 1   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
140543 109342 1 54 3211 Baker St 1 9 2 1   02/11/2015 12:00:00 AM 3 1x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
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)
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)
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)
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)
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)
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)
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)
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)
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)
120634 116580 6 98 3000x 19TH AVE 3 5 2 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
113148 104375 2 17 30 GARDENSIDE DR 1 3 2 1       50x50   5999465.0 2102094.0 37.7519183246276 -122.444726043725 (37.7519183246276, -122.444726043725)
4723 253676 1 54 2975 Van Ness Ave 6 5 2 1   10/24/2017 12:00:00 AM 3 3.2x3.75   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
4726 253675 1 54 2975 Van Ness Ave 1 5 2 1   10/24/2017 12:00:00 AM 3 3.2x14.2   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
Powered by Datasette · Query took 5.501ms · Data source: data.sfgov.org