sf-trees

Data source: data.sfgov.org

Custom SQL query returning 54 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
440 157410 1 58 125 Highland Ave 2 1 1 1   04/06/2017 12:00:00 AM 3 2x5   6005546.67522 2096690.9332 37.7374279129674 -122.423310672857 (37.7374279129674, -122.423310672857)
5660 39923 1 58 0 Arleta Ave 2 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41198          
6711 31341 1 58 430 Hayes St 2 1 1 1   12/29/2014 12:00:00 AM 3 3x3 Permit Number 772811 6005729.4209 2111051.1148 37.7768679337671 -122.423699563703 (37.7768679337671, -122.423699563703)
10397 108837 1 58 699 Paris St 2 1 1 1 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774665 6001210.74249 2089636.42248 37.7178121756617 -122.437796877731 (37.7178121756617, -122.437796877731)
12527 108378 1 58 358 Edinburgh St 2 1 1 1 1 12/19/2014 12:00:00 AM 3 3x3 Permit Number 773808 6003377.41913 2091635.77484 37.7234249209965 -122.43045021882 (37.7234249209965, -122.43045021882)
13070 93869 1 58 400-422X Tocoloma Ave 2 1 1 1 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773818 6012466.99875 2086683.8296 37.7103385819422 -122.398681660343 (37.7103385819422, -122.398681660343)
13992 108725 1 58 877 Rhode Island St 2 1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773104 6011895.30838 2104315.65478 37.758720008153 -122.401896177292 (37.758720008153, -122.401896177292)
14920 37328 1 58   2 1 1 1   06/15/1998 12:00:00 AM     Permit Number 39838          
40968 91228 1 58 250 Texas St 2 1 1 1   02/02/2010 12:00:00 AM 4 3x3 Permit Number 53161 6013714.91861 2105876.83519 37.7631080513185 -122.39571247215 (37.7631080513185, -122.39571247215)
78290 37278 1 58 700 Sanchez St 2 1 1 1   06/15/1998 12:00:00 AM     Permit Number 39817 6003661.86134005 2104206.66341524 37.7579578025996 -122.430363425655 (37.7579578025996, -122.430363425655)
78986 105989 1 58 651X Duncan St 2 1 1 1           6002337.0 2099724.0 37.745574339333 -122.434624822764 (37.745574339333, -122.434624822764)
81516 50910 1 58 2450 17th Ave 2 1 1 1 1 04/26/2004 12:00:00 AM 2 3x9 Permit Number 772737 5991103.05311172 2098729.45888754 37.742199437798 -122.47339717645399 (37.742199437798, -122.473397176454)
82156 36956 1 58 16 05th Ave 2 1 1 1 1 05/29/1998 12:00:00 AM     Permit Number 39587 5994274.56771258 2115474.49567321 37.7883600733979 -122.463646184404 (37.7883600733979, -122.463646184404)
83450 68449 1 58 4054 20th St 2 7 1 1 1 04/24/1999 12:00:00 AM     Permit Number 32307 6003251.17179249 2104206.64930012 37.757934492021604 -122.431783761852 (37.7579344920216, -122.431783761852)
91092 51953 1 58 82 Mary St 2 1 1 1   08/08/2005 12:00:00 AM     Permit Number 48176 6010868.83737248 2112458.01845687 37.781019735711006 -122.40601981145599 (37.781019735711, -122.406019811456)
94464 36069 1 58 1504 Bryant St 2 1 1 1 1 04/19/2002 12:00:00 AM     Permit Number 44775 6009387.99483758 2107777.56202059 37.7680853638298 -122.410812146882 (37.7680853638298, -122.410812146882)
97803 45537 1 58 79 Melba Ave 2 1 1 1   07/24/2001 12:00:00 AM     Permit Number 44293 5989585.76469698 2094846.08328142 37.7314487101847 -122.478359538262 (37.7314487101847, -122.478359538262)
107545 37854 1 58 50 Ina Ct 2 1 1 1   07/07/1998 12:00:00 AM     Permit Number 40144 6004964.50568845 2091639.69049004 37.7235254489092 -122.42496422599702 (37.7235254489092, -122.424964225997)
113561 115771 1 58 1204 Egbert Ave 2 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 775363 6015358.9 2090410.1 37.7207308974409 -122.38894654781099 (37.7207308974409, -122.388946547811)
114122 102090 1 58 27 Santa Ana Ave 2 1 1 1 1 12/18/2012 12:00:00 AM   3x3 Permit Number 769734 5992609.4 2096703.2 37.7367229555432 -122.468041385671 (37.7367229555432, -122.468041385671)
116475 109575 1 58 400 France Ave 2 1 1 1 1 02/24/2015 12:00:00 AM 3 3x3 Permit Number 774875 6002004.0 2089808.9 37.7183308355338 -122.43506727205299 (37.7183308355338, -122.435067272053)
125292 40738 1 58 20 Alviso St 2 1 1 1   08/13/1999 12:00:00 AM     Permit Number 41717 5992072.81756498 2091384.27409538 37.7220875062624 -122.469509497536 (37.7220875062624, -122.469509497536)
127386 42819 1 58 801 Bay St 2 1 1 1 1 09/11/2004 12:00:00 AM     Permit Number 42765 6006945.227660701 2121167.35462349 37.8047131790945 -122.42021185631901 (37.8047131790945, -122.420211856319)
129209 37309 1 58 400 Hill St 2 1 1 1 1 06/15/1998 12:00:00 AM     Permit Number 39826 6003717.20570413 2103355.3114542 37.7556233268944 -122.430111288531 (37.7556233268944, -122.430111288531)
140417 108905 1 58 200 Cordova St 2 1 1 1 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772783 6001785.8 2087307.2 37.7114493293027 -122.43564261659901 (37.7114493293027, -122.435642616599)
144836 51903 1 58 168 Caselli Ave 2 1 1 1   07/18/2005 12:00:00 AM     Permit Number 48111 6000192.99372442 2104905.40226883 37.7596792654558 -122.44241036439301 (37.7596792654558, -122.442410364393)
24848 188408 2 58 2033 22nd St 2 9 1 1     1 Width 3ft   6011976.80987 2103707.86259 37.7570556930855 -122.40157158857299 (37.7570556930855, -122.401571588573)
26902 175812 2 58 15 Athens St 2 9 1 1     2     6005342.42292 2093158.1624099999 37.727716180055204 -122.42376574960899 (37.7277161800552, -122.423765749609)
29820 187571 2 58 73 Bishop St 2 17 1 1     7     6010860.52073 2089475.11103 37.7179132396708 -122.40443035886899 (37.7179132396708, -122.404430358869)
36978 187575 2 58 72 Bishop St 2 17 1 1     11     6010832.96557 2089490.7918200002 37.7179547559905 -122.40452670863998 (37.7179547559905, -122.40452670864)
38985 123068 2 58 678 12th Ave 2 1 1 1     1 Width 3ft   5992266.69336 2110864.34538 37.7755859643914 -122.47025718989201 (37.7755859643914, -122.470257189892)
39135 247897 2 58 351 Mayflower St 2 17 1 1     4     6010077.88258 2098386.8429099997 37.7423392041858 -122.407763645688 (37.7423392041858, -122.407763645688)
49133 247976 2 58 503 Peralta Ave 2 17 1 1     9     6009801.95016 2099270.17301 37.7447491849331 -122.408780045086 (37.7447491849331, -122.408780045086)
51309 222685 2 58 145 Coso Ave 2 9 1 1     5     6007512.1231 2099620.66206 37.74558302735271 -122.41672267392201 (37.7455830273527, -122.416722673922)
77059 188411 2 58 398 Mississippi St 2 4 1 1     1 Width 3ft   6014024.24871 2105357.36092 37.7616988910081 -122.394606216998 (37.7616988910081, -122.394606216998)
96969 109399 2 58 1588 WALLER ST 2 1 1 1       3x3   5997977.9 2108248.0 37.7687306888354 -122.450312188331 (37.7687306888354, -122.450312188331)
116006 106924 2 58 196 States St 2 9 1 1   06/30/2014 12:00:00 AM     Permit Number 772939 6001039.87531 2106387.50014 37.7637969766711 -122.43958767886002 (37.7637969766711, -122.43958767886)
116919 175809 2 58 72 La Grande Ave 2 17 1 1     4     6005230.95207 2091785.5880000002 37.7239410985769 -122.424053538037 (37.7239410985769, -122.424053538037)
130324 123045 2 58 568 Funston Ave 2 2 1 1     1 Width 3ft   5991929.81513 2111594.03006 37.777569997766705 -122.47147570428301 (37.7775699977667, -122.471475704283)
144281 122680 2 58 598x Powhattan Ave 2 1 1 1       3x3   6008469.0 2098078.0 37.7414009906205 -122.413304856031 (37.7414009906205, -122.413304856031)
155156 125935 2 58 1132 Greenwich St 2 7 1 1     9     6007463.08276 2119890.85277 37.8012373932575 -122.418329199431 (37.8012373932575, -122.418329199431)
155781 222708 2 58 290 States St 2 7 1 1     8 Width 3ft   6000342.850880001 2106861.9429200003 37.76505998306129 -122.442032523579 (37.7650599830613, -122.442032523579)
156475 175816 2 58 616 Dwight St 2 1 1 1     1 Width 3ft   6009781.28405 2091163.7033900002 37.7224893931511 -122.40827985473699 (37.7224893931511, -122.408279854737)
166040 175807 2 58 156 San Juan Ave 2 9 1 1     3 Width 10ft   6001266.11551 2092303.88748 37.725139581023605 -122.437796421768 (37.7251395810236, -122.437796421768)
169588 204739 2 58 463 Mangels Ave 2 9 1 1     3 Width 10ft   5998365.55897 2095230.78545 37.7330107938072 -122.44803394331899 (37.7330107938072, -122.448033943319)
171201 175802 2 58 421 Wheeler Ave 2 1 1 1     3 Width 3ft   6011992.04716 2086775.8851599998 37.7105648747395 -122.400329663484 (37.7105648747395, -122.400329663484)
171203 204735 2 58 40 Vasquez Ave 2 1 1 1     1 Width 3ft   5995650.24765 2100035.09823 37.746046665624 -122.457768945275 (37.746046665624, -122.457768945275)
174132 188415 2 58 2 Jennings St 2 4 1 1     1 Width 3ft   6019090.329030001 2097590.47628 37.7406529492792 -122.37654576818998 (37.7406529492792, -122.37654576819)
176434 124049 2 58 651 11th Ave 2 9 1 1     2 Width 3ft   5992517.64773 2111006.08275 37.775989642541795 -122.469399404795 (37.7759896425418, -122.469399404795)
178316 202043 2 58 52 Exeter St 2 4 1 1     1 Width 3ft   6012522.16713 2090984.69593 37.722150974681604 -122.398792625891 (37.7221509746816, -122.398792625891)
178842 204733 2 58 80 Merced Ave 2 2 1 1     3 Width 3ft   5994927.12974 2099849.55804 37.745495650106605 -122.460255934077 (37.7454956501066, -122.460255934077)
179565 222694 2 58 427 Valley St 2 2 1 1     7     6003122.71421 2099186.4838799997 37.7441430185014 -122.431869572034 (37.7441430185014, -122.431869572034)
185050 204744 2 58 545 Melrose Ave 2 9 1 1     1 Width 6ft   5996927.5801099995 2095415.2897 37.733435093958896 -122.453018700168 (37.7334350939589, -122.453018700168)
145019 96748 3 58 399X Liberty St 2 1 1 2     4 1.5x2   6003700.0 2103889.2 37.7570882837734 -122.430208878023 (37.7570882837734, -122.430208878023)
Powered by Datasette · Query took 4.424ms · Data source: data.sfgov.org