sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
158705 190031 2 99 1301 Minnesota St 76 7 1 1     2     6015368.80756 2102249.49615 37.753240017127 -122.389738810018 (37.753240017127, -122.389738810018)
172254 190033 2 99 651 Missouri St 30 9 1 1     3 Width 7ft   6013606.61157 2104092.53416 37.7582027253025 -122.39596202861901 (37.7582027253025, -122.395962028619)
181433 190032 2 99 651 Missouri St 29 9 1 1     6 Width 7ft   6013600.610230001 2104091.57262 37.7581997512359 -122.395982716627 (37.7581997512359, -122.395982716627)
163945 206035 3 99 700x Monterey Blvd 18 11 1 2     6 Width 4ft   5996866.22235 2094722.0274099999 37.7315280455795 -122.453180800271 (37.7315280455795, -122.453180800271)
63471 206034 3 99 700x Monterey Blvd 17 11 1 2     8 Width 4ft   5996882.83192 2094722.4323900002 37.731530109506295 -122.453123407313 (37.7315301095063, -122.453123407313)
159709 201681 2 99 401 08th St 17 7 1 1     2     6010219.21458 2109785.59098 37.7736455201492 -122.408078663801 (37.7736455201492, -122.408078663801)
71306 206033 3 99 700x Monterey Blvd 16 11 1 2     8 Width 4ft   5996901.71225 2094723.16535 37.7315332040984 -122.453058187605 (37.7315332040984, -122.453058187605)
72268 201680 2 99 401 08th St 16 7 1 1     5     6010229.21797 2109787.73605 37.7736519701026 -122.40804421168998 (37.7736519701026, -122.40804421169)
69677 201679 2 99 401 08th St 15 7 1 1     5     6010240.772059999 2109788.80533 37.7736555529973 -122.40800431955799 (37.7736555529973, -122.408004319558)
27402 201678 2 99 401 08th St 14 7 1 1     4     6010253.38486 2109790.37511 37.7736605694093 -122.407960800466 (37.7736605694093, -122.407960800466)
148331 190003 2 99 1750 22nd St 14 17 1 1     7     6012781.6725699995 2103797.8962 37.7573477838951 -122.398794366977 (37.7573477838951, -122.398794366977)
20789 29999 3 99 681X San Jose Ave 13 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005890.72277 2099411.68829 37.7449179049514 -122.422314391296 (37.7449179049514, -122.422314391296)
63791 201677 2 99 401 08th St 13 7 1 1     8     6010264.4203699995 2109791.71635 37.7736648699818 -122.407922721364 (37.7736648699818, -122.407922721364)
25509 190026 2 99 1400 03rd St 12 1 1 1     14 Width 5ft   6015544.83514 2108320.68008 37.769919941866895 -122.389554039808 (37.7699199418669, -122.389554039808)
52220 225202 3 99 1594x Guerrero St 12 11 1 2     6 Width 3ft   6005906.49686 2099871.3036700003 37.7461807941146 -122.422292496403 (37.7461807941146, -122.422292496403)
134762 201676 2 99 401 08th St 12 7 1 1     5     6010275.73936 2109794.09532 37.7736720357783 -122.40788373484301 (37.7736720357783, -122.407883734843)
160516 190020 2 99 1530 03rd St 12 1 1 1     15 Width 5ft   6015584.43667 2107642.2623 37.768059350697996 -122.38936967519699 (37.768059350698, -122.389369675197)
188264 206032 3 99 601x Monterey Blvd 12 11 1 2     7 Width 4ft   5997524.38886 2094711.3028099998 37.7315362986421 -122.450904629644 (37.7315362986421, -122.450904629644)
61557 206031 3 99 601x Monterey Blvd 11 11 1 2     7 Width 4ft   5997540.974909999 2094710.58133 37.731535267123 -122.450847236737 (37.731535267123, -122.450847236737)
70258 201675 2 99 401 08th St 11 7 1 1     4     6010282.589459999 2109782.99387 37.7736419372697 -122.40785925619801 (37.7736419372697, -122.407859256198)
131163 225201 3 99 1594x Guerrero St 11 11 1 2     6 Width 3ft   6005907.02025 2099862.53576 37.7461567489521 -122.422290063739 (37.7461567489521, -122.422290063739)
171439 126013 2 99 2600 Lyon St 11 9 1 1     11 Width 7ft   5999233.22196 2117805.48778 37.795044834292895 -122.44665788886499 (37.7950448342929, -122.446657888865)
181426 201513 2 99 1001 Innes Ave 11 9 1 1     1 Width 4ft   6018634.55292 2094871.3359599998 37.7331616173072 -122.377932996723 (37.7331616173072, -122.377932996723)
23690 126012 2 99 2600 Lyon St 10 9 1 1     9 Width 7ft   5999234.571959999 2117780.83993 37.7949772349663 -122.446651443424 (37.7949772349663, -122.446651443424)
49887 190019 2 99 1530 03rd St 10 1 1 1     14 Width 5ft   6015583.6961 2107674.48805 37.7681477945165 -122.389374487455 (37.7681477945165, -122.389374487455)
130988 190030 2 99 1500 03rd St 10 1 1 1     14 Width 5ft   6015562.57352 2108029.9349599998 37.7691226029579 -122.389472375051 (37.7691226029579, -122.389472375051)
132041 190025 2 99 1400 03rd St 10 1 1 1     14 Width 5ft   6015543.83866 2108366.1327 37.7700446895441 -122.389560661497 (37.7700446895441, -122.389560661497)
166477 201674 2 99 401 08th St 10 7 1 1     6     6010278.21151 2109773.9479799997 37.773616854257604 -122.407873762259 (37.7736168542576, -122.407873762259)
183433 206043 2 99 621 Holloway Ave 10 9 1 1     9 Width 3ft   5994997.50397 2091203.21567 37.721758956587294 -122.459386538764 (37.7217589565873, -122.459386538764)
40599 190014 2 99 888 07th St 9 1 1 1     29 Width 8ft   6012452.605140001 2108628.1137900003 37.770592145536 -122.400271663513 (37.770592145536, -122.400271663513)
55039 225145 2 99 450 Florida St 9 9 1 1     18     6009179.2133599995 2106266.6276700003 37.76392497748579 -122.41142754574899 (37.7639249774858, -122.411427545749)
130881 225147 2 99 1706 Dolores St 9 2 1 1     11 Width 6ft   6005278.315280001 2098374.8158 37.7420363251164 -122.424358251742 (37.7420363251164, -122.424358251742)
151815 201673 2 99 401 08th St 9 7 1 1     7     6010274.35746 2109764.89142 37.773591771276706 -122.4078864553 (37.7735917712767, -122.4078864553)
152995 225179 2 99 240 Shotwell St 9 1 1 1     8 Width 3ft   6007756.33933 2106453.2465 37.764357479442 -122.41636207364799 (37.764357479442, -122.416362073648)
168817 206042 2 99 621 Holloway Ave 9 9 1 1     9 Width 3ft   5994983.67365 2091204.0797700002 37.7217605339977 -122.45943440879101 (37.7217605339977, -122.459434408791)
173541 206030 3 99 501x Monterey Blvd 9 11 1 2     5 Width 4ft   5998284.310380001 2094699.8261099998 37.7315482605292 -122.44827661909201 (37.7315482605292, -122.448276619092)
45461 189994 3 99 1150x Tennessee St 8 11 1 2     8 Width 6ft   6015560.24014 2103579.83014 37.756903445945795 -122.389169674966 (37.7569034459458, -122.389169674966)
68768 190029 2 99 1500 03rd St 8 1 1 1     16 Width 5ft   6015559.81581 2108067.16285 37.7692246696975 -122.38948451411999 (37.7692246696975, -122.38948451412)
89297 201672 2 99 401 08th St 8 7 1 1     5     6010270.770690001 2109756.0907799997 37.773567405955 -122.407898241816 (37.773567405955, -122.407898241816)
90022 73786 1 99 240 Shotwell St 8 1 1 1 1 12/21/1996 12:00:00 AM 6 3x3   6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
149755 206029 3 99 501x Monterey Blvd 8 11 1 2     7 Width 4ft   5998304.86283 2094699.93665 37.731549739012706 -122.448205573546 (37.7315497390127, -122.448205573546)
153266 190024 2 99 1400 03rd St 8 1 1 1     14 Width 5ft   6015540.58409 2108410.35977 37.7701659469215 -122.389575008383 (37.7701659469215, -122.389575008383)
178979 206041 2 99 621 Holloway Ave 8 9 1 1     9 Width 3ft   5994962.333219999 2091204.5266599997 37.7217605340024 -122.459508208932 (37.7217605340024, -122.459508208932)
182780 190018 2 99 1530 03rd St 8 1 1 1     15 Width 5ft   6015579.842180001 2107724.78714 37.7682856911689 -122.38939133086399 (37.7682856911689, -122.389391330864)
183184 225180 2 99 240 Shotwell St 8 1 1 1     7 Width 3ft   6007753.3624 2106482.72591 37.7644382556423 -122.416374458236 (37.7644382556423, -122.416374458236)
21577 30015 3 99 738X San Jose Ave 7 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005757.33905 2098980.75435 37.7437271333024 -122.422744989392 (37.7437271333024, -122.422744989392)
60204 189997 2 99 1809 19th St 7 9 1 1     18 Width 6ft   6012307.781769999 2105132.0490099997 37.760984657528894 -122.40052699363501 (37.7609846575289, -122.400526993635)
62061 206040 2 99 621 Holloway Ave 7 9 1 1     9 Width 3ft   5994946.74244 2091203.9910900001 37.7217581669755 -122.45956206304899 (37.7217581669755, -122.459562063049)
158983 206028 3 99 501x Monterey Blvd 7 11 1 2     7 Width 4ft   5998324.94212 2094699.61096 37.7315499926202 -122.448136132397 (37.7315499926202, -122.448136132397)
166068 225181 2 99 240 Shotwell St 7 1 1 1     7 Width 3ft   6007752.17494 2106512.16868 37.7645190318645 -122.41638065094801 (37.7645190318645, -122.416380650948)
166097 201509 2 99 1001 Innes Ave 7 9 1 1     1 Width 4ft   6018596.778580001 2094899.20439 37.73323605689679 -122.378065528029 (37.7332360568968, -122.378065528029)
183572 201671 2 99 401 08th St 7 7 1 1     5     6010268.2107 2109746.2247 37.7735401726656 -122.407906401378 (37.7735401726656, -122.407906401378)
16787 100332 1 99 555 04th St 6 1 1 1   04/01/2012 12:00:00 AM 3 3x3 Permit Number 768623 6013356.21451 2111717.71239 37.779125829518705 -122.397362747904 (37.7791258295187, -122.397362747904)
17658 29711 3 99 1534X Guerrero St 6 11 1 2   03/30/2006 12:00:00 AM 6     6005892.92513 2100118.18846 37.7468579179619 -122.422356964326 (37.7468579179619, -122.422356964326)
19998 30014 3 99 738X San Jose Ave 6 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005753.20487 2098967.8779700003 37.7436915444264 -122.422758369527 (37.7436915444264, -122.422758369527)
22275 29704 3 99 1488X Guerrero St 6 11 1 2   03/30/2006 12:00:00 AM 6     6005876.958869999 2100402.60074 37.7476379485377 -122.422432379649 (37.7476379485377, -122.422432379649)
35962 225200 3 99 1622x Guerrero St 6 11 1 2     7 Width 3ft   6005924.11488 2099598.76228 37.74543345119329 -122.42221221572599 (37.7454334511933, -122.422212215726)
38646 201508 2 99 1001 Innes Ave 6 9 1 1     1 Width 4ft   6018593.65925 2094901.94124 37.7332433998449 -122.378076502435 (37.7332433998449, -122.378076502435)
44856 190023 2 99 1400 03rd St 6 1 1 1     16 Width 5ft   6015540.26875 2108442.1367599997 37.770253182080396 -122.38957831879499 (37.7702531820804, -122.389578318795)
59914 206025 2 99 1366 16th Ave 6 10 1 1     5 Width 3ft   5991157.5258599995 2106131.34791 37.76252624212071 -122.473748679463 (37.7625262421207, -122.473748679463)
146819 225192 2 99 500 Capp St 6 1 1 1     10 Width 3ft   6007260.94104 2103859.736 37.757208430341294 -122.41789166399299 (37.7572084303413, -122.417891663993)
147255 225182 2 99 240 Shotwell St 6 1 1 1     8 Width 3ft   6007750.95097 2106539.82911 37.764594912141206 -122.416386843697 (37.7645949121412, -122.416386843697)
176930 225167 2 99 338 Hoffman Ave 6 1 1 1     7 Width 4ft   6000621.34497 2101755.16217 37.7510538776544 -122.44070294699699 (37.7510538776544, -122.440702946997)
181059 190017 2 99 1530 03rd St 6 1 1 1     14 Width 5ft   6015580.20075 2107759.76126 37.7683817423455 -122.389392533258 (37.7683817423455, -122.389392533258)
17378 29984 3 99 1622X Guerrero St 5 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005923.58357 2099590.01571 37.7454094051301 -122.422213431617 (37.7454094051301, -122.422213431617)
17470 29703 3 99 1488X Guerrero St 5 11 1 2   03/30/2006 12:00:00 AM 6     6005875.752859999 2100395.2692 37.7476177497694 -122.42243602910901 (37.7476177497694, -122.422436029109)
21879 29710 3 99 1534X Guerrero St 5 11 1 2   03/30/2006 12:00:00 AM 3     6005894.4456400005 2100106.5973900002 37.7468261772965 -122.422350883111 (37.7468261772965, -122.422350883111)
22913 100331 1 99 555 04th St 5 1 1 1     22 3x3   6013371.56305 2111703.84537 37.779088608380206 -122.397308677969 (37.7790886083802, -122.397308677969)
31570 225166 2 99 338 Hoffman Ave 5 1 1 1     8 Width 4ft   6000619.1665199995 2101783.32951 37.7511310943237 -122.440712500502 (37.7511310943237, -122.440712500502)
44500 225198 2 99 3160 21st St 5 1 1 1     9 Width 3ft   6007149.23047 2103831.77129 37.757125358151704 -122.41827602071501 (37.7571253581517, -122.418276020715)
76939 225183 2 99 240 Shotwell St 5 1 1 1     7 Width 3ft   6007749.18821 2106563.04323 37.7646585535855 -122.416394585035 (37.7646585535855, -122.416394585035)
153857 201507 2 99 1001 Innes Ave 5 9 1 1     1 Width 4ft   6018590.61876 2094904.2906900002 37.733249683412296 -122.37808717738599 (37.7332496834123, -122.378087177386)
158218 190007 2 99 700 Arkansas St 5 7 1 1     3     6012984.44615 2103792.30277 37.7573437216454 -122.398092698838 (37.7573437216454, -122.398092698838)
165711 225191 2 99 500 Capp St 5 1 1 1     10 Width 3ft   6007257.73573 2103878.07853 37.7572586143179 -122.41790404944099 (37.7572586143179, -122.417904049441)
26101 225190 2 99 500 Capp St 4 1 1 1     9 Width 3ft   6007254.11935 2103898.21255 37.7573136941774 -122.41791798353998 (37.7573136941774, -122.41791798354)
42322 225209 2 99 338 Cumberland St 4 1 1 1     5 Width 3ft   6003378.3537099995 2104496.9744599997 37.7587388642274 -122.431364637772 (37.7587388642274, -122.431364637772)
45328 225157 2 99 104 Franconia St 4 1 1 1     9 Width 2ft   6010022.83769 2099819.01097 37.7462685436666 -122.408054953167 (37.7462685436666, -122.408054953167)
45520 190006 2 99 700 Arkansas St 4 7 1 1     4     6012982.38984 2103806.3309400002 37.7573821254062 -122.398100794542 (37.7573821254062, -122.398100794542)
49236 190022 2 99 1400 03rd St 4 1 1 1     15 Width 5ft   6015535.32333 2108481.6321099997 37.770361353431895 -122.389598183934 (37.7703613534319, -122.389598183934)
67172 175847 2 99 210 Tocoloma Ave 4 1 1 1     8 Width 3ft   6012727.81245 2087493.92668 37.7125774765391 -122.397837015259 (37.7125774765391, -122.397837015259)
70787 201506 2 99 1001 Innes Ave 4 9 1 1     1 Width 4ft   6018588.36983 2094906.5368 37.7332557268509 -122.378095108499 (37.7332557268509, -122.378095108499)
84096 225197 2 99 3160 21st St 4 1 1 1     9 Width 3ft   6007163.79352 2103832.50742 37.7571281991351 -122.418225708166 (37.7571281991351, -122.418225708166)
131352 126018 2 99 500 Post St 4 10 1 1     6 Width 3ft   6009631.44446 2115049.8898 37.788067110556604 -122.41048365871 (37.7880671105566, -122.41048365871)
162917 206039 2 99 280 Brighton Ave 4 1 1 1     10 Width 3ft   5996261.11762 2091797.78089 37.723464064001895 -122.455061523695 (37.7234640640019, -122.455061523695)
163882 190016 2 99 1530 03rd St 4 1 1 1     18 Width 5ft   6015575.880530001 2107804.1814599996 37.7685034709891 -122.38941057906099 (37.7685034709891, -122.389410579061)
167510 100330 1 99 555 04th St 4 1 1 1     26 3x3   6013394.216680001 2111677.27832 37.7790169225246 -122.39722844584601 (37.7790169225246, -122.397228445846)
171827 225158 2 99 3203 24th St 4 1 1 1     16 Width 3ft   6007618.37358 2102060.04095 37.7522869875715 -122.416528039931 (37.7522869875715, -122.416528039931)
172905 190028 2 99 1500 03rd St 4 1 1 1     12 Width 5ft   6015555.80017 2108152.70829 37.7694593361018 -122.389504379223 (37.7694593361018, -122.389504379223)
16169 100329 1 99 555 04th St 3 1 1 1   04/01/2012 12:00:00 AM 3 3x3 Permit Number 768623 6013411.2884599995 2111661.36797 37.7789741867392 -122.39716827132 (37.7789741867392, -122.39716827132)
17666 16203 3 99 501X Monterey Blvd 3 11 1 2   02/02/2003 12:00:00 AM 12 5   5998659.38581 2094694.1828400001 37.731554201452106 -122.446979509806 (37.7315542014521, -122.446979509806)
18341 29708 3 99 1534X Guerrero St 3 11 1 2   03/30/2006 12:00:00 AM 6     6005897.61494 2100055.38982 37.746685751754605 -122.422336286217 (37.7466857517546, -122.422336286217)
18826 16271 3 99 601X Monterey Blvd 3 11 1 2   02/02/2003 12:00:00 AM 18 5   5997920.42958 2094705.3029200002 37.731542488687204 -122.449535014353 (37.7315424886872, -122.449535014353)
21501 639 1 99 3203 24th St 3 1 1 1   04/01/1991 12:00:00 AM 18 3X3   6007596.74853 2102059.47083 37.7522842059666 -122.416602782609 (37.7522842059666, -122.416602782609)
21912 29701 3 99 1488X Guerrero St 3 11 1 2   03/30/2006 12:00:00 AM 6     6005878.92208 2100344.0622799997 37.7474773260372 -122.42242143222201 (37.7474773260372, -122.422421432222)
22067 16311 3 99 700X Monterey Blvd 3 11 1 2   02/02/2003 12:00:00 AM 3 5   5997346.34886 2094713.5127 37.7315321725506 -122.45152030461901 (37.7315321725506, -122.451520304619)
32476 126017 2 99 500 Post St 3 10 1 1     6 Width 3ft   6009644.05128 2115053.2571900003 37.788077063340204 -122.410440279012 (37.7880770633402, -122.410440279012)
34786 126022 2 99 550 Geary St 3 10 1 1     4 Width 4ft   6009023.96612 2114628.9203 37.786877155513004 -122.412555665234 (37.786877155513, -122.412555665234)
34889 175846 2 99 210 Tocoloma Ave 3 1 1 1     8 Width 3ft   6012734.12087 2087510.3732 37.7126229867466 -122.397816364158 (37.7126229867466, -122.397816364158)
40866 225175 2 99 3309 Folsom St 3 1 1 1     3 Width 3ft   6008515.82219 2099330.37365 37.7448423609829 -122.41323150034901 (37.7448423609829, -122.413231500349)
49752 225207 2 99 3816 24th St 3 10 1 1     6 Width 3ft   6004299.338409999 2101924.10637 37.7517265264651 -122.427996107428 (37.7517265264651, -122.427996107428)
54105 206046 2 99 82 Ventura Ave 3 2 1 1     5 Width 3ft   5994334.26497 2101814.09479 37.750855650885605 -122.462448420067 (37.7508556508856, -122.462448420067)
Powered by Datasette · Query took 4.533ms · Data source: data.sfgov.org