sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
50903 225174 2 99 1000 Jarboe Ave 1 2 1 1     10 Width 3ft   6009367.84971 2096849.47647 37.738078156068894 -122.410110221514 (37.7380781560689, -122.410110221514)
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)
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)
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)
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)
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)
47236 225176 2 99 1020 Alabama St 1 10 1 1     7 Width 3ft   6009156.40291 2103118.80305 37.7552804871291 -122.411284056222 (37.7552804871291, -122.411284056222)
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)
157715 225155 2 99 104 Franconia St 2 1 1 1     10 Width 2ft   6010008.90641 2099846.42229 37.7463430291237 -122.40810505891199 (37.7463430291237, -122.408105058912)
172815 225154 2 99 104 Franconia St 1 1 1 1     8 Width 2ft   6010002.80385 2099859.8218 37.7463794795488 -122.40812710578999 (37.7463794795488, -122.40812710579)
183926 225156 2 99 104 Franconia St 3 1 1 1     10 Width 2ft   6010015.03813 2099834.46528 37.746310541115896 -122.408083012937 (37.7463105411159, -122.408083012937)
73909 225153 2 99 105 Franconia St 1 1 1 1     13 Width 3ft   6010058.65262 2099813.08608 37.7462542804284 -122.407930691168 (37.7462542804284, -122.407930691168)
150087 225171 2 99 106 Coleridge St 1 1 1 1     6 Width 3ft   6006678.67564 2099088.45084 37.7440747833339 -122.419566860849 (37.7440747833339, -122.419566860849)
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)
66694 225148 2 99 1199 Capp St 1 9 1 1     3 Width 9ft   6007231.69522 2100624.49408 37.7483235475968 -122.417763493512 (37.7483235475968, -122.417763493512)
137477 189995 2 99 1301 Minnesota St 3 7 1 1     3     6015392.22277 2102247.2850900004 37.753235244428204 -122.389657680355 (37.7532352444282, -122.389657680355)
158705 190031 2 99 1301 Minnesota St 76 7 1 1     2     6015368.80756 2102249.49615 37.753240017127 -122.389738810018 (37.753240017127, -122.389738810018)
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)
67868 206024 2 99 1366 16th Ave 2 10 1 1     5 Width 3ft   5991156.52884 2106111.8053099997 37.7624725256075 -122.473750702041 (37.7624725256075, -122.473750702041)
29299 225151 2 99 14 Montezuma St 1 1 1 1     10 Width 3ft   6007510.1037 2099736.8177900002 37.7459018513879 -122.416737884151 (37.7459018513879, -122.416737884151)
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)
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)
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)
71985 190021 2 99 1400 03rd St 2 1 1 1     13 Width 5ft   6015535.23888 2108524.8420599997 37.7704799937881 -122.389601494338 (37.7704799937881, -122.389601494338)
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)
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)
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)
19578 29700 3 99 1488X Guerrero St 2 11 1 2   03/30/2006 12:00:00 AM 6     6005880.5001300005 2100335.27269 37.747453280849 -122.422415350984 (37.747453280849, -122.422415350984)
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)
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)
66360 190027 2 99 1500 03rd St 2 1 1 1     15 Width 5ft   6015553.64576 2108193.7384099998 37.7695718763733 -122.389514697159 (37.7695718763733, -122.389514697159)
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)
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)
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)
134896 120285 2 99 151 24th Ave 1 2 1 1     10     5988326.80885 2115016.043 37.7867567842415 -122.484190580999 (37.7867567842415, -122.484190580999)
27419 190015 2 99 1530 03rd St 2 1 1 1     16 Width 5ft   6015573.49943 2107841.28907 37.768605228364 -122.38942140686899 (37.768605228364, -122.389421406869)
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)
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)
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)
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)
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)
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)
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)
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)
27590 225203 3 99 1534x Guerrero St 2 11 1 2     6 Width 3ft   6005899.22105 2100030.8366400003 37.746618424914296 -122.422328988218 (37.7466184249143, -122.422328988218)
19536 29706 3 99 1594X Guerrero St 1 11 1 2   03/30/2006 12:00:00 AM 3     6005915.3087 2099718.0441099997 37.745760475271204 -122.422251139273 (37.7457604752712, -122.422251139273)
20337 29707 3 99 1594X Guerrero St 2 11 1 2   03/30/2006 12:00:00 AM 3     6005916.90216 2099727.1189900003 37.74578548271 -122.422246273943 (37.74578548271, -122.422246273943)
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)
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)
38579 190011 2 99 1599 Newhall St 1 4 1 1     10 Width 4ft   6014210.748430001 2095415.1555299999 37.7344100624646 -122.39326543937 (37.7344100624646, -122.39326543937)
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)
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)
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)
148481 225146 2 99 1706 Dolores St 3 2 1 1     10 Width 6ft   6005275.161069999 2098395.65522 37.7420933673216 -122.424370639893 (37.7420933673216, -122.424370639893)
65401 190004 2 99 1745 20th St 1 2 1 1     25 Width 3ft   6012733.96255 2104688.60274 37.7597908102085 -122.399021884672 (37.7597908102085, -122.399021884672)
148331 190003 2 99 1750 22nd St 14 17 1 1     7     6012781.6725699995 2103797.8962 37.7573477838951 -122.398794366977 (37.7573477838951, -122.398794366977)
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)
147063 189996 2 99 1809 19th St 2 9 1 1     5 Width 6ft   6012291.07861 2105130.95435 37.7609807203027 -122.400584686038 (37.7609807203027, -122.400584686038)
156182 189998 2 99 1950 18th St 3 9 1 1     8 Width 6ft   6011839.98262 2105629.53813 37.7623245520575 -122.402179893599 (37.7623245520575, -122.402179893599)
148722 225150 2 99 21 Prospect Ave 1 1 1 1     6 Width 2ft   6007236.93234 2099402.00378 37.744967159016596 -122.417658748554 (37.7449671590166, -122.417658748554)
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)
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)
44503 225169 2 99 225 Banks St 1 1 1 1     4 Width 3ft   6008644.12934 2097539.28369 37.7399316246566 -122.412661242936 (37.7399316246566, -122.412661242936)
97575 27646 3 99 2260 Sloat Blvd 1 11 1 2   06/06/1999 12:00:00 AM 12 4X4   5983743.832098301 2096000.4658733997 37.7342774634165 -122.498641133162 (37.7342774634165, -122.498641133162)
12298 27647 3 99 2300 Sloat Blvd 1 11 1 2     12 4X4   5983545.7870000005 2096052.8205 37.7344095981993 -122.499329695326 (37.7344095981993, -122.499329695326)
147217 186971 3 99 2300x Sloat Blvd 2 11 1 2     9 Width 0ft   5983094.6287 2096334.4526 37.7351564048044 -122.50091029299801 (37.7351564048044, -122.500910292998)
61054 247121 2 99 2301 Castro St 3 9 1 1     5     6002764.34837 2098855.27399 37.743213271472705 -122.433085061551 (37.7432132714727, -122.433085061551)
160931 126014 2 99 2322 North Point St 1 9 1 1     20 Width 8ft   5999611.42315 2120546.01877 37.8025911966964 -122.445546423945 (37.8025911966964, -122.445546423945)
42492 247161 2 99 2399 Market St 1 10 1 1     28 Width 5ft   6002372.95372 2105936.54637 37.7626345492748 -122.43494472103998 (37.7626345492748, -122.43494472104)
63388 225185 2 99 240 Shotwell St 2 1 1 1     7 Width 3ft   6007746.072980001 2106673.2030700003 37.764960851679 -122.41641316324 (37.764960851679, -122.41641316324)
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)
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)
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)
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)
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)
166308 225184 2 99 240 Shotwell St 3 1 1 1     8 Width 3ft   6007748.54808 2106641.05965 37.764872732518704 -122.416402325519 (37.7648727325187, -122.416402325519)
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)
143088 27648 3 99 2400 Sloat Blvd 1 11 1 2   06/06/1999 12:00:00 AM 12 4X4   5983342.3231549 2096264.1854035999 37.7349780102042 -122.50004874464199 (37.7349780102042, -122.500048744642)
601 225172 1 99 248 Prospect Ave 1 1 1 1   12/02/2002 12:00:00 AM 9 Width 3ft Permit Number 46150 6006535.621280001 2098220.1400900004 37.7416825381227 -122.419999905071 (37.7416825381227, -122.419999905071)
11897 27649 3 99 2500 Sloat Blvd 1 11 1 2   06/06/1999 12:00:00 AM 12 4X4   5982997.5613 2096369.9984 37.7352483041994 -122.501248513045 (37.7352483041994, -122.501248513045)
45626 186972 3 99 2500x Sloat Blvd 2 11 1 2     6 Width 0ft   5982510.8573 2096452.0272 37.7354449395599 -122.50293726958999 (37.7354449395599, -122.50293726959)
70063 225186 2 99 252 Capp St 1 1 1 1     5 Width 3ft   6007150.88723 2105850.08612 37.762667276482894 -122.418413397566 (37.7626672764829, -122.418413397566)
74897 206045 2 99 260 San Leandro Way 1 1 1 1     9 Width 3ft   5992364.28925 2095097.86508 37.732300949933 -122.468772052499 (37.732300949933, -122.468772052499)
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)
166960 126011 2 99 2600 Lyon St 1 9 1 1     13 Width 7ft   5999243.15513 2117721.3039700002 37.7948142553315 -122.446617458939 (37.7948142553315, -122.446617458939)
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)
106072 27650 3 99 2650 Sloat Blvd 1 11 1 2   06/06/1999 12:00:00 AM 12 4X4   5982609.4890242005 2096515.7957863999 37.735625827225796 -122.502600986809 (37.7356258272258, -122.502600986809)
10585 27651 3 99 2700 Sloat Blvd 1 11 1 2   06/06/1999 12:00:00 AM 12 4X4   5982420.6256 2096461.5972 37.73546591249 -122.503249937577 (37.73546591249, -122.503249937577)
150193 206044 2 99 275 Byxbee St 1 9 1 1     5 Width 6ft   5991926.36894 2090353.75557 37.7192494901497 -122.46994073500099 (37.7192494901497, -122.469940735001)
137612 116891 2 99 2798X Lyon St 1 1 1 1     30 3x3   5999182.98236 2118335.47511 37.796497168372795 -122.446869879744 (37.7964971683728, -122.446869879744)
58330 206036 2 99 280 Brighton Ave 1 1 1 1     10 Width 3ft   5996259.37903 2091732.03952 37.7232834540474 -122.455062785437 (37.7232834540474, -122.455062785437)
70642 206037 2 99 280 Brighton Ave 2 1 1 1     10 Width 3ft   5996260.563569999 2091771.26312 37.72339122070879 -122.45506152367201 (37.7233912207088, -122.455061523672)
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)
173741 206038 2 99 280 Brighton Ave 3 1 1 1     10 Width 3ft   5996260.86716 2091785.79325 37.72343113441671 -122.45506152366998 (37.7234311344167, -122.45506152367)
78812 27652 3 99 2830 Sloat Blvd 1 11 1 2   06/06/1999 12:00:00 AM 12 4X4   5982048.7143342 2096528.9941474 37.7356290969828 -122.50454074467 (37.7356290969828, -122.50454074467)
97571 225162 2 99 2859 16th St 2 1 1 1     9 Width 3ft   6007695.93122 2106747.75341 37.765162729690296 -122.41659187291701 (37.7651627296903, -122.416591872917)
182331 225163 2 99 2859 16th St 1 1 1 1     10 Width 3ft   6007679.26286 2106746.83875 37.7651592807999 -122.416649460099 (37.7651592807999, -122.416649460099)
181288 225164 2 99 2861 16th St 1 1 1 1     10 Width 3ft   6007651.46889 2106744.64503 37.7651516941295 -122.416745437549 (37.7651516941295, -122.416745437549)
19207 546 3 99 2884 24th St 1 1 1 2     18 3X3   6009527.2979999995 2102212.4790000003 37.752812718682996 -122.409937408543 (37.752812718683, -122.409937408543)
10607 27653 3 99 2900X Sloat Blvd 1 11 1 2   06/06/1999 12:00:00 AM 12 4X4   5981776.6997 2096484.8387 37.7354918543068 -122.505477915571 (37.7354918543068, -122.505477915571)
24138 225161 2 99 2957 Harrison St 1 1 1 1     7 Width 3ft   6009038.45977 2101249.93986 37.7501423922716 -122.411559907065 (37.7501423922716, -122.411559907065)
Powered by Datasette · Query took 4.188ms · Data source: data.sfgov.org