sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
45537 239188 2 147 1300 San Jose Ave 40 9 1 1     1     6003390.53226 2095588.92552 37.7342801275185 -122.430686848418 (37.7342801275185, -122.430686848418)
38350 239199 2 147 100 Hwy 101 Southbound 27 13 1 1     2     6005974.4493 2108807.19348 37.770720494984495 -122.422692434815 (37.7707204949845, -122.422692434815)
130200 239200 2 147 100 Hwy 101 Southbound 26 13 1 1     2     6005967.71166 2108818.2564 37.7707504909794 -122.422716526767 (37.7707504909794, -122.422716526767)
133851 239201 2 147 100 Hwy 101 Southbound 25 13 1 1     3     6005958.49088 2108828.3343599997 37.7707776424043 -122.422749137971 (37.7707776424043, -122.422749137971)
180826 239202 2 147 100 Hwy 101 Southbound 24 13 1 1     2     6005953.73874 2108834.81297 37.7707951629947 -122.422766036225 (37.7707951629947, -122.422766036225)
59769 239203 2 147 100 Hwy 101 Southbound 22 13 1 1     3     6005946.44181 2108844.1649 37.7708204294492 -122.42279194121402 (37.7708204294492, -122.422791941214)
45307 239204 2 147 100 Hwy 101 Southbound 21 13 1 1     4     6005940.87649 2108850.7859900002 37.7708382953675 -122.422811662426 (37.7708382953675, -122.422811662426)
158664 239205 2 147 100 Hwy 101 Southbound 20 13 1 1     2     6005934.94283 2108857.8407799997 37.7708573313359 -122.422832688574 (37.7708573313359, -122.422832688574)
178965 239171 2 147 1400 Potrero Ave 20 1 1 1     4 Width 2ft   6010775.13287 2100929.58266 37.7493600234457 -122.40553179815399 (37.7493600234457, -122.405531798154)
183663 239206 2 147 100 Hwy 101 Southbound 19 13 1 1     3     6005929.117819999 2108865.00797 37.7708766820544 -122.42285334689899 (37.7708766820544, -122.422853346899)
186175 239207 2 147 100 Hwy 101 Southbound 18 13 1 1     2     6005923.40296 2108870.98166 37.7708927619194 -122.422873539387 (37.7708927619194, -122.422873539387)
27616 239170 2 147 1400 Potrero Ave 17 1 1 1     4 Width 2ft   6010748.55016 2100997.3935 37.749544730724296 -122.405628497759 (37.7495447307243, -122.405628497759)
60490 239208 2 147 100 Hwy 101 Southbound 17 13 1 1     3     6005920.35776 2108877.05935 37.7709092779754 -122.42288450484 (37.7709092779754, -122.42288450484)
92650 92593 1 147 445 Wawona St 16 1 1 1   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625.0 2097033.0 37.737571604455205 -122.471468876287 (37.7375716044552, -122.471468876287)
94797 92592 1 147 445 Wawona St 15 1 1 1   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625.0 2097033.0 37.737571604455205 -122.471468876287 (37.7375716044552, -122.471468876287)
35375 239209 2 147 100 Hwy 101 Southbound 14 13 1 1     2     6005896.875990001 2108918.25042 37.7710210537973 -122.42296865708299 (37.7710210537973, -122.422968657083)
60926 239169 2 147 1400 Potrero Ave 14 1 1 1     4 Width 2ft   6010720.159580001 2101068.9953099997 37.749739745990894 -122.40573171655399 (37.7497397459909, -122.405731716554)
77703 92591 1 147 445 Wawona St 14 1 1 1   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625.0 2097033.0 37.737571604455205 -122.471468876287 (37.7375716044552, -122.471468876287)
54298 239149 2 147 8 Octavia St 13 4 1 1     3 Width 6ft   6005748.02057 2109577.9462099997 37.7728240191579 -122.423530461786 (37.7728240191579, -122.423530461786)
88388 92590 1 147 445 Wawona St 13 1 1 1   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625.0 2097033.0 37.737571604455205 -122.471468876287 (37.7375716044552, -122.471468876287)
170487 239210 2 147 100 Hwy 101 Southbound 13 13 1 1     3     6005891.00584 2108925.69957 37.771041176138795 -122.422989491673 (37.7710411761388, -122.422989491673)
139273 239168 2 147 1400 Potrero Ave 12 1 1 1     4 Width 2ft   6010702.848069999 2101113.77684 37.749861738144396 -122.40579473475 (37.7498617381444, -122.40579473475)
175455 239148 2 147 8 Octavia St 12 4 1 1     3 Width 6ft   6005748.59719 2109565.89201 37.7727909537754 -122.423527610038 (37.7727909537754, -122.423527610038)
18013 109951 8 147 400x CLEMENTINA ST 11 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
27650 239211 2 147 100 Hwy 101 Southbound 11 13 1 1     5     6005882.93751 2108938.64172 37.7710762568972 -122.42301832034501 (37.7710762568972, -122.423018320345)
43810 239167 2 147 1400 Potrero Ave 11 1 1 1     3 Width 2ft   6010693.269230001 2101137.12494 37.749925311216295 -122.405829503442 (37.7499253112163, -122.405829503442)
68215 239147 2 147 8 Octavia St 11 4 1 1     5 Width 6ft   6005750.76035 2109550.79453 37.7727496218289 -122.423519053867 (37.7727496218289, -122.423519053867)
32290 239198 2 147 101 Hwy 101 Northbound 10 13 1 1     3     6005918.91365 2109064.99496 37.771425222619705 -122.42290285910299 (37.7714252226197, -122.422902859103)
77374 109950 8 147 400x CLEMENTINA ST 10 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
180815 239166 2 147 1400 Potrero Ave 10 1 1 1     4 Width 2ft   6010684.29962 2101159.52227 37.749986307743 -122.40586209846799 (37.749986307743, -122.405862098468)
61124 239165 2 147 1400 Potrero Ave 9 1 1 1     5 Width 2ft   6010673.4453300005 2101181.95766 37.7500473033606 -122.40590121358801 (37.7500473033606, -122.405901213588)
145620 109949 8 147 400x CLEMENTINA ST 9 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
152126 239212 2 147 100 Hwy 101 Southbound 9 13 1 1     6     6005873.5433 2108954.58543 37.7711195043932 -122.42305194869301 (37.7711195043932, -122.423051948693)
166869 239197 2 147 101 Hwy 101 Northbound 9 13 1 1     4     6005924.85036 2109052.04357 37.7713899961886 -122.42288140308001 (37.7713899961886, -122.42288140308)
38314 239164 2 147 1400 Potrero Ave 8 1 1 1     5 Width 2ft   6010663.94961 2101209.37133 37.75012204421029 -122.405935981386 (37.7501220442103, -122.405935981386)
75553 239196 2 147 101 Hwy 101 Northbound 8 13 1 1     3     6005930.84591 2109041.9421200003 37.771362598325 -122.42285994612499 (37.771362598325, -122.422859946125)
82275 109948 8 147 400x CLEMENTINA ST 8 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
85858 91025 1 147 140 South Van Ness Ave 8 1 1 1   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317)
149080 239213 2 147 100 Hwy 101 Southbound 8 13 1 1     5     6005865.35862 2108965.54677 37.771149139741 -122.423081039068 (37.771149139741, -122.423081039068)
34830 239214 2 147 100 Hwy 101 Southbound 7 13 1 1     6     6005859.14445 2108978.35649 37.771183961488106 -122.423103444792 (37.7711839614881, -122.423103444792)
69456 239163 2 147 1400 Potrero Ave 7 1 1 1     4 Width 2ft   6010654.95431 2101230.51738 37.75017960352871 -122.40596857728701 (37.7501796035287, -122.405968577287)
70626 239155 2 147 150 Octavia St 7 4 1 1     7 Width 4ft   6005700.01949 2109925.2105900003 37.7737748138817 -122.42372119899099 (37.7737748138817, -122.423721198991)
103499 108058 1 147 535X Mission St 7 1 1 1   11/19/2014 12:00:00 AM 3 3x3 Permit Number 773596 6013160.27922 2115313.8399 37.7889890532579 -122.39829295327401 (37.7889890532579, -122.398292953274)
113160 109947 8 147 400x CLEMENTINA ST 7 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
133557 239195 2 147 101 Hwy 101 Northbound 7 13 1 1     3     6005938.2626 2109031.33623 37.77133389557179 -122.422833537536 (37.7713338955718, -122.422833537536)
31969 239194 2 147 101 Hwy 101 Northbound 6 13 1 1     3     6005943.751730001 2109019.81978 37.7713025838749 -122.422813731768 (37.7713025838749, -122.422813731768)
76455 239162 2 147 1400 Potrero Ave 6 1 1 1     5 Width 2ft   6010646.644669999 2101254.46555 37.7502448951922 -122.40599899954799 (37.7502448951922, -122.405998999548)
104982 109946 8 147 400x CLEMENTINA ST 6 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
108163 108057 1 147 535X Mission St 6 1 1 1   11/19/2014 12:00:00 AM 3 3x3 Permit Number 773596 6013160.27922 2115313.8399 37.7889890532579 -122.39829295327401 (37.7889890532579, -122.398292953274)
110960 91024 1 147 140 South Van Ness Ave 6 1 1 1   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317)
163715 239158 2 147 101 Octavia St 6 4 1 1     4 Width 4ft   6005617.18186 2109670.5002599997 37.7730707643493 -122.42398963132601 (37.7730707643493, -122.423989631326)
174547 239220 2 147 2730 Bryant St 6 7 1 1     2 Width 7ft   6009770.4944400005 2101313.01983 37.750356630576796 -122.409032927236 (37.7503566305768, -122.409032927236)
18021 108056 1 147 535X Mission St 5 1 1 1   11/19/2014 12:00:00 AM 3 3x3 Permit Number 773596 6013160.27922 2115313.8399 37.7889890532579 -122.39829295327401 (37.7889890532579, -122.398292953274)
76599 114205 2 147 310 Carolina St 5 1 1 1     2 3x3   6012283.24048 2106396.5985 37.7644554605731 -122.40070071026399 (37.7644554605731, -122.400700710264)
93248 109945 8 147 400x CLEMENTINA ST 5 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
105339 82259 1 147 850 South Van Ness Ave 5 1 1 1 1 12/23/2011 12:00:00 AM 3 4x4 Permit Number 768603 6007525.28639452 2104705.22805815 37.759544830410704 -122.417037358657 (37.7595448304107, -122.417037358657)
126197 94767 1 147 10X Waterloo St 5 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
131357 239215 2 147 100 Hwy 101 Southbound 5 13 1 1     2     6005849.76837 2108994.2700400003 37.77122712717 -122.423137008381 (37.77122712717, -122.423137008381)
158471 197028 2 147 2 Waterloo St 5 1 1 1     4 Width 4ft   6010376.04785 2097256.74048 37.739252873912704 -122.40665305401801 (37.7392528739127, -122.406653054018)
165954 239146 2 147 101 Hwy 101 N Off Ramp 5 9 1 1     4 Width 5ft   6005853.9818 2109210.66322 37.7718215286672 -122.423137817777 (37.7718215286672, -122.423137817777)
168811 239193 2 147 101 Hwy 101 Northbound 5 13 1 1     5     6005953.87409 2109001.5556400004 37.771253006051296 -122.42277741983801 (37.7712530060513, -122.422777419838)
176214 239157 2 147 101 Octavia St 5 4 1 1     3 Width 4ft   6005616.09638 2109686.3289099997 37.7731141647188 -122.423994511963 (37.7731141647188, -122.423994511963)
176639 239153 2 147 150 Octavia St 5 4 1 1     3 Width 4ft   6005703.32038 2109897.0428299997 37.773697658347395 -122.423707777507 (37.7736976583474, -122.423707777507)
25154 239161 2 147 1400 Potrero Ave 4 1 1 1     4 Width 2ft   6010627.47447 2101300.53615 37.7503703227358 -122.406068536926 (37.7503703227358, -122.406068536926)
37803 197027 2 147 2 Waterloo St 4 1 1 1     3 Width 4ft   6010417.49048 2097253.73995 37.739246953685395 -122.406509551872 (37.7392469536854, -122.406509551872)
44635 239192 2 147 101 Hwy 101 Northbound 4 13 1 1     6     6005960.3562900005 2108991.91912 37.771226912211795 -122.422754312663 (37.7712269122118, -122.422754312663)
46968 239180 2 147 370 14th St 4 1 1 1     2 Width 3ft   6006264.72566 2107896.23328 37.7682355881421 -122.42162365172301 (37.7682355881421, -122.421623651723)
72859 239145 2 147 101 Hwy 101 N Off Ramp 4 9 1 1     4 Width 5ft   6005859.0162 2109201.52808 37.7717967298683 -122.42311975398701 (37.7717967298683, -122.423119753987)
92212 109944 8 147 400x CLEMENTINA ST 4 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
93976 82832 1 147 165-167 11th St 4 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
104369 91023 1 147 140 South Van Ness Ave 4 1 1 1   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317)
105566 239156 2 147 101 Octavia St 4 4 1 1     5 Width 4ft   6005612.49957 2109700.10187 37.7731517788755 -122.42400793341999 (37.7731517788755, -122.42400793342)
107638 108055 1 147 535X Mission St 4 1 1 1   11/19/2014 12:00:00 AM 3 3x3 Permit Number 773596 6013160.27922 2115313.8399 37.7889890532579 -122.39829295327401 (37.7889890532579, -122.398292953274)
109696 95059 1 147 5115X 03rd St 4 1 1 1     3 3x3   6014711.63884 2094587.79956 37.7321661259618 -122.391475861678 (37.7321661259618, -122.391475861678)
110318 91028 3 147 722 South Van Ness Ave 4 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6007490.257402 2105446.273959 37.761577600545394 -122.417211018518 (37.7615776005454, -122.417211018518)
126209 74507 1 147 165-167 11th St 4 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
130504 114204 2 147 310 Carolina St 4 1 1 1     2 3x3   6012281.598730001 2106430.0070700003 37.764547101481 -122.40070873583599 (37.764547101481, -122.400708735836)
138458 94765 1 147 10X Waterloo St 4 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
184867 239183 2 147 720 South Van Ness Ave 4 1 1 1     3 Width 3ft   6007476.35772 2105397.09343 37.761441780224 -122.41725560676001 (37.761441780224, -122.41725560676)
19680 82786 1 147 1910-12 Keith St 3 1 1 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52461 6015243.83790646 2093539.28137109 37.72931663038511 -122.389562713545 (37.7293166303851, -122.389562713545)
35302 239224 2 147 2850 26th St 3 1 1 1     5 Width 3ft   6010131.271430001 2101077.30272 37.7497296070346 -122.407768710669 (37.7497296070346, -122.407768710669)
35585 239152 2 147 100 Octavia St 3 4 1 1     4 Width 4ft   6005729.11778 2109714.63204 37.773198258533895 -122.42360556863599 (37.7731982585339, -122.423605568636)
44114 239182 2 147 3599 17th St 3 1 1 1     4 Width 3ft   6005021.22782 2106010.41037 37.7629873721785 -122.425790544398 (37.7629873721785, -122.425790544398)
52540 239181 2 147 380 14th St 3 1 1 1     2 Width 3ft   6006215.6761300005 2107893.9456599997 37.7682265409602 -122.42179314696001 (37.7682265409602, -122.42179314696)
61226 239216 2 147 100 Hwy 101 Southbound 3 13 1 1     5     6005843.543219999 2109006.7344400003 37.771261000120504 -122.42315942758499 (37.7712610001205, -122.423159427585)
65016 239173 2 147 3705 25th St 3 1 1 1     6 Width 3ft   6005734.96606 2101372.66505 37.7502935116564 -122.422992320041 (37.7502935116564, -122.422992320041)
68673 249388 2 147 301 Eddy St 3 4 1 1     5 Width 3ft   6008934.66326 2113525.78003 37.78384318556579 -122.41278661472602 (37.7838431855658, -122.412786614726)
72607 197026 2 147 2 Waterloo St 3 4 1 1     3 Width 4ft   6010467.19371 2097248.77404 37.7392360988707 -122.406337349712 (37.7392360988707, -122.406337349712)
80041 91027 3 147 722 South Van Ness Ave 3 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6007490.257402 2105446.273959 37.761577600545394 -122.417211018518 (37.7615776005454, -122.417211018518)
81444 101926 8 147 1099X Hyde St 3 1 1 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639.0 2116135.7 37.790936579280896 -122.417454166812 (37.7909365792809, -122.417454166812)
83671 82942 1 147 236 08th St 3 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52427 6009386.0 2110546.0 37.775686737909496 -122.411014612047 (37.7756867379095, -122.411014612047)
91409 82833 1 147 165-167 11th St 3 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
94383 94764 1 147 10X Waterloo St 3 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
96771 102104 1 147 705X Tehama St 3 1 1 1       3x3 Permit Number 52427 6009386.0 2110546.0 37.775686737909496 -122.411014612047 (37.7756867379095, -122.411014612047)
98771 74661 1 147 165-167 11th St 3 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
100892 109943 8 147 400x CLEMENTINA ST 3 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
101764 22308 3 147 5033 03rd St 3 1 1 2   04/24/2000 12:00:00 AM 3 3x3   6014806.8487599995 2094754.47288 37.7326290611665 -122.39115834308599 (37.7326290611665, -122.391158343086)
121292 22304 3 147 5012X 03rd St 3 1 1 2     3 3x3   6014702.6472 2094891.22359 37.7329987676998 -122.39152815342301 (37.7329987676998, -122.391528153423)
124874 91022 3 147 140 South Van Ness Ave 3 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317)
154686 239219 2 147 2730 Bryant St 3 1 1 1     4 Width 4ft   6009767.82555 2101370.89854 37.7505154031821 -122.409046239907 (37.7505154031821, -122.409046239907)
155009 239231 2 147 391 Church St 3 1 1 1     7 Width 3ft   6004225.7038199995 2106680.81705 37.764783160934 -122.42858977959699 (37.764783160934, -122.428589779597)
Powered by Datasette · Query took 2.944ms · Data source: data.sfgov.org