sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
29152 247788 2 5 0 30th St 4 4 1 1     14 Width 3ft   6004361.25599 2098418.6984200003 37.742104989252894 -122.427532277614 (37.7421049892529, -122.427532277614)
157576 247792 2 5 0 30th St 8 4 1 1     10 Width 3ft   6004127.24522 2098408.26883 37.742063113214996 -122.42834067009 (37.742063113215, -122.42834067009)
163763 247789 2 5 0 30th St 5 4 1 1     14 Width 3ft   6004321.812940001 2098415.77613 37.742094734277 -122.427668451138 (37.742094734277, -122.427668451138)
179978 247790 2 5 0 30th St 6 4 1 1     13 Width 3ft   6004284.58274 2098414.05293 37.742087896749794 -122.42779705870501 (37.7420878967498, -122.427797058705)
54078 175055 2 5 0 Juan Bautista Cir 1 2 1 1     16 Width 6ft   5989631.25858 2089762.2141 37.717492326377396 -122.47783075799299 (37.7174923263774, -122.477830757993)
130572 175056 2 5 0 Juan Bautista Cir 1 2 1 1     16 Width 6ft   5989706.768680001 2089771.1957900003 37.7175213699925 -122.47757041324199 (37.7175213699925, -122.477570413242)
146940 175054 2 5 0 Juan Bautista Cir 1 2 1 1     12 Width 6ft   5989611.995 2089764.5445599998 37.717497607213 -122.477897512877 (37.717497607213, -122.477897512877)
3571 39975 1 5 0 Steiner St 1 1 1 1         Permit Number 41235          
13382 39972 1 5 0 Steiner St 2 1 1 1         Permit Number 41235          
25663 188593 2 5 1 20th St 1 17 1 1     27     6010961.38996 2104652.9831 37.759594070921004 -122.40514986509899 (37.759594070921, -122.405149865099)
73756 188569 2 5 1 24th St 26 23 1 1     5     6017110.36972 2102585.1726599997 37.754258135118796 -122.383739444343 (37.7542581351188, -122.383739444343)
98922 188568 2 5 1 24th St 24 23 1 1     38     6017120.705080001 2102612.3766799998 37.7543334029878 -122.38370559563499 (37.7543334029878, -122.383705595635)
46909 124855 2 5 1 Casa Way 1 1 1 1     7 Width 3ft   6001720.89506 2121441.74849 37.805170835422004 -122.438310816889 (37.805170835422, -122.438310816889)
48401 124856 2 5 1 Casa Way 2 1 1 1     9 Width 3ft   6001727.95085 2121436.12662 37.805155800572706 -122.438285996516 (37.8051558005727, -122.438285996516)
62022 124857 2 5 1 Casa Way 3 1 1 1     6 Width 3ft   6001735.95246 2121430.00924 37.8051394589735 -122.438257867517 (37.8051394589735, -122.438257867517)
49972 220283 2 5 1 Clarendon Ave 8 2 1 1     13 Width 2ft   5998403.60495 2104683.4410599996 37.7589676616433 -122.448582957854 (37.7589676616433, -122.448582957854)
180588 188594 2 5 1 Jack Balestreri Way 2 7 1 1     16     6012410.71719 2104764.5597 37.7599813531633 -122.400145172978 (37.7599813531633, -122.400145172978)
41246 187776 2 5 1 Lane St 24 9 1 1     3 Width 10ft   6017085.142530001 2097027.7274599997 37.7389971337102 -122.383439839679 (37.7389971337102, -122.383439839679)
152191 187774 2 5 1 Lane St 5 9 1 1     4 Width 10ft   6017047.63402 2096978.70465 37.738860453846996 -122.383566116201 (37.738860453847, -122.383566116201)
163207 187775 2 5 1 Lane St 8 9 1 1     5 Width 10ft   6017053.32881 2096987.9359900001 37.7388861160087 -122.383547068563 (37.7388861160087, -122.383547068563)
94339 85503 1 5 1 Nebraska St 5 9 1 1         Permit Number 49678 6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
120969 85508 1 5 1 Nebraska St 2 9 1 1         Permit Number 49678 6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
125232 85499 1 5 1 Nebraska St 2 1 1 1           6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
140801 85504 1 5 1 Nebraska St 6 9 1 1         Permit Number 49678 6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
59248 175001 2 5 1 Newton St 1 2 1 1     10 Width 5ft   6000856.019180001 2088342.93848 37.714240381459 -122.438930350851 (37.714240381459, -122.438930350851)
148080 175002 2 5 1 Newton St 2 2 1 1     8 Width 5ft   6000849.25835 2088363.04115 37.7142951942344 -122.438955158647 (37.7142951942344, -122.438955158647)
158447 175003 2 5 1 Newton St 3 2 1 1     13 Width 5ft   6000843.24005 2088383.1284400001 37.7143500070223 -122.43897739890801 (37.7143500070223, -122.438977398908)
55430 203781 2 5 1 Northwood Dr 2 9 1 1     39 Width 8ft   5995760.050530001 2094044.5460299999 37.729604384015296 -122.45695604179701 (37.7296043840153, -122.456956041797)
150308 203780 2 5 1 Northwood Dr 1 9 1 1     16 Width 8ft   5995711.8389800005 2094094.29693 37.72973821932529 -122.457126310455 (37.7297382193253, -122.457126310455)
145878 89262 1 5 1 Polk St   1 1 2       3x3 Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.41829917319299 (37.7785341058364, -122.418299173193)
24641 203805 2 5 1 San Marcos Ave 2 2 1 1     25 Width 4ft   5993891.16391 2100082.05221 37.7460743755414 -122.463854985838 (37.7460743755414, -122.463854985838)
30886 203804 2 5 1 San Marcos Ave 1 2 1 1     20 Width 4ft   5993878.73057 2100098.05602 37.746117601451104 -122.463899139836 (37.7461176014511, -122.463899139836)
39955 203806 2 5 1 San Marcos Ave 3 2 1 1     26 Width 4ft   5993903.6097099995 2100066.65342 37.746032811564795 -122.463810832713 (37.7460328115648, -122.463810832713)
98074 49016 1 5 1 San Marcos Ave 1 1 1 1         Permit Number 46202 5993947.57587841 2100008.88350341 37.745876723459396 -122.463654612612 (37.7458767234594, -122.463654612612)
86484 46614 1 5 1 Sola Ave 1 1 1 1   04/12/2002 12:00:00 AM     Permit Number 44737 5995007.33907927 2100649.9152063 37.7476978436736 -122.46003655522199 (37.7476978436736, -122.460036555222)
42389 203234 2 5 1 Sotelo Ave 1 2 1 1     21 Width 3ft   5994034.24105 2100880.02581 37.7482736532082 -122.463418145541 (37.7482736532082, -122.463418145541)
68101 203236 2 5 1 Sotelo Ave 3 2 1 1     22 Width 3ft   5994079.6101 2100830.73723 37.7481409330618 -122.463257685817 (37.7481409330618, -122.463257685817)
150145 203235 2 5 1 Sotelo Ave 2 2 1 1     16 Width 3ft   5994059.91015 2100852.12675 37.748198528336 -122.463327358969 (37.748198528336, -122.463327358969)
26454 188657 2 5 100 Cargo Way 123 2 1 1     12     6016750.167669999 2099204.87087 37.744956608177205 -122.38474966268801 (37.7449566081772, -122.384749662688)
28294 188658 2 5 100 Cargo Way 124 2 1 1     10     6016703.96276 2099238.37904 37.7450460592258 -122.384911766374 (37.7450460592258, -122.384911766374)
56563 188656 2 5 100 Cargo Way 122 2 1 1     2     6016757.253769999 2099196.6677 37.7449344758533 -122.384724588679 (37.7449344758533, -122.384724588679)
145989 98513 2 5 100 De Montfort Ave 2 1 1 1     24 3x3 Permit Number 775766 5995016.6 2091971.4 37.723869304698404 -122.459376132933 (37.7238693046984, -122.459376132933)
76755 175031 2 5 100 Desmond St 1 1 1 1     12 Width 3ft   6010533.91342 2086822.6121900002 37.7106117590847 -122.40537260647498 (37.7106117590847, -122.405372606475)
46841 183383 2 5 100 Escolta Way 1 1 1 1     12 Width 0ft   5986644.7173 2097225.5877 37.737811028917996 -122.488701996679 (37.737811028918, -122.488701996679)
20854 11187 3 5 100 Idora Ave 3 11 1 2     12 8   5995309.2253 2099420.08132 37.7443383854121 -122.458903627104 (37.7443383854121, -122.458903627104)
33162 203692 2 5 100 Judah St 3 1 1 1     8 Width 3ft   5994219.3315 2106013.86798 37.762380528552 -122.46315056576 (37.762380528552, -122.46315056576)
65534 203694 2 5 100 Judah St 5 1 1 1     19 Width 3ft   5994198.666809999 2106012.97536 37.762376887211296 -122.46322197193199 (37.7623768872113, -122.463221971932)
137752 203691 2 5 100 Judah St 2 1 1 1     17 Width 3ft   5994228.79771 2106016.63225 37.7623886638276 -122.463118026482 (37.7623886638276, -122.463118026482)
161346 203693 2 5 100 Judah St 4 1 1 1     6 Width 3ft   5994214.99035 2106013.29581 37.762378707443396 -122.46316553855301 (37.7623787074434, -122.463165538553)
48939 124839 2 5 100 Retiro Way 1 1 1 1     8 Width 3ft   6001764.30069 2121488.69691 37.8053022119874 -122.43816397199801 (37.8053022119874, -122.438163971998)
149733 124840 2 5 100 Retiro Way 2 1 1 1     8 Width 3ft   6001764.3271 2121501.21341 37.805336580468996 -122.43816477778999 (37.805336580469, -122.43816477779)
155406 124841 2 5 100 Retiro Way 3 1 1 1     7 Width 3ft   6001779.40776 2121521.29923 37.805392588455895 -122.438114029041 (37.8053925884559, -122.438114029041)
12986 19789 3 5 100 STAIRWAY19 11 1 1 2     18 50ST            
8435 19808 3 5 100 STAIRWAY23 3 1 1 2     12 60ST            
11007 19809 3 5 100 STAIRWAY23 4 1 1 2     12 60ST            
3819 19829 3 5 100 STAIRWAY25 13 1 1 2     6 60X            
16079 19828 3 5 100 STAIRWAY25 12 1 1 2     6 60X            
11240 19966 3 5 100 STAIRWAY41 4 1 1 2     6 25ST            
613 20019 3 5 100 STAIRWAY48 3 1 1 2     6 10ST            
1109 20024 3 5 100 STAIRWAY48 8 1 1 2     12 10ST            
1647 20023 3 5 100 STAIRWAY48 7 1 1 2     12 10ST            
6746 20018 3 5 100 STAIRWAY48 2 1 1 2     12 10ST            
7838 20021 3 5 100 STAIRWAY48 5 1 1 2     12 10ST            
8001 20026 3 5 100 STAIRWAY48 10 1 1 2     6 10ST            
8245 20020 3 5 100 STAIRWAY48 4 1 1 2     6 10ST            
12211 20025 3 5 100 STAIRWAY48 9 1 1 2     12 10ST            
16094 20027 3 5 100 STAIRWAY48 11 1 1 2     6 10ST            
16846 20022 3 5 100 STAIRWAY48 6 1 1 2     12 10ST            
11825 20029 3 5 100 STAIRWAY50 1 1 1 2     12 40ST            
162356 220290 2 5 1000 Jarboe Ave 2 2 1 1     6 Width 3ft   6009373.66263 2096847.13455 37.7380720514781 -122.41008995798401 (37.7380720514781, -122.410089957984)
156554 174988 2 5 1000 Madrid St 3 2 1 1     15 Width 4ft   6001118.27335 2088513.9598599998 37.7147248858297 -122.43803614326099 (37.7147248858297, -122.438036143261)
178719 174989 2 5 1000 Madrid St 4 2 1 1     17 Width 4ft   6001106.19823 2088490.6966400002 37.714660323495394 -122.438076214354 (37.7146603234954, -122.438076214354)
24305 187754 2 5 1000 Oakdale Ave 11 9 1 1     7     6018045.40924 2093280.41562 37.728760777668 -122.37985934635799 (37.728760777668, -122.379859346358)
30738 187755 2 5 1000 Oakdale Ave 12 9 1 1     9     6018042.26935 2093273.64193 37.7287420052256 -122.379869730822 (37.7287420052256, -122.379869730822)
33152 187750 2 5 1000 Oakdale Ave 2 9 1 1     6     6018189.80767 2093163.42935 37.728447520437705 -122.379352023493 (37.7284475204377, -122.379352023493)
64021 187756 2 5 1000 Oakdale Ave 13 9 1 1     15     6018040.44211 2093268.12413 37.728726753622496 -122.379875664545 (37.7287267536225, -122.379875664545)
168868 187752 2 5 1000 Oakdale Ave 4 9 1 1     17     6018083.616719999 2093238.62842 37.7286481456935 -122.379724357202 (37.7286481456935, -122.379724357202)
182989 187753 2 5 1000 Oakdale Ave 5 9 1 1     8     6018088.91826 2093246.2132 37.72866926445229 -122.37970655600901 (37.7286692644523, -122.379706556009)
187072 187751 2 5 1000 Oakdale Ave 3 9 1 1     29     6018129.3732900005 2093209.5083299999 37.7285707113551 -122.379564150189 (37.7285707113551, -122.379564150189)
22456 6155 3 5 1000X Ellis St 3 1 1 2     12 3X3   6005964.03505 2113507.44339 37.7836256530431 -122.42306259308901 (37.7836256530431, -122.423062593089)
22598 6154 3 5 1000X Ellis St 2 1 1 2     18 3X3   6005999.1714699995 2113512.6178599996 37.7836418435489 -122.42294140222602 (37.7836418435489, -122.422941402226)
22757 6156 3 5 1000X Ellis St 4 1 1 2     12 3X3   6005921.456680001 2113500.45313 37.7836040567219 -122.423209401115 (37.7836040567219, -122.423209401115)
80764 6160 3 5 1000X Ellis St 8 1 1 2     12 3X3   6006064.53658 2113525.24895 37.7836802135181 -122.42271616148199 (37.7836802135181, -122.422716161482)
108829 6161 3 5 1000X Ellis St 9 1 1 2     12 3X3   6005784.153390001 2113483.6570900003 37.783550189367794 -122.423683223851 (37.7835501893678, -122.423683223851)
141102 6165 3 5 1000X Ellis St 13 1 1 2     18 3X3   6006064.53658 2113525.24895 37.7836802135181 -122.42271616148199 (37.7836802135181, -122.422716161482)
3903 220233 1 5 1001 Ashbury St 1 9 1 1   05/23/1987 12:00:00 AM 39 Width 4ft Permit Number 12054 5999170.85741 2106639.03394 37.764381073148705 -122.44607010996201 (37.7643810731487, -122.446070109962)
56931 188677 2 5 1001 Evans Ave 1 9 1 1     12 Width 5ft   6018476.48235 2096364.95743 37.7372540964924 -122.37858316699499 (37.7372540964924, -122.378583166995)
124437 7872 3 5 1001 Franklin St 3 1 1 2     12 3X3   6006017.92474 2113680.1220400003 37.7841028269903 -122.42288843164101 (37.7841028269903, -122.422888431641)
138690 249574 2 5 1001 Franklin St 3 4 1 1     13 Width 3ft   6006046.96797 2113547.6658099997 37.78374077347271 -122.42277853591801 (37.7837407734727, -122.422778535918)
29838 174985 2 5 1001 Madrid St 1 1 1 1     12 Width 4ft   6001137.792830001 2088470.92046 37.7146078192813 -122.43796559503299 (37.7146078192813, -122.437965595033)
33982 174986 2 5 1001 Madrid St 2 1 1 1     14 Width 4ft   6001150.38066 2088493.1361099998 37.7146695343409 -122.437923676751 (37.7146695343409, -122.437923676751)
167953 174987 2 5 1001 Madrid St 3 1 1 1     15 Width 4ft   6001163.67681 2088517.0147099998 37.7147358557539 -122.43787942919701 (37.7147358557539, -122.437879429197)
31496 220151 2 5 1001 San Jose Ave 6 7 1 1     8     6005128.65815 2096758.77235 37.7375905832326 -122.42476077930901 (37.7375905832326, -122.424760779309)
60005 220150 2 5 1001 San Jose Ave 5 7 1 1     12     6005133.60427 2096768.5161400002 37.7376176168434 -122.424744371178 (37.7376176168434, -122.424744371178)
161044 220152 2 5 1001 San Jose Ave 7 7 1 1     7     6005125.321690001 2096750.37402 37.737567334864295 -122.424771717755 (37.7375673348643, -122.424771717755)
184741 139925 2 5 1001 TURK ST 1 1 1 1     22 Width 0ft   6005197.5444 2112663.4649 37.78126501367171 -122.425654271119 (37.7812650136717, -122.425654271119)
31 22614 1 5 1001 Turk St 5 1 1 3     24 3x5   6005426.7391 2112695.1691 37.781365013820206 -122.424863625752 (37.7813650138202, -122.424863625752)
85 22613 1 5 1001 Turk St 4 1 1 3     24 3x5   6005358.7073 2112686.5825 37.7813375942673 -122.42509837168001 (37.7813375942673, -122.42509837168)
8575 22617 1 5 1001 Turk St 8 1 1 3   03/25/1997 12:00:00 AM 6 3x5   6005634.7978 2112724.8918 37.781458374599794 -122.424145957729 (37.7814583745998, -122.424145957729)
23206 22612 3 5 1001 Turk St 3 1 1 2     22 3X5   6005303.8855 2112676.675 37.781307293691704 -122.425287323246 (37.7813072936917, -122.425287323246)
88826 22610 1 5 1001 Turk St 1 1 1 3     30 3X5   6005224.1346872 2112659.8569034003 37.7812566094766 -122.425562024881 (37.7812566094766, -122.425562024881)
Powered by Datasette · Query took 35.085ms · Data source: data.sfgov.org